Working with the registry in SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the
April 2, 2020
Author: Wayne Sheffield
SQL Server ’16 helps you meet Best Practice
In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need
March 15, 2016
SQL Solutions Group’s 5th Anniversary FreeCon
In honor of SQL Solutions Group turning five years old, the four MCMs at SSG recently conducted a day of
November 10, 2015
FreeCon, October 27, 2015 Seattle
The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]
The post FreeCon, October 27, 2015 Seattle appeared first on Wayne Sheffield.
September 23, 2015
XE Output: Weaning yourself off of SQL Profiler, Part 2
In my last post, I shared a script that will take a running trace and show you the XE events
July 8, 2015
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting
June 9, 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
Persisting DBCC output data
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result
November 26, 2014
SQL Go Fast button
When investigating a performance issue, the desired end result is already known… you need to make the queries run faster.
July 15, 2014