Database Administrator

Business Continuity and Disaster Recovery in Azure SQL

Business Continuity and Disaster Recovery in Azure SQL 

Business continuity is a foundational requirement for database platforms. Azure SQL provides multiple layers of resiliency that protects your data, maintains availability, and enables recovery from both localized failures and large-scale regional outages. (Download Presentation from Data Saturday Chicago) Let’s break down how the concepts of Business Continuity and Disaster Recovery (BCDR) works in Azure SQ. We…

Database Instructions with Copilot and SSMS

Using Database Instructions with GitHub Copilot

Microsoft recently announced updates and fixes for SSMS 22.3. While the release included many quality-of-life fixes, it also introduced a deceptively powerful addition called Database Instructions. This feature stood out to me as it can fundamentally changes how GitHub Copilot understands your database, not just its schema, but its meaning….

TempDB Improvements in SQL Server 2025

TempDB Improvements in SQL Server 2025

TempDB has consistently been regarded as one of the most essential and, historically, overlooked components within SQL Server. When TempDB goes wrong, it rarely fails quietly. A single runaway query, poorly designed report, or unexpected workload spike can consume TempDB space and bring an entire instance to its knees. With…

Accelerated Database Recovery in SQL Server 2019

Accelerated Database Recovery in SQL Server

Accelerated Database Recovery (ADR) is one of the most impactful engine changes introduced with SQL Server 2019. The goal of ADR is to dramatically reduce database recovery and rollback time, even in the presence of long‑running transactions.  What Is Database Recovery?  In a previous post, I discussed the SQL Server Restore and Recovery…