Working with MongoDB Shell
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve provided a number of examples of how to run commands in MongoDB Shell (mongosh). However, the exampl …
Tap Tap Tap – Short, Silent SQL Server Tutorials
One of the things I love about TikTok is that it exposes me to wildly new video ideas like this: @tiipititap ? original sound – tiipititap There’s a whole genre of videos in that style – people using tapping plastic pointer fingers on …
Killing a SPID and Checking Rollback progress in SQL Server
The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.
Free Webcast: Avoiding Deadlocks by Query Tuning
Deadlocks used to scare me. I’d get the alert from a monitoring tool, and I’d look around to see if anyone was watching me. If the coast was clear, I’d… delete the notification. Deadlocks were a mystery to me because I didn …
Data Elements on a Nominal Scale
“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan on a T-shirt This is one of my favorite T-shirt gags because it teaches something about data types, scales and measurements. When you hear it, you automaticall …
Free Webcast Tomorrow: Fundamentals of Columnstore
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m teaching Fundamentals of Columnstore, and we’re going to be covering the internals o …
Navigating Your Test Data Challenges: Insights and Solutions
The post Navigating Your Test Data Challenges: Insights and Solutions appeared first on SQLServerCentral.
Introduction to GitHub Actions Part 1: Getting Started
The post Introduction to GitHub Actions Part 1: Getting Started appeared first on SQLServerCentral.
Understanding UNION and UNION ALL in SQL Server
Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve got similar data sitting in different places and you want to see all the unique values, or maybe you want to see everything, even the repeats. UNION …
DAX CASE Statement Functionality using IF, SWITCH and SWITCH True
The post DAX CASE Statement Functionality using IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Windows Clustered MSDTC and SQL Server 2019 mishap
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has …
Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant
It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply …
Fabric Database: Advanced Vector Search Features
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about some advanced features available in both of them. Before analysing these advanced features, we need to understand some concepts abo …
Fundamentals Week 2025 is Coming This Month! Get Your Tickets Now.
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …
Scales & Measurements
The post Scales & Measurements appeared first on SQLServerCentral.