Author: Randy Knight

One of the things we see as consultants are consistent patterns of behavior by T-SQL developers that cause big performance

March 3, 2021

One of the things I have found over the years is that it is easy to get into a rut

February 22, 2021

I founded SQL Solutions Group 10 years ago (October 2010). In that time, we’ve done more than 100 Health Checks

November 16, 2020

I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014

May 9, 2020

March 18, 2020

A few years ago I published an article about how to use linked servers to avoid performance issues. I wanted

March 4, 2020

The Problem: Can’t Close Existing Connections Typically when restoring a backup using the SSMS GUI, you choose the device, then

February 10, 2020

Over the years we have seen lots of changes to the tools we use to develop SSIS packages. With the

January 21, 2020

One of the things I end up having to do quite often is set up a Windows workstation for my

January 8, 2020

The memory is still fresh from attending the 2019 PASS Summit just a few weeks ago, so here we share

December 31, 2019

Get Started