Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL Server 2025 has a much better solution: the change feed.
Restoring SSAS Cubes to a SQL 2022 Server with CU5
I have a client who was...
How to Change the Browser Used by SSMS for AAD Auth
Did you know that you can...
pandas.DataFrame.drop_duplicates and SQL Server unique constraints
I’ve now helped people with this...
Check if File Exists Before Deploying SQL Script to Azure SQL Managed Instance in Azure Release Pipelines
I have been in Azure DevOps...
New Centralized View of SQL Resources in Azure
Yesterday some new views were made...
Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running
I have a client who uses...