Split Large Queries in Athena with a Simple Modulo Trick
Learn how you might balance the load in Amazon Athena when you have large partition windows.
Today's AI
Are GenAI models getting better? Is today's model the worst one you'll use in the future? Steve has a few thoughts.
Using Friendly Names for SQL Servers via DNS
At my organization, servers have a very cryptic name or a name where you can’t immediately tell the function. For instance, Amazon is the name of the SQL Server which our SharePoint uses as a back-end and Nile is the SQL Server hosting the databases for our HR application. This isn’t intuitive and it makes upgrading the servers a challenge because we always have to go back and touch the applications
Four Rules for Adding AI Without Breaking What Already Works
Kellyn talks about the four golden rules when adding AI features to existing applications and systems.
Optimized Locking in SQL Server 2025
Learn about Optimized Locking in the latest versions of SQL Server and Azure SQL Database.
How to mirror data from SQL Server to Microsoft Fabric: complete guide
Learn all about Microsoft Fabric mirroring for SQL Server: how it works, what's new in 2025, setup, limitations, and troubleshooting
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
This final level focuses on the practical application of changesets in complex scenarios. From table transformations to ETL-driven logic, it explores how to manage database changes when rollback is no longer purely structural, emphasizing control, predictability, and pragmatic solutions.
You Need a DBA Pipeline
Steve notes that DBAs need a privileged pipeline, separate from what they might use to update database schema.
Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.
You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
SQL Server Vector Support II
Comments posted to this topic are about the item SQL Server Vector Support II
Great Things
Comments posted to this topic are about the item Great Things
Troubleshooting Slow Queries That Already Have an Index
Comments posted to this topic are about the item Troubleshooting Slow Queries That Already...
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers