Gouvernance Fabric : Autoriser des items Fabric spécifiques sans ouvrir toute la plateforme ?
« Nous voulons que les utilisateurs puissent créer des Data Agents, tout en gardant un contrôle strict sur les permissions de création dans Microsoft Fabric » a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr t …
How to handle large datasets and parallel processing in esProc SPL
As data volumes continue to grow exponentially, the ability to efficiently process and analyze large datasets has become a critical skill for data professionals. In this article, part of the ‘Moving from Python to esProc SPL’ series, learn how to tackl …
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 adopt new versions of SQL Server. There were only slight 1-2% shifts, nothing big: SQL Server 2025: 1% SQL Server 2022: 31%, up 2% from …
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 LAST_QUERY_PLAN_STATS = ON; The system function sys.dm_exec_query_plan_stats is supposed to show you the last actual query plan for a query. I’ve h …
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 static model knowledge. Choosing between local and remote MCP servers affects security, scalability, and integration. In this article, …
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: Finding the Real Cause of Production Slowness. It filled up initially, but they’ve opened up more seats for it, so if you’re interest …
When, and when not, to use LLMs in your data pipeline
“Let’s add LLMs to the pipeline” has become a familiar refrain in modern data teams, but turning that idea into production reality is where things often go wrong. While large language models can unlock powerful capabilities, they’re just as likely to i …
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 of AI-edited code in here. I’m really only putting it out there because I want to let early adopters start playing around with a few new things: sp_BlitzI …
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 What’s Next. I’m excited to share the panel lineup – all of the links go to their LinkedIn profiles: Amy Abel – aka the Database Reliability Spotter …
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 – until now, that is. SQL Server 2025 introduced the REGEXP_SPLIT_TO_TABLE function, offering a more flexible solution …
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 data manipulation capabilities compared to Python. As you may already know, real-world data rarely arrives in a clean, analysis-ready format. You’ll frequent …
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 will offer Extended Security Updates that you can buy for 3 more years, either through Azure or your licensing partner. The price is stunning: …
Announcing More Improvements to PasteThePlan.com
Need to share an execution plan, like on forums or on Stack Overflow, and you wanna get their advice as quickly as possible? Paste the XML into PasteThePlan.com and you get a link that you can share to anyone with your plan’s details. The user interfac …
Cross-database ownership chaining in SQL Server: security risks, behavior, and privilege escalation explained
A dangerous privilege-escalation path exists in SQL Server when cross-database ownership chaining, system database defaults, and overly permissive permissions are combined. Under these conditions, a low-privilege authenticated user can escalate to sysa …
SQLBits Bonus: Free Fundamentals + Mastering Bundle for My Training Day Attendees
Good news! My training day workshop, Dev/Prod Demon Hunters, was sold out, but Bits just moved me into the auditorium with way more capacity and space for you to stretch out. Plus, there’s power and tables at each seat. Feel free to bring your charger, …