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
One of the things I have found over the years is that it is easy to get into a rut
I founded SQL Solutions Group 10 years ago (October 2010). In that time, we’ve done more than 100 Health Checks
I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014
A few years ago I published an article about how to use linked servers to avoid performance issues. I wanted
The Problem: Can’t Close Existing Connections Typically when restoring a backup using the SSMS GUI, you choose the device, then
Over the years we have seen lots of changes to the tools we use to develop SSIS packages. With the
One of the things I end up having to do quite often is set up a Windows workstation for my
The memory is still fresh from attending the 2019 PASS Summit just a few weeks ago, so here we share