Parallelism in SQL Server
Parallelism in SQL Server can significantly improve query performance by allowing multiple processors or cores to work together.
July 12, 2023
Tag: #microsftpartner
How To: Clear Backup History
SQL Server should clear up system tables, but doesn’t. And that’s a problem. This post shows you how to clear backup history.
June 13, 2023
SQL Server and the (not so mysterious) Mystery of Three-Valued Logic
SQL Server’s three-valued logic is a concept that extends the traditional two-valued logic to include a third value, known as NULL. Three-valued logic is used to handle cases where the value of a column in a database table is unknown or not applicable. Get to grips with this complex idea.
April 21, 2023
How To: Running SQL Jobs with Azure Functions
In my previous blog post I introduced Azure Automation and Runbooks and showed how to automate index maintenance using these
March 15, 2023
How To: Azure Automation and Runbooks
In my previous “prologue” blog post I introduced a small handful of topics that discuss how to automate things in
February 15, 2023
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
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