Async stats update causing blocking

I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were...

EightKB 2024 – Schedule and Registration

Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced! We’re kicking off at 1pm UTC on August 8th (8th of the 8th…get it? 🙂...

Export Azure SQL DB to Storage

After a data migration, we needed to decommission the old Azure SQL DBs, but we wanted to keep a copy in case we needed anything later. Enter exporting an...

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server...

Query deadlock info in Azure SQL DB

A couple of weeks ago, a developer came to me and wanted to know how to figure out what was causing a deadlock. I honestly didn’t know where to...

So You Want to Deploy Power BI Project files (PBIPs)?

Have you heard the news about the new Power BI Project files? Okay, maybe not news anymore since it was announced over a year ago. Just in case you...

T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me

DIVERSIFY! We devote a lot of time to mastering the technology that we are passionate about or use for our jobs. For example, I specialized in Microsoft business intelligence,...

DBAs, Organizing Your SQL Scripts in Git

I wrote an article that was published on SQL Server Central on how to get your scripts into Git. This post adds a few more thoughts on how you...

Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines

When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in Fabric, not to be confused with deployment pipelines), you will most likely have some activities...

MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database

As one of the preventive database maintenance tasks, performing database integrity checks on almost every database you...