Understanding Wait Stats in SQL Server: A Practical Guide
When working with SQL Server, one of the best tools DBA’s can use for diagnosing performance issues is wait statistics
August 14, 2025
Tag: #parallelism #azure
Safeguarding Your Data: Navigating SQL Backup, Compliance, Maintenance, and Support Challenges
As businesses become increasingly data-driven, the role of SQL databases has become critical to day-to-day operations. Yet, many organizations underestimate
May 30, 2025
Copying Databases Across SQL Managed Instances
It only seems like yesterday since it was my turn to write a blog. And yet, here we are again,
April 23, 2024
SQL Server Antipatterns: Common Mistakes with SQL Code
In today’s tech-saturated world, we expect developers to have a broad range of skills and programming languages at their disposal,
February 21, 2024
The Right Tool for the Right Job
I’m looking forward to 2024. From many perspectives, I think we are going to see great advancements, including in technology, that on one hand will make our lives easier, but also make our decisions a bit harder.
January 15, 2024
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
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