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
Tag: #sqldatabase
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
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