Following a Structure When Performance Tuning, Part 3: Common Performance Problems
This is part three of the blog series on following a structure when performance tuning. From the previous posts (part
September 10, 2024
Category: SQL Server
Following a Structure When Performance Tuning, Part 2: Identifying Problem Statements
If you’ve followed along with the previous blog, you’ll now have a way to re-run and test your query as
July 31, 2024
Following a Structure When Performance Tuning, Part 1
So, you have a database or block of code. You’ve been told to “make it fast” but you’re not sure
July 15, 2024
Contained Availability Groups in SQL Server 2022
SQL Server 2022 brought us Contained Availability Groups. This post outlines the new features and some of the pitfalls that we have seen.
May 22, 2024
Andersen & Sons Shelling: “We’re Nuts About SSG!”
Andersen & Sons Shelling specializes in the growing, processing and marketing of walnuts, located in the Northern Sacramento Valley.
May 10, 2024
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