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
Tag: SQLPASS
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
Upgrading From SQL Server Profiler
You may recall an article I had written a couple months back describing how to use Extended Events to perform
April 22, 2015
Where did the Database Go?
What do you do when a developer comes to you and asks, “Where did the database go? The database was
April 7, 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
How To: XEvents as Profiler
A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka
March 11, 2015
Check for Errors First, Part I
I have seen a number of environments concerned with performance issues, and jump to looking at performance metrics when these
February 24, 2015
How to: File Target use in Extended Events
I have been doing a lot of posts of late about extended events but have failed to share some of
February 17, 2015