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 […]
Archives du mois : avril 2026
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 […]