Index Maintenance Can Change NORECOMPUTE Settings
I had a customer recently ask about a change in one of their constraints on production, where a new option appeared when they went to deploy some changes from...
2025-04-30
137 reads
Blog Posts
So You Think You Should Get a Radio
This is not database related, so if you’re not interested in hearing about something besides SQL Server, PostgreSQL, DevOps, community or data management in general, time to move on....
2025-04-30
32 reads
SQL Server Wait Stats
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-30 (first published: 2025-04-16)
391 reads
Speaking at SQL Saturday Austin 2025
SQL Saturday Austin 2025 is in just a few days. I am honored to be speaking there, and glad to be going back. I’ve missed a number of the...
2025-04-29
56 reads
Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025
I’m excited to announce that on June 17 – 18, 2025, I’ll be running a special Online Live Training event focused entirely on SQL Server Query Tuning! This is...
2025-04-28
27 reads
Updating SSMS is Easy (w/ v21)
I’ve been using the SSMS preview for v21. This is the next evolution of SSMS, where the VS shell is finally being updated. For many of us, SSMS has...
2025-04-28
135 reads
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and Cross Fitters, we tend to be shy and withdrawn about our predilections. BWA-HA-HA! Ok, like...
2025-04-28 (first published: 2025-04-11)
355 reads
Why use XACT_ABORT?
This came up one day at my work when a developer was using it. I hadn’t used it before and thought I’d better check it out. It’s off by...
2025-04-28 (first published: 2025-04-11)
954 reads
Kusto Detective Agency - Intro
While I mostly write about SQL Server, I have a soft spot for Kusto. In this series, I will explore solutions to fun challenges collectively known as the Kusto...
2025-04-27 (first published: 2025-04-26)
110 reads
Building Resilience: Leadership Insights from Sports
In the bustling world of sports, leadership appears as a beacon of hope and direction. Imagine a football team, standing on the brink of a crucial match. The players,...
2025-04-25 (first published: 2025-04-08)
226 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...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers