A Visit from St. Randy: ‘Twas the night in the server room, silent and cold …
Continuing an SSG tradition of adapting “A Visit from St. Nicholas,” the classic poem by Clement Clarke Moore. Happy holidays to all!
December 21, 2023
Tag: #sqlite3
SQL Server on a Diet: Improve the health of your database
We often see databases that are simply larger than they need to be. This is usually attributable to technical debt
December 14, 2023
Health Considerations in the Data Management Space
If your health is suffering, you’re not as much of an asset to your employer, so it’s in their and your best interests to ensure as much “balance” as possible.
November 15, 2023
PolyBase vs Linked Servers
PolyBase vs. Linked Servers … which wins? Recently we have had several clients reach out to us about a data
October 19, 2023
Blindsided by Database Corruption
Maybe a user has reported some data is unavailable, maybe you’ve received an error message on a report that shouldn’t
September 20, 2023
Index Maintenance: Automating Azure with Elastic Jobs
We often see companies not doing index maintenance in Azure. This will get you started because Index Maintenance with Elastic Jobs is easy.
August 21, 2023
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
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