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...

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...

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...

Using the Pure Storage PowerShellSDK2 - Part 5 - Checking Replication Status

Introduction Welcome back to the fifth installment of our blog series on using the Pure Storage PowerShell SDK2. In this post, we’re diving into a hands-on demonstration of using...

New Pluralsight Course - Certified Kubernetes Administrator - Performing Cluster Version Upgrades

We’re working through the major refresh of my Certified Kubernetes Administrator series at Pluralsight!
The next course “Certified Kubernetes Administrator: Performing Cluster Version Upgrades” in the updated series is now...

What I actually do at Microsoft

I started working at Microsoft in January 2022. I enjoy it. I even wrote a stream-of-consciousness post about it last year. A significant part of our job in the...

Talkie - a simple, private, responsive interface for LLMs

Watch this video on YouTube
I like using ChatGPT. But I don't like the $20/month price tag for using OpenAI's app, especially given the API costs fractions of a cent.
So...

Talkie - a simple, private, responsive interface for LLMs

Watch this video on YouTube
I like using ChatGPT. But I don't like the $20/month price tag for using OpenAI's app, especially given the API costs fractions of a cent.
So...

Purging SQL Server Backup History

It seems like every few weeks I come across a database server with a very large msdb. After a small amount of investigation work, I determine that the largest...

System Views in Microsoft Fabric – Query references an object that is not supported in distributed processing mode

I have a metadata-driven ELT framework that heavily relies on dynamic SQL to generate SQL statements that load data from views into a respective fact or dimension. Such a...