DBAs and the Dark Closet
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,025 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
New DMO in Azure SQL Database: sys.dm_db_wait_stats
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....
2013-02-04
1,403 reads
Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,884 reads
Saving Execution Plans on Azure SQL Database
In my previous post showing how to get to execution plans in the Database Management Portal, I showed that it’s...
2013-01-23
1,836 reads
Pro SQL Server 2012 Practices: Chapter 12
I was very privileged to get the opportunity to write a chapter in a book with some of my friends...
2013-01-21
1,103 reads
Execution Plans on Azure SQL Database Portal
If you’ve been working with the Azure SQL Database portal, you know that you have a query window. Within the...
2013-01-16 (first published: 2013-01-14)
1,852 reads
You Can Say “No”
I heard about this new law that was passed to prevent employers from asking for your social media passwords. After...
2013-01-16
973 reads
How to write a custom metric
You can extend SQL Monitor to track whatever you need to watch on your own system with custom metrics. Grant Fritchey shows us how.
2013-01-15
2,464 reads
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
2013-01-11 (first published: 2008-11-07)
2,731 reads
Statistics Update Clarification
By default statistics are created automatically within SQL Server. And, by default, these stats are updated automatically based on a...
2013-01-11 (first published: 2013-01-07)
2,525 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers