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

Spectre and Meltdown Exploits

Spectre and Meltdown
In recent weeks, a significant security risk was exposed. This exploit has been named in two fashions: Spectre and Meltdown. We at SSG feel it important to help disclose the severity and impact of these exploits with this formal release.

Unauthorized Memory Disclosure through CPU Side-Channel Attacks

(“Meltdown” and “Spectre”)

Overview
Vulnerabilities exist in multiple modern CPU architectures that could […]

By |January 18th, 2018|News, SQL, SQL Group|0 Comments

Changing Default Logs Directory – Back to Basics

In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used during install. Fair enough, there may not be massive need to change that location

By |January 4th, 2018|SQL, SQL Group|Comments Off on Changing Default Logs Directory – Back to Basics

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

Linked Servers and Stats

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers.

By |October 17th, 2017|SQL, SQL Group|Comments Off on Linked Servers and Stats

Linked Servers and Stats

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers.

By |October 17th, 2017|SQL, SQL Group|Comments Off on Linked Servers and Stats

Linked Servers and Stats

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers.

By |October 17th, 2017|SQL, SQL Group|Comments Off on Linked Servers and Stats

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