[Video] Office Hours: Hello Kitty Porsche Edition
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer […]
Sites anglophones
How to Load a Date Dimension in Microsoft Fabric using ...
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
Introduction to SQL Commands, Part 3: Retrieving and Sorting Data
In the final part of this series, learn how to use SQL Server’s SELECT command to retrieve, filter, […]
Using the CASE expression instead of dynamic SQL in SQL ...
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
Building AI Calls into the First Responder Kit
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your […]
Sponsoring PGDay Chicago this week
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This […]
Exploring the SQL Server CHOOSE Function
I preface a lot of what I write with whether or not it is for a “practical” […]
It’s Time for Fundamentals Week! Register for Tomorrow’s Classes.
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and […]
Introduction to SQL Commands, Part 2: Adding, Updating Data
This installment of our three-part series on SQL commands explores essential SQL commands for inserting, modifying, and deleting […]
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
SQL Saturday Richmond Roundup
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived […]
Using the Default Trace in SQL Server
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
The Subtle Differences Between COALESCE and ISNULL
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
[Video] Office Hours in the Home Bar
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. […]
An Introduction to SQL Commands, Part 1
This first installment of a three-part series introduces essential SQL commands for creating, modifying, and deleting tables within […]
A Method for Managing Hierarchies in PostgreSQL
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational […]
Your SQL Server Needs Spring Cleaning, Too.
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside […]
LLM Technical Editor Test – ChatGPT with a VERY wrong ...
As started in part 1 of this series, I have set out to test an LLMs ability […]
The Fabric Modern Data Platform
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
Securing the DevOps Pipeline Part 1: Tools and Strategies for ...
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard ...
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
Oracle’s Limited Cloud Vendor Licensing
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
Updated First Responder Kit and Consultant Toolkit for April 2025
This quarter’s release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about […]
New Series – Testing LLMs as Technical Editors
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
How to Remove Constraints from a SQL Server Table
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
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 […]
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 […]
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 […]
[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 […]
Working with MongoDB Shell
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
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 […]
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 […]
Data Elements on a Nominal Scale
“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan […]
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 […]
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 […]
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 […]
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 […]
Fabric Database: Advanced Vector Search Features
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. […]
Fundamentals Week 2025 is Coming This Month! Get Your Tickets ...
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
Scales & Measurements
The post Scales & Measurements appeared first on SQLServerCentral.
Create Raw Zone Tables using Generative AI: Data Engineering with ...
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this […]
Free Webcast Tomorrow: Fundamentals of TempDB
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
Sponsoring SQL Saturday Richmond This Week
On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. […]
Managed Instance Gotchas – Error Conditions
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]