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.

Using a gMSA with SQL Server

As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify that this account: Has the […]

The post Using a gMSA with SQL Server appeared first on Wayne Sheffield.

By |February 19th, 2018|SQL, SQL Group|Comments Off on Using a gMSA with SQL Server

Using a gMSA with SQL Server

As you already know, SQL Server runs as a service. And services require a service account to run under. While this service account is likely to be a domain service account, it could be an account on the local machine. To follow good security practices you would need to specify that this account: Has the […]

The post Using a gMSA with SQL Server appeared first on Wayne Sheffield.

By |February 19th, 2018|SQL, SQL Group|Comments Off on Using a gMSA with SQL Server

The case of the missing database backup file

Exploring the wonderful case of a missing database backup. I was working on a client’s site today, setting up database backup routines. Part of which is to perform a database backup, and verify that everything went okay. I had Windows Explorer open to the location that the backup was going to. When the backup finished, […]

The post The case of the missing database backup file appeared first on Wayne Sheffield.

By |December 27th, 2017|SQL, SQL Group|Comments Off on The case of the missing database backup file

The case of the missing database backup file

Exploring the wonderful case of a missing database backup. I was working on a client’s site today, setting up database backup routines. Part of which is to perform a database backup, and verify that everything went okay. I had Windows Explorer open to the location that the backup was going to. When the backup finished, […]

The post The case of the missing database backup file appeared first on Wayne Sheffield.

By |December 27th, 2017|SQL, SQL Group|Comments Off on The case of the missing database backup file

New Features in SSMS 17.3

SSMS 17.3 SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention: Import Flat File Wizard XEvent Profiler Import Flat File Wizard If you’ve worked with SQL Server for very long, you have most likely needed to import flat files from time to time. SSMS 17.3 utilizes […]

The post New Features in SSMS 17.3 appeared first on Wayne Sheffield.

By |October 11th, 2017|SQL, SQL Group|Comments Off on New Features in SSMS 17.3

New Features in SSMS 17.3

SSMS 17.3 SSMS 17.3 was just released (download link), and it has a couple of new features worthy of mention: Import Flat File Wizard XEvent Profiler Import Flat File Wizard If you’ve worked with SQL Server for very long, you have most likely needed to import flat files from time to time. SSMS 17.3 utilizes […]

The post New Features in SSMS 17.3 appeared first on Wayne Sheffield.

By |October 11th, 2017|SQL, SQL Group|Comments Off on New Features in SSMS 17.3

Stop waiting for SQL Server Service Pack 1 before upgrading!

It’s not stable until Service Pack 1… Are you at a company that doesn’t install a new version of SQL Server until Service Pack 1 (SP1) has been released? Well, you need not wait for SP1 any more. Because there’s not going to be any more service packs. Microsoft just announced their “Modern Servicing Module […]

The post Stop waiting for SQL Server Service Pack 1 before upgrading! appeared first on Wayne Sheffield.

By |September 29th, 2017|SQL, SQL Group|Comments Off on Stop waiting for SQL Server Service Pack 1 before upgrading!

Stop waiting for SQL Server Service Pack 1 before upgrading!

It’s not stable until Service Pack 1… Are you at a company that doesn’t install a new version of SQL Server until Service Pack 1 (SP1) has been released? Well, you need not wait for SP1 any more. Because there’s not going to be any more service packs. Microsoft just announced their “Modern Servicing Module […]

The post Stop waiting for SQL Server Service Pack 1 before upgrading! appeared first on Wayne Sheffield.

By |September 29th, 2017|SQL, SQL Group|Comments Off on Stop waiting for SQL Server Service Pack 1 before upgrading!

Working with SQLSaturday SpeedPASSes

SQLSaturday SpeedPASSes I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a script for working with SQLSaturday […]

The post Working with SQLSaturday SpeedPASSes appeared first on Wayne Sheffield.

By |March 9th, 2017|SQL, SQL Group|Comments Off on Working with SQLSaturday SpeedPASSes

Working with SQLSaturday SpeedPASSes

SQLSaturday SpeedPASSes I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a script for working with SQLSaturday […]

The post Working with SQLSaturday SpeedPASSes appeared first on Wayne Sheffield.

By |March 9th, 2017|SQL, SQL Group|Comments Off on Working with SQLSaturday SpeedPASSes