Why AI-driven workflows are important (and how to implement them)
AI-driven workflow automation and orchestration enable faster decisions, greater efficiency, and scalable operations. By combining automation with […]
Archives de l’année : 2026
[Video] How to Tune Indexes Fast
In this 76-minute session, I’ll show you how to use the latest features of sp_BlitzIndex to rapidly improve […]
I Hate The Way You’re Using “It Depends.”
Can I be honest with you for a second? It makes my skin crawl when I hear database […]
Demystifying PIVOT and UNPIVOT in T-SQL
There are few operators in T-SQL that cause developers to scramble for documentation more than PIVOT and […]
Announcing the SSMS StatisticsParser Extension
If you do a lot of query tuning, you’ve probably come across Richie Rump’s StatisticsParser.com. Now, it’s even […]
4 CVEs are affecting Valkey databases. Here’s everything you need ...
There’s now another reason an immediate patch is needed for organizations running Valkey clusters, according to Percona […]
How tampered indexed-view metadata can break cross-database isolation in SQL ...
Indexed view tampering in SQL Server backups can expose cross-database data after restore. In this article, you’ll […]
In 2026, engineering teams are quietly accepting more risk. Here’s ...
Redgate’s 2026 State of the Database Landscape report reveals that people are increasingly willing to accept more […]
PostgreSQL is removing MD5 authentication for passwords. Here’s what it ...
Upcoming versions of PostgreSQL will be phasing out the MD5 hashing method within the authentication infrastructure of […]
[Video] Office Hours in Port
Our cruise ship pulled into port in Victoria, Canada, so before we head out to the Butchart Gardens, […]
Turns Out DBAs Use the Consultant Toolkit, Too
When I first hired Richie over a decade ago, the very first task I assigned him was to […]
How to build a privacy-aware analytics layer with SQL (4 ...
Privacy-aware analytics is the practice of generating insights without exposing PII, helping you stay compliant with laws […]
New Official Documentation on Forced Parameterization
I love me some documentation. For years, I’ve pointed folks to the SQL Server 2008 documentation on Forced […]
Why database ownership is so fragmented in 2026 – and ...
In today’s cloud-driven, multi-platform environments, answering the simple question – who owns that database? – is no […]
It’s Our Anniversary! Let’s Have a Sale!
Way back in May 2002, I posted my first blog post here. I didn’t know what it would […]
How DataOps principles help to reduce GenAI risk and improve ...
John Kerski explains how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. […]
“We want to archive, but we still want to query ...
At least once a month, I get this question from a client: We have big data, and we […]
Why COALESCE might be the most useful SQL function you’re ...
In SQL, handling missing or NULL values is essential for reliable data analysis and application logic. The […]
Free SQL Server Spring Training on Performance Tuning
Times and tech are changing quickly. Let’s get you up to speed on the latest developments to do […]
Who’s Hiring Database People? May 2026 Edition
Is your company hiring for a database position as of May 2026? Do you wanna work with the […]
What are managed identities in SQL Server 2025? A complete ...
Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft […]
Alias DNS vs fichier host vs Alias Client
Quand se pose la question de la migration d’un serveur SQL, se pose inévitablement la question des chaines […]
Free Webcast: Fixing Parameter Sniffing with Index Tuning
When a query is sometimes fast and sometimes slow, there are a lot of ways you can reduce […]
What is chunking, and how does it apply to vectors ...
In this article, Greg Low explains what chunking is, why it matters for embeddings, and how SQL […]
So You Wanna Build an App
I get a lot of emails like this: Hi! I built an app. Can you take a look […]
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 […]