Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation.…
Browsing: SQL
Trust is the currency of the data economy. Without it, even the most advanced platforms and the most ambitious strategies…
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This one surprised me. This is part…
Indexes are fantastic when you’re reading data—and a tax when you’re writing it. Every INSERT/UPDATE/DELETE has to maintain each affected…
I hosted this month, late as it turns out, but we still had a few entries. Here’s a look at…
Every DBA has faced that moment when SQL Server feels like a silent partner. You look at waits like CXPACKET,…
I like to subject myself to agony from time to time. So, I tried to build my SQL Server 2025…
I had a customer recently reach out to ask if SQL Clone would work with 20 backup files. I decided…
In today’s data-driven world, observability is not an optional add-on but a foundational principle. As organizations adopt Microsoft Fabric to…
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on December 10, 2025 – a deep-dive…