
PolyBase vs Linked Servers
PolyBase vs. Linked Servers … which wins? Recently we have had several clients reach out to us about a data
PolyBase vs. Linked Servers … which wins? Recently we have had several clients reach out to us about a data
Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t
We often see companies not doing index maintenance in Azure. This will get you started because Index Maintenance with Elastic Jobs is easy.
Parallelism in SQL Server can significantly improve query performance by allowing multiple processors or cores to work together.
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’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