[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 […]
On a nice sunny Saturday, I took the 911 around the Las Vegas canyons, and stopped to answer […]
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
In the final part of this series, learn how to use SQL Server’s SELECT command to retrieve, filter, […]
The post Using the CASE expression instead of dynamic SQL in SQL Server appeared first on SQLServerCentral.
No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your […]
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This […]
I preface a lot of what I write with whether or not it is for a “practical” […]
This is it! You’ve been watching my free live Spring Training classes over the last several weeks, and […]
This installment of our three-part series on SQL commands explores essential SQL commands for inserting, modifying, and deleting […]
Introduction When working with table-valued functions (TVFs) or subqueries, the CROSS APPLY and OUTER APPLY operators provide flexible […]
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived […]
The post Using the Default Trace in SQL Server appeared first on SQLServerCentral.
If you’ve written SQL for a while, you’ve likely bumped into COALESCE and ISNULL. Both are handy for […]
On a sunny Saturday afternoon, I made myself a highball and went through your top-voted questions from https://pollgab.com/room/brento. […]
This first installment of a three-part series introduces essential SQL commands for creating, modifying, and deleting tables within […]
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational […]
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside […]
As started in part 1 of this series, I have set out to test an LLMs ability […]
This is a short series on the Modern Data Platform in Microsoft Fabric. The articles in this series […]
The post Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments appeared first on SQLServerCentral.
To solve a complex business problem, one needs to break the process into smaller solvable steps. Today, we […]
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
This quarter’s release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about […]
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
The post How to Remove Constraints from a SQL Server Table appeared first on SQLServerCentral.
Introduction A calendar or date dimension table is essential for data analysis and reporting. It allows users to […]
I’m excited to return to London for SQLBits again this year! I’ve written about why SQLBits is my […]
PostgreSQL est de plus en plus populaire. Est-ce un bon choix pour remplacer SQL Server on-prem et […]
The post The complexity of using Power BI in US Sovereign Clouds appeared first on SQLServerCentral.
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update […]
Every year, Aaron Bertrand runs a curling tournament up in scenic North Bay where he grew up. I […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
One of the things I love about TikTok is that it exposes me to wildly new video ideas […]
The post Killing a SPID and Checking Rollback progress in SQL Server appeared first on SQLServerCentral.
Deadlocks used to scare me. I’d get the alert from a monitoring tool, and I’d look around to […]
“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan […]
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free […]
The post Navigating Your Test Data Challenges: Insights and Solutions appeared first on SQLServerCentral.
The post Introduction to GitHub Actions Part 1: Getting Started appeared first on SQLServerCentral.
Have you ever needed to combine data from two different tables or queries in SQL Server? Maybe you’ve […]
The post DAX CASE Statement Functionality using IF, SWITCH and SWITCH True appeared first on SQLServerCentral.
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each […]
Je viens de passer près de 40 ans de ma vie dans le domaine des bases de données […]
It’s a tale as old as time. You want to read data. Your mate wants to write […]
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. […]
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder […]
The post Scales & Measurements appeared first on SQLServerCentral.
Microsoft has been talking about the Modern Data Platform for a long time. I first heard about this […]
Ce matin, j’ai eu la chance d’être présent à Las Vegas à la Keynote de la 2eme […]