Wayne Sheffield

About Wayne Sheffield

I’ve been involved with technology for 36 years. Since 1998, I’ve been working with SQL Server, since version 6.5. I am a Microsoft Certified Master and Microsoft Certified Solutions Master (and all those prerequisites). Earning my MCM has definitely been a career highlight for me. Even with that under my belt, I welcome any opportunity to learn new things about SQL. I love tuning queries for optimal performance, and automating tasks. I co-authored SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach, frequently participate and present at SQL Server events (including SQLSaturday’s), and I write for SQLServerCentral.com. The most rewarding project I have been a part of, to date, is my marriage. Career-wise, it would be the journey to earning my MCM.

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 registry within your T-SQL scripts. As it turns out, there are several undocumented extended stored procedures in SQL Server that do just this. A listing of these procedures are:

Regular
Instance-Aware

sys.xp_regread
sys.xp_instance_regread

sys.xp_regenumvalues
sys.xp_instance_regenumvalues

sys.xp_regenumkeys
sys.xp_instance_regenumkeys

sys.xp_regwrite
sys.xp_instance_regwrite

sys.xp_regdeletevalue
sys.xp_instance_regdeletevalue

sys.xp_regdeletekey
sys.xp_instance_regdeletekey

sys.xp_regaddmultistring
sys.xp_instance_regaddmultistring

sys.xp_regremovemultistring
sys.xp_instance_regremovemultistring

 

As you can see, there are two […]

By |August 2nd, 2016|SQL Group|2 Comments

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 to follow. The SQL Health Check that you can have us perform on your  instances looks at many of these. SQL Server 2016, which at the time of this writing is in a Release Candidate […]

By |March 15th, 2016|SQL Group|0 Comments

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 free training for the SQL community. Due to the many meetings going on Tuesday in conjunction with the PASS Summit, attendees were coming and going all day long.

The day started off with Ben Miller talking […]

By |November 10th, 2015|SQL Group|0 Comments

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.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

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.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

Combating SQL Injection

Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common? They are all recent victims of cyber-attacks – several of these are confirmed to involve SQL Injection. Even though the exact method used to penetrate the other systems has not been released, experts believe that […]

By |September 16th, 2015|SQL Group|0 Comments

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 that it relates to, and what columns are available within those XE events. Specifically, this was for converting a deadlock trace into an XE session; however the process is the same for converting any trace […]

By |July 8th, 2015|Extended Events, SQL Group|0 Comments

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 issues – some use XE, and some use traces. We’ve all been told that XE is a much better system (it is much more lightweight, causing less of an issue with the server). In fact, […]

By |June 9th, 2015|Extended Events, SQL Group|2 Comments

Automating DBCC DBTABLE – obtaining the disk Sector Size

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results. So, two things immediately jumped […]

By |April 28th, 2015|SQL, SQL Group, SQL Server|2 Comments

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 the “WITH TABLERESULTS” option to be allowed to automate this process for further processing.

This post will also do this, but in this case, we’ll be using it to bust a […]

By |March 25th, 2015|SQL Group|0 Comments