Creating a Date Dimension (Calendar Table) in SQL Server
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to perform operations like calculating business days between two dates or analyzing data over time (e.g., year-over-year, month-to-month). In …
The Waitlist is Open Now for My SQLBits Workshop!
I’m excited to return to London for SQLBits again this year! I’ve written about why SQLBits is my favorite conference, and it’s hard to believe it’s been over a decade since I wrote that post. I still feel the same way about Bit …
The complexity of using Power BI in US Sovereign Clouds
The post The complexity of using Power BI in US Sovereign Clouds appeared first on SQLServerCentral.
Elements of the SQL Server Update Statement
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update Statement. The standard SQL language as defined in the original standard is composed of just a few declarative commands. SQL is describe …
[Video] Office Hours in North Bay, Canada
Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I joined in this year, and before the tournament, sat on the shores of Lake Napissing to answer your top-voted questions from https://pollgab.com/room/brento. …
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.