SSG Blog
Insights and news from the SQL Solutions Group.
Recent

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

Enabling SQL Server Always Encrypted
Overview There are times when you must protect and secure data within SQL Server . SQL Server Always Encrypted is a feature which helps protect sensitive data,

Keeping Up with Server OS Maintenance
Server OS maintenance is an important step in the health of your SQL Server environment. Everyone knows that, but no one wants to do it. After all, maintaining

How to Apply your Craft to Your Hobby: SQL Data Analysis and Athletic Training
I am very grateful for the career I have passionately pursued these last 20 years, working for small, medium, large, and enterprise companies around the