SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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 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.
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
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.
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,