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
January 27, 2023
Category: SQL Server
Run SQL Jobs in Azure: A Prologue
This is an introduction to an upcoming series of posts dedicated to supporting you and addressing the different ways to
January 20, 2023
A SQL DBA New Year’s Resolutions- Habits we won’t be bringing with us into 2023
The New Year is upon us, can you believe it? I love this time of year. Thinking about my goals,
January 10, 2023
The 12 Days of SQLMAS
On the first day of SQLMAS my server gave to me one new migration. On the second day of SQLMAS
December 1, 2022
Why you should … use Accelerated Database Recovery
Included in SQL Server 2019 (and also the upcoming SQL Server 2022), Accelerated Database Recovery (ADR) improves database availability. Microsoft
October 11, 2022
Why you should never … leave Query Store turned off in SQL Server
According to Microsoft, “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It
September 26, 2022
Work Smart with SQL Server Best Practices
We at SSG are big believers in SQL Server best practices. Some ways of doing things are simply better than
June 16, 2022
What is SQL Server?
Whether you are a small business owner, a CEO of a large corporation, the loved one of a SQL
June 3, 2022
How we do SQL Server Consulting
There are usually two reasons companies come to us for SQL Server consulting: they’re facing an emergency and need help,
July 30, 2021
SQL Migration Steps: #1 Why Migrate SQL Server?
At SSG, our clients run many different versions of SQL Server, even as far back as 2008. This post is
July 20, 2021