White papers, DMVs and Monitoring Concepts
According to Jason Strate (SQL Server MVP) there are 5 white papers ever SQL Server DBA should read. Considering my...
2013-06-01
1,019 reads
Simple SQL Server
Blocking – Capturing and Monitoring
If a query is taking longer to run than normal, there’s a good chance it’s being blocked by something else....
2013-05-22
689 reads
Wait Stats – Monitoring and Using
sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...
2013-05-21
1,841 reads
Indexes – Understanding basic types and their components
The biggest problem developers and newer DBAs have with understanding indexes is that you don’t realize when you’re using the...
2013-05-18
1,455 reads
Indexes – Unused and Duplicates
Indexes aren’t free, and many databases end up with unused indexes. Every time you make any update to a table...
2013-05-16
1,729 reads
Job Schedules – SQL Agent
This info should be easier to get than it is. Keep in mind that for something to run the subscription...
2013-05-15
1,319 reads
Roll Logs – Backup Recovery
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,027 reads
Table Sizes
There’s no simple way in SQL Server to see the sizes of all the tables and their indexes. Even seeing...
2013-05-15
660 reads
Index Columns and Names
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,507 reads
Running Processes
Sp_who2 is not used by this DBA. That info is amazingly good to have, but I want more. Don’t get...
2013-05-14
863 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers