If your production SQL Servers are still running 2016 (or older) you’re basically banking on inertia. Sure, it’s been stable. But that doesn’t guarantee it’ll stay safe or compliant....
2025-10-29
30 reads
Truncate Table Pitfalls
Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly. If you want the speed without the face-palm moments, here’s a practical, interview-ready guide to...
2025-10-29 (first published: 2025-10-08)
879 reads
I hosted this month, late as it turns out, but we still had a few entries. Here’s a look at the blogs people published. First as always, Rob Farley...
2025-10-28
19 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely
Indexes are fantastic when you’re reading data—and a tax when you’re writing it. Every INSERT/UPDATE/DELETE has to...
2025-10-28
691 reads
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for Friday afternoon, so I'll be around for the regular conference from Tuesday evening through Friday....
2025-10-27
17 reads
In today’s data-driven world, observability is not an optional add-on but a foundational principle. As organizations adopt Microsoft Fabric to unify analytics, the ability to see into the inner...
2025-10-27
39 reads
I’ve been enjoying Ben Weissmann (Blog | LinkedIn) & Jess Pomfret’s (Blog | LinkedIn ) weekly program Finding Data Friends for a couple years now, getting to know (by...
2025-10-27
7 reads
Update for SQL Server 2025:
This post and the GitHub repo have been updated for SQL Server 2025 RC1 and Ubuntu 24.04.
New in SQL Server 2025: You no longer need...
2025-10-27 (first published: 2025-09-29)
398 reads
I had a customer recently reach out to ask if SQL Clone would work with 20 backup files. I decided to test this. This is part of a series...
2025-10-27
27 reads
I’m excited to announce my brand-new SQL Server 2025 Unleashed live online training on December 10, 2025 – a deep-dive day dedicated to exploring the next generation of Microsoft’s...
2025-10-27
41 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers