Author: Scott Klein

PolyBase vs. Linked Servers … which wins? Recently we have had several clients reach out to us about a data

October 19, 2023

We often see companies not doing index maintenance in Azure. This will get you started because Index Maintenance with Elastic Jobs is easy.

August 21, 2023

In my previous blog post I introduced Azure Automation and Runbooks and showed how to automate index maintenance using these

March 15, 2023

In my previous “prologue” blog post I introduced a small handful of topics that discuss how to automate things in

February 15, 2023

This is an introduction to an upcoming series of posts dedicated to supporting you and addressing the different ways to

January 20, 2023

At SSG, our clients run many different versions of SQL Server, even as far back as 2008. This post is

July 20, 2021

At SSG, we work with Always On availability groups (AGs) every day. Most of our clients who have implemented AGs

March 10, 2021

The other day I opened SQL Server Management Studio (SSMS) on my laptop. It had been some time since I

February 23, 2021

Overview There are times when you must protect and secure data within SQL Server . SQL Server Always Encrypted is a feature

February 18, 2021

In a previous blog post we laid out the basics of database recovery models and backups. As part of that

September 25, 2020

Get Started