SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
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 XEvents). There appears to be
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, is where Jared Kirkpatrick, our
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 performance problems are in fact