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)
643 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
12 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
29 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
9 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
18 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
3 reads
Ollama SQL FastStart kit just works out of the box. It makes it easy to spin the whole Docker Compose stack not in minutes but seconds! Continue reading →
The...
2025-10-27
27 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)
362 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
17 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
16 reads
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I have a SP that finds the average based on 3 tables. ...
I have a large table with 17M+ rows for our package record audits. I've...