Trust is the currency of the data economy. Without it, even the most advanced platforms and the most ambitious strategies collapse under the weight of doubt. For Chief Data...
2025-10-30
11 reads
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This one surprised me. This is part of a series of experiments with AI systems. Looking...
2025-10-29
13 reads
For decades, enterprises have approached data management with the same mindset as someone stuffing everything into a single attic. The attic was called the data warehouse, and while it...
2025-10-29 (first published: 2025-10-09)
306 reads
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
22 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)
712 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
13 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
57 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
13 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
25 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
4 reads
By Brian Kelley
This was announced last week at Microsoft Ignite and it's been covered by others...
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Comments posted to this topic are about the item The Ending Substring
Comments posted to this topic are about the item Done is Better than Good,...
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers