
Why You Should Never … Use SQL Server Default Memory Settings
We frequently see SQL Server instances that use the default memory settings, or settings that do not optimize performance. The

We frequently see SQL Server instances that use the default memory settings, or settings that do not optimize performance. The

Included in SQL Server 2019 (and also the upcoming SQL Server 2022), Accelerated Database Recovery (ADR) improves database availability. Microsoft

According to Microsoft, “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It

We at SSG are big believers in SQL Server best practices. Some ways of doing things are simply better than

Whether you are a small business owner, a CEO of a large corporation, the loved one of a SQL

There are usually two reasons companies come to us for SQL Server consulting: they’re facing an emergency and need help,

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

Over the years, we have been eager participants and supporters of SQLSaturday, PASS Summit, user group events, etc. We value

Questioning is the art of learning. Learning to ask important questions is the best evidence of understanding there is, far surpassing the

Our Health Check is a great starting point with our clients. It tells us a lot about their instances, such
