SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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
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 the essential building blocks, such as
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 this post, we will continue
A Tale of Two DBAs: A Cautionary Tale
“It was the best of database consulting times…it was the worst of database consulting times…” One of the most common things we do here at