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.
In my previous blog post I introduced Azure Automation and Runbooks and showed how to automate index maintenance using these
In my previous “prologue” blog post I introduced a small handful of topics that discuss how to automate things in
We frequently see SQL Server instances that use the default memory settings, or settings that do not optimize performance. The
Included in SQL Server 2019 (and also the upcoming SQL Server 2022), Accelerated Database Recovery (ADR) improves database availability. Microsoft
According to Microsoft, “The SQL Server Query Store feature provides you with insight on query plan choice and performance. It
We at SSG are big believers in SQL Server best practices. Some ways of doing things are simply better than
Whether you are a small business owner, a CEO of a large corporation, the loved one of a SQL
Introduce your business and what you do there.I’m the CEO of a cloud-based practice management software. What challenge were you
There are usually two reasons companies come to us for SQL Server consulting: they’re facing an emergency and need help,