Has this login been used recently?
I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading
2020-04-20 (first published: 2020-04-08)
899 reads
Blog Posts
Make Database Code Reusable in SQL Source Control with Deployment Filters
When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including...
2020-04-20 (first published: 2020-04-08)
478 reads
The Very Best of Extended Events
Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when...
2020-04-20
245 reads
Disk Performance Metrics in AWS and Azure
In the last two posts, we have discussed the different types of storage disks available in the AWS and Azure cloud platforms. We also discussed the characteristics that affect...
2020-04-19
15 reads
Adjusting pod eviction time in Kubernetes
One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones spun up...
2020-04-17 (first published: 2020-04-08)
396 reads
Daily Coping 17 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-17
21 reads
Data Bits – Episode 5 – Louis Davidson
The one and only – Dr. SQL – Louis Davidson (b|t|t|t) stopped by for a chat! Relational Algebra, Disney, Dollywood and a SQL Dump Truck ??
The post Data Bits...
2020-04-17 (first published: 2020-04-08)
280 reads
Decoded Statistics Names and More
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-04-17
6 reads
I’m Speaking at #SQLSatRVA
I am super excited, and humbled, to have been selected to speak at the very first PASS virtual SQL Saturday, SQL Saturday Richmond, on Saturday, April 25, 2020. I...
2020-04-17
16 reads
Daily Coping 16 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-16
29 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers