Database Animations: The Difference Between Row Compression and Page Compression
What's the difference between SQL Server's row compression and page compression, and when does each one make sense?
How Can SQL Server Detect Application Errors When Developers Can’t?
How a simple Extended Events session can turn you from a silent guardian to a developer’s best ally. There is an old, undeniable paradox in the life of a Database Administrator: If you do your job perfectly, nobody remembers you exist, only when you resolve problems. When queries are fast, backups are pristine, and the […]
Preserving Data
Today Steve has a few comments on backups and your ability to get to a restore in the event of an issue with your provider.
Configure SSMS Dark Mode Step By Step
You’re using SQL Server Management Studio (SSMS) and would like to use Dark Mode. You’ve looked at the configuration options and don’t see a way to configure it.
When the Token Meter is Zero
DBAKevlar disccusses the new product from Perplexity and Nvidia that just shipped on August 25th. If you haven’t been paying attention its goal is businesses whose entire generative AI solution has been what the AI bubble is betting on.
Understanding Temp Tables and Table Variables in SQL Server
Introduction When building application backends or processing complex data sets in a SQL Server, we frequently need a temporary storage to hold the intermediate query results. For example: Store filtered rows before joining them to another table Hold calculation results inside a stored procedure Break a complex query into smaller readable steps Process a small […]
How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.
Admin Rights for Everyone
Steve thinks administrator rights for too many people is a bad idea, but even when it's a limited group, he recommends some sort of governance.
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Learn how you can enable map your security roles in Aurora PostgreSQL to AD groups using Kerberos.
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