SSG Blog
Insights and news from the SQL Solutions Group.
Recent
![](https://sqlsolutionsgroup.com/wp-content/uploads/2023/07/word-image.png)
Parallelism in SQL Server
Parallelism in SQL Server can significantly improve query performance by allowing multiple processors or cores to work together.
![](https://sqlsolutionsgroup.com/wp-content/uploads/2023/06/Bike1.png)
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.
![SQL Server three-valued logic](https://sqlsolutionsgroup.com/wp-content/uploads/2023/04/Three_valued_logic.png)
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.
![](https://sqlsolutionsgroup.com/wp-content/uploads/2023/03/Featured.png)
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 Azure technologies. This blog post is
![](https://sqlsolutionsgroup.com/wp-content/uploads/2023/02/AzureRunbooks18.png)
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 Azure, specifically SQL agent jobs.
![](https://sqlsolutionsgroup.com/wp-content/uploads/2022/11/SQLMemory.png)
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