Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk drawer – everyone uses it, nobody monitors it, and eventually it becomes a bottleneck you...
2025-06-23 (first published: 2025-06-04)
336 reads
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that...
2025-06-23 (first published: 2025-06-09)
373 reads
As data becomes the backbone of modern business, understanding how to manage and analyze it in the cloud is a must-have skill. The DP-900: Microsoft Azure Data Fundamentals certification...
2025-06-22
4 reads
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend, with lots of friends, a family atmosphere, and some amazing speakers from whom I learn...
2025-06-22
6 reads
lackout – n. the sudden awareness that you’re finally over someone, noticing that the same voice that once triggered a cocktail of emotions now evokes nothing at all –...
2025-06-21
6 reads
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the...
2025-06-21 (first published: 2025-06-19)
11 reads
Here’s how these tools can make Kubernetes security easier and help you avoid common pitfalls.Image from haalkab on Pixabay.Kubernetes is hands-down the go-to tool for managing containerized applications, yet it...
2025-06-21
2 reads
Columnstore Indexes in SQL Server – A Practical Guide with Real-World Examples 
What Are Columnstore Indexes? Unlike traditional row-based indexes, Columnstore Indexes organize and store data by...
2025-06-20 (first published: 2025-06-18)
105 reads
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East conference on cyber scams. How bad is it? Well, according to the Internet Crime Complaint...
2025-06-20 (first published: 2025-06-06)
267 reads
All Spark Connect Posts
I have just finished an update for the spark connect dotnet lib that contains the DeltaTable implementation so that we can now use .NET to maintain...
2025-06-20
7 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers