SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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 default settings are 0 MB
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 not only do index maintenance,
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, setting up my 2023 calendar,
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 my server gave to me
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 outlines the main benefits of
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 simplifies performance troubleshooting by helping