SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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 1, part 2) we have
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 well as measuring any changes.
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 where to start. I’ve got
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.
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, still staring at the M&M
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, SQL usually being one of