SSMS v22.4.1: Copilot is GA. So What’s It Do Right ...
Copilot in SSMS has two parts. Usually people focus on the pop-out Copilot chat window, and that’s useful […]
Archives du mois : mars 2026
Protecting Transparent Data Encryption Databases
I have gotten a lot of email questions recently about TDE and SQL Server, specifically around the encryption […]
DevOps anti-patterns: what they are and how to avoid them
In software development, DevOps promises faster delivery, increased collaboration, and more reliable deployments. However, many teams unknowingly […]
[Video] Office Hours in North Bay, Ontario
I’m up in North Bay, Ontario, Canada for the 2026 Can-Am Curling Cup run by Aaron Bertrand – […]
How to migrate from on-prem to the cloud: uncovering legacy ...
In this article, Pat Wright explains how to identify hidden risks in legacy applications before moving to […]
Updated First Responder Kit and Consultant Toolkit for March 2026
For the last few years, I’ve slowed the First Responder Kit release down to once per quarter. It […]
How to determine the last value used by a sequence ...
I’ve been a fan of sequences ever since they were added in SQL Server 2012. Prior to […]
Get Free AI Query Advice in PasteThePlan.
At PasteThePlan.com, you can paste execution plans into your browser, then send a link to someone else to […]
The Curious Case of… no buffer pool memory and no ...
Jonathan had a client issue recently where SQL Server’s buffer pool had been forced down to a ridiculously […]
Why the cloud is not a disaster recovery strategy for ...
When AWS stumbled – twice – in October 2025, many teams discovered that “we are in the […]
[Video] Office Hours, Standing in the Ocean Edition
My tripod is probably never gonna recover from the salt water, but the water was so nice that […]
Using Claude Code with SQL Server and Azure SQL DB
Let’s start with a 7-minute demo video – I didn’t edit this down because I want you to […]
How to use refresh tokens in ASP.NET Core – a ...
Today’s applications require robust security to ensure your application’s sensitive and confidential information is not compromised. This […]
Row-Level Security Can Slow Down Queries. Index For It.
The official Azure SQL Dev’s Corner blog recently wrote about how to enable soft deletes in Azure SQL […]
Logical Reads Aren’t Repeatable on Columnstore Indexes. (sigh)
Sometimes I really hate my job. Forever now, FOREVER, it’s been a standard thing where I can say, […]
The SQL Server Transaction Log, Part 3: The Circular Nature ...
(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website […]
IDENTITY vs SEQUENCE in SQL Server – which should you ...
Auto-generated numeric keys are everywhere in relational databases. In SQL Server, two features dominate this space: IDENTITY columns […]
Live avec Jessica Cecchini
« Excellent techniquement, mais instable financièrement ? » Améliorer ça pour les freelances, c’est le métier de […]
[Video] Office Hours: Back in the Bahamas Edition
Yes, I’m back on a cruise ship with another 360 degree video. Lest you think I’m being wildly […]
My thoughts on Redgate’s 2026 State of the Database Landscape ...
I always really look forward to reading Redgate’s annual State of the Database Landscape report, and 2026 […]
SQL101: Indexing Strategies for SQL Server Performance
One of the easiest ways to increase query performance in SQL Server is to make sure that it […]
Who’s Hiring Database People? March 2026 Edition
Is your company hiring for a database position as of March 2026? Do you wanna work with the […]
How to secure MySQL and PostgreSQL in the world of ...
Are you feeling the impact of AI in your daily work? No? Your database might say otherwise. […]
The secret life of database keys
There’s not much to database keys, right? When you build a new table, you add a column […]
March Madness: $699 Blackbelt Bundle!
Spring is already in the air here in Redmond so time for March Madness! Hundreds of dollars lower-than-ever […]