Check for Errors First, Part III: The Windows Event Logs
In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the noise
June 24, 2015
Category: SQL Server
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting
June 9, 2015
SHUTDOWN SQL Server
Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL
June 3, 2015
Fight The Weeds
Spring time means tuning up the lawn mower, digging out the pruning shears, and testing the sprinklers (at least in
May 7, 2015
Automating DBCC DBTABLE – Obtaining the Disk Sector Size
It’s a best practice to have the disk sector size (also known as the allocation unit size or block size)
April 28, 2015
What is a DBA Worth?
The value of a DBA can vary depending on numerous factors. Something that should be easy to answer is: what
March 31, 2015
Automating DBCC PAGE – Part 3: Is a Clustered Index physically sorted on disk?
In my last few blog posts, I’ve shared several methods of getting internal information from a database by using the
March 25, 2015
Check for Errors First, Part II: The Default Trace
In Part I of Check for Errors First, we discovered how to query the error logs, and filter out the
March 17, 2015
SQL Consultant Braves Weather to Serve Client
Spring may be only weeks away, officially, but the weather is plenty chilly in North Dakota. And Fargo, North Dakota,
March 5, 2015
Automating DBCC PAGE, part 2: Determining object names on pages
In my last post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option. In
February 3, 2015