In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks, compliance protocols, and technical safeguards. These “guardrails” are necessary, but not sufficient. Because AI isn’t...
2025-07-25
26 reads
📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because it’s used by every session and process, TempDB is often a performance bottleneck—especially...
2025-07-24
1,277 reads
Will adding generative AI to your data project improve the outcomes? It might, but it’s not guaranteed. It can be harmful and costly to add generative AI in the...
2025-07-23
1,071 reads
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
10 reads
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
9 reads
Boost Your Azure Fabric Pipelines: Don’t Overlook This Crucial Spark Setting Are your Azure Fabric pipelines with multiple notebooks running slower than you’d like? Are you paying for more...
2025-07-23
130 reads
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But don’t be fooled: there’s still a post-install checklist...
2025-07-23
43 reads
In today’s enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure and scale operations across borders, the challenge is no longer just about moving fast –...
2025-07-22
59 reads
I’m honored to be speaking at the PASS Data Community Summit in Seattle this fall. I’ll be delivering a Professional Development session (Blogging for the Tech Professional), which might...
2025-07-22
46 reads
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases and what you need to know in order to use them yourselves.
2025-07-21
116 reads
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
Comments posted to this topic are about the item Create an HTML Report on...
While doing some housekeeping activity on several old but large production databases, I come...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers