SSG Blog
Insights and news from the SQL Solutions Group.
Recent
A SQL Server Microsoft Certified Master, a Jedi, and a Mandalorian walk into a cantina…
Not so long ago in a galaxy around the corner… Dramatis Personae Grenz Bahol, a Jedi Master from Sulon Randy Knight, a Microsoft Certified Master
Mainstream Support for SQL Server 2016 SP2 Ending this Summer — Are You Ready?
Where has the time gone? According to Microsoft’s timetable, mainstream support for SQL Server 2016 SP2 ends on Tuesday, July 13, 2021. What does
How To: Configure Read-Only Routing for Availability Groups
At SSG, we work with Always On availability groups (AGs) every day. Most of our clients who have implemented AGs need the high availability that
T-SQL Anti-Patterns: SQL User Defined Functions (UDFs) that turn your set operation into a cursor
One of the things we see as consultants are consistent patterns of behavior by T-SQL developers that cause big performance problems. I call these anti-patterns.
SQL Server Management Studio vs. Azure Data Studio
The other day I opened SQL Server Management Studio (SSMS) on my laptop. It had been some time since I had opened it (typically I
Skill Up or Give Up: Azure Data Studio or Bust
One of the things I have found over the years is that it is easy to get into a rut and do things “the way