SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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) set to 64kb (see this
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 your SQL Server Profiler duties.
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 there one minute, and the
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 is a DBA worth? If
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 DBCC PAGE command and utilizing
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 noise to find meaningful errors