SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
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