Database Animations: Stop Using Page Splits to Justify Lowering Fill ...
You’re looking at page split numbers in a monitoring tool or Perfmon, and you’ve heard that page splits […]
Archives du mois : septembre 2026
The one big difference between MySQL and MariaDB you may ...
The big difference between MySQL and MariaDB largely revolves around database storage engines and anything related to […]
How test data management helps meet DORA’s resilience testing requirements
DORA requires financial institutions to run tests that prove their systems can withstand operational disruption without exposing […]
Join Me at Day of Data Orlando Next Month
Next month on Saturday, October 17, I’ll be speaking at the free Day of Data Orlando. Registration is […]
What happens when your AI coding agent starts a database ...
At the end of the previous article in my series on building an app and database almost […]
[Video] Office Hours: Open Q&A for Microsoft Databases
Today I’m back in the home office, finishing up teaching Mastering Index Tuning and getting ready to head […]
Live Class Enrollment Opens Soon – For Just $995!
I teach Microsoft SQL Server performance tuning in a 4-class rotation. The winter rotation is getting ready to […]
Should your SQL Server database use foreign key constraints?
Foreign key constraints exist to stop bad data before it happens, yet plenty of production SQL Server […]
“But NOLOCK won’t hurt me if I’m using an index!”
NOLOCK is bad and you probably shouldn’t use it, but every time I mention that publicly, the pushback […]
How a Microsoft-signed SQL Server stored procedure lets sysadmins bypass ...
SQL injection inside Microsoft-signed system stored procedures is not supposed to happen. Yet, as I’ve been documenting […]
How to delete personal data for GDPR & CCPA compliance
Deleting a customer’s personal data under GDPR or CCPA means erasing it everywhere it’s stored — not […]
Détecter des opérations spécifiques sur une capacité Microsoft Fabric
« Nous avons créé une capacité Copilot dédiée. Mais comment savoir que Copilot s’exécute réellement dessus, et […]
[Video] Office Hours on Mount Charleston
For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the […]
How to avoid demo fails when presenting at tech conferences
Roughly two out of every three tech conference session demos fail — that’s according to experienced attendee […]
Database Animations: How SQL Server’s JSON Indexes Work
By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to […]
Bi-directional logical replication in PostgreSQL: a practical guide
Logical replication has long been a feature of many database management systems. It’s the simple process of […]
Set Your Application Names Before You Wish You Had.
When you run monitoring queries like sp_BlitzWho and sp_WhoIsActive, you wanna see the program names that are running […]
How to mirror data from SQL Server to Microsoft Fabric: ...
Mirroring in Microsoft Fabric is useful when you need to make SQL Server data available in Fabric. […]
[Video] Office Hours: Stoicism in the Home Office
I’m back in the home office this week, covering your top-voted questions from https://pollgab.com/room/brento, and we finish up […]
Learning PostgreSQL with Grant: Preparing for the PostgreSQL certification
I want to be up front and honest: I suspect I’ll fail this. However, I’m going to […]
Who’s Hiring Database People? September 2026 Edition
Is your company hiring for a database position as of September 2026? Do you wanna work with the […]
SQL Server login failures: how to monitor, report, and alert ...
Failed logins are one of the clearest early-warning signs of trouble on a SQL Server – whether […]
Free Webcast: You Shouldn’t Use SQL Agent for Batch Processes.
SQL Server Agent is a solid scheduler for database administration and simple, database-local automation. In a small to […]