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
One of the things we see as consultants are consistent patterns of behavior by T-SQL developers that cause big performance
The other day I opened SQL Server Management Studio (SSMS) on my laptop. It had been some time since I
One of the things I have found over the years is that it is easy to get into a rut
Overview There are times when you must protect and secure data within SQL Server . SQL Server Always Encrypted is a feature
Server OS maintenance is an important step in the health of your SQL Server environment. Everyone knows that, but no one
I am very grateful for the career I have passionately pursued these last 20 years, working for small, medium, large,
In 2014, one of our consultants wrote a highly popular blog blending Christmas with SQL. Last year, we revived the idea, and this
I founded SQL Solutions Group 10 years ago (October 2010). In that time, we’ve done more than 100 Health Checks
Everyone who shares a SQL Sever or other helpful “technical” trick (i.e., hack/tip/shortcut) as a comment to this post by
In a previous blog post we laid out the basics of database recovery models and backups. As part of that