Speaking at PASS Summit 2025
In less than one month, I will be speaking not once but twice at PASS Data Community Summit 2025.
Thursday, November 20th at 1 PM I will be in the...
2025-10-20
13 reads
Blog Posts
The End of Year Vacation Burn
It’s been a good year for me. With my sabbatical, I felt like I’ve gotten away from work quite a bit this year. I’ve had a few vacations around...
2025-10-20
17 reads
Announcements from the Microsoft Fabric Community Conference
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Vienna) recently. Here are all the new features that I found most interesting, with...
2025-10-17 (first published: 2025-09-24)
1,605 reads
The Book of Redgate: Don’t be an a**hole
This was one of the original values: The facing page has this text: No matter how smart you are, or how good you are at narrowly defined tasks, there...
2025-10-17
171 reads
The Challenge of Implicit Transactions: #SQLNewBlogger
I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...
2025-10-17 (first published: 2025-09-24)
307 reads
A Broken Copilot Query
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into an interesting issue. This is part of a series of experiments with AI systems. My...
2025-10-16
152 reads
Set Theory vs. Batch Mode in SQL Server
Set Theory vs. Batch Mode in SQL Server
Not long ago, a colleague of mine was completely shocked when he first heard about SQL Server’s Batch Mode feature. His immediate...
2025-10-15 (first published: 2025-09-23)
583 reads
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL Server 2025, those footprints point us straight toward the next big feature: optimized locking. And...
2025-10-15 (first published: 2025-09-24)
1,441 reads
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
There was a time when the Chief Data Officer lived in the shadows of the enterprise. Their office lights burned late into the night as they combed through spreadsheets...
2025-10-14
14 reads
SQL Server Upgrades
I’ve had this conversation at least a 1000 times over the course of my career working with SQL Server and teaching classes. Is it better to upgrade in place...
2025-10-14
2 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers