So You Wanna Build an App
I get a lot of emails like this: Hi! I built an app. Can you take a look […]
Archives de l’année : 2026
How to get 80% of GPT-4’s value for 20% of ...
AI model costs can explode fast – and overpaying is common. The reality is, you don’t need […]
You Can’t Trust “Edit Query Text” in SSMS’s Execution Plans.
When there are IF branches or conditional logic, “Edit Query Text” only shows you the branches that actually […]
What is fillfactor in PostgreSQL – and when should you ...
fillfactor in PostgreSQL controls how full table or index pages are. The lower the fillfactor, the better […]
What are the top database platforms in 2026? A look ...
The database market in 2026 remains stable at the top, with AWS, Microsoft, Oracle, and Google Cloud […]
There Are Days When I Feel Like Giving Up on ...
In theory, SQL Server performance monitoring is pretty simple: Review the server’s top wait types Find the queries […]
Vibe coding and databases: the hidden risks of AI-generated database ...
“Vibe coding” with AI can introduce hidden risks in database development, including security vulnerabilities, broken query logic, […]
Contest Winners: Make the Comments Look Like My ChatGPT History.
I asked y’all to make the comments on this post look like my ChatGPT history, and y’all understood […]
Gouvernance Fabric : Autoriser des items Fabric spécifiques sans ouvrir ...
« Nous voulons que les utilisateurs puissent créer des Data Agents, tout en gardant un contrôle strict […]
How to handle large datasets and parallel processing in esProc ...
As data volumes continue to grow exponentially, the ability to efficiently process and analyze large datasets has […]
SQL ConstantCare® Population Report: Spring 2026
It’s time for our quarterly update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks […]
There’s a Bug in sys.dm_exec_query_plan_stats.
When you turn on last actual plans in SQL Server 2019 and newer: ALTER DATABASE SCOPED CONFIGURATION SET […]
Local vs remote MCP servers – which should you choose?
MCP (Model Context Protocol) servers let AI apps access real-time data and external tools, improving accuracy beyond […]
Building My Dev/Prod Demon Hunters Session, Part 2: The Tactics
This week at the SQLBits conference in Newport, I’m teaching an all-new all-day session called Dev-Prod Demon Hunters: […]
When, and when not, to use LLMs in your data ...
“Let’s add LLMs to the pipeline” has become a familiar refrain in modern data teams, but turning […]
Updated First Responder Kit and Consultant Toolkit for April 2026
If there was ever a release you should skip for reliability reasons, it’s this one. There’s a lot […]
Announcing the Panel Lineup for My SQLBits Cloud Discussion
At SQLBits, I’m hosting a panel discussion called 20 Years of the Cloud: What Changed, What Didn’t, and […]
Can SQL Server 2025’s REGEXP_SPLIT_TO_TABLE fix STRING_SPLIT in T-SQL?
String splitting in T-SQL has historically been inefficient and limited. While STRING_SPLIT improved things, its constraints remained […]
Data manipulation techniques in esProc SPL: a complete guide
In this article, part of the “Moving from Python to esProc” series, we’ll look at esProc SPL’s […]
SQL Server 2016 Support Ends in 90 Days.
On July 14, 2026, Microsoft’s extended support ends for SQL Server 2016. Brent Ozar Unlimited circa 2016 They […]
Announcing More Improvements to PasteThePlan.com
Need to share an execution plan, like on forums or on Stack Overflow, and you wanna get their […]
Cross-database ownership chaining in SQL Server: security risks, behavior, and ...
A dangerous privilege-escalation path exists in SQL Server when cross-database ownership chaining, system database defaults, and overly […]
SQLBits Bonus: Free Fundamentals + Mastering Bundle for My Training ...
Good news! My training day workshop, Dev/Prod Demon Hunters, was sold out, but Bits just moved me into […]
Data analysis in Python and esProc SPL compared – what ...
In this article, part 3 of the “Moving from Python to esProc SPL” series, you’ll discover the […]
[Video] Office Hours: Microsoft Database Q&A
Let’s go through a LOT of your top-voted questions from https://pollgab.com/room/brento on a VERY early Saturday morning. 00:00 […]
Everything you need to know about MongoBleed (CVE-2025-14847)
MongoBleed (CVE-2025-14847) was defined as “the vulnerability of the year.” In this article, find out what it […]
Contest: Make the Comments Look Like My ChatGPT History.
Let’s have some fun. Put yourself in the frame of mind of the fella who writes this blog. […]
How Multi-Column Statistics Work
The short answer: in the real world, only the first column works. When SQL Server needs data about […]
How to minimize downtime in a cloud migration
Pat Wright details how to plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, […]
Who’s Hiring Database People? April 2026 Edition
Is your company hiring for a database position as of April 2026? Do you wanna work with the […]
SQL Server 2025 CU4 Adds Automatic Updates
Big news for everyone who has to manage Microsoft SQL Server, whether they’re DBAs, sysadmins, or developers. Seven […]
First Normal Form (1NF): Breaking the ‘unbreakable rule’ in database ...
First Normal Form (1NF) is the most widely known rule in database normalization. It requires that tables […]
How to Draw Line Graphs in SSMS
Ever just need a quick visualization of some numbers to get a rough idea of the trend, like […]
How to set up a data analysis environment in esProc ...
This article is the first in this six-part “Moving from Python to esProc SPL” series. You’ll learn […]
I’m Coming to the PASS Summit in Frankfurt!
The pre-conference lineup for the PASS Data Community Summit Frankfurt event was just released, and I’m proud to […]
How User-Defined Types work in PostgreSQL: a complete guide
I’m sure I’m not alone when I say, sometimes I get sidetracked. In this particular instance, I […]
[Video] Office Hours: Q&A on the Mountaintop
Well, maybe mountain is a bit of a strong word, but it’s one of the highest elevation home sites […]
SQL101: Top Ten SQL Server Performance Tuning Best Practices
There are a huge number of best practices around SQL Server performance tuning – I could easily write […]
Y’all Are Getting Good Free AI Advice from PasteThePlan.
PasteThePlan has a new AI Suggestions tab, and it’s been really fun to watch the query plans come […]
Everything you should know about the SQL Server Resource database
Every SQL Server instance contains a database that most people never query, never back up, and never […]
My Wish List for SQL Server Performance Features
There are a lot of shopping days left before Christmas, and even more before the next version of […]
Why most enterprise AI projects fail – and how to ...
Today’s AI landscape is characterized by a gap. While it is often relatively easy to reach the […]
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 […]
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 […]