Randy Knight

About Randy Knight

In 2010, after 20+ years in the technology industry, I set out to create a world class consulting firm and in October of that year SSG was born. What I love most about what I do, and what we have created at SSG, is solving the seemingly insurmountable puzzles and problems. I was once called the “database whisperer” by a customer. In addition to 25 years’ experience with SQL Server, I am a Microsoft Certified Master, and Microsoft and Novell Certified Trainer. Prior to founding SSG, I was the Database Administrator for Fidelity Investments, EverCom Systems, and Verizon. I was at match.com as the Technical Architect for six years, and also Senior Database Engineer for the LDS Church. I’ve done lots of fun stuff in my career. The most “interesting” data I’ve worked with was at match.com just because it’s so different. I also really enjoy taking part in and presenting at SQL Server events nationwide including SQLSaturday, User Groups, SQL PASS Rally and SQL PASS Summit.

Five Tips: Configure Windows for Better SQL Server Performance

I founded SQL Solutions Group 10 years ago (October 2010). In that time, we’ve done more than 100 Health Checks on customer systems. Based on that experience, we’re starting a series of posts to help you avoid pitfalls we often encounter. With this post, we show you how to configure Windows for better SQL Server […]

By |November 16th, 2020|SQL Group, SQL Server|0 Comments

What happened to SQL Server Data Tools in SQL Server 2014?

I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014 (a full version, not Express) and selected all components, yet when you go to your SQL Server 2014 program group, you can’t find SQL Server Data Tools.

In all versions of SQL Server between 2005 and […]

By |May 9th, 2020|SQL Group|0 Comments

Social distancing in IT: Five tips to make working from home work for you

So, it’s here: a global pandemic impacting billions around the globe and changing the ways we live, work, and interact with each other. Our new normal, for an unknown length of time, is all about social distancing and that means working from home for many of us.

At SSG, this is nothing new to us, and […]

By |March 18th, 2020|SQL Group, SQL Server|0 Comments

Security Configuration for Linked Servers

A few years ago I published an article about how to use linked servers to avoid performance issues. I wanted to follow up on that with a discussion of linked server security configuration because this is another big issue I see all too often with linked servers.

The first thing to understand is that all linked […]

By |March 4th, 2020|Security, SQL Group, SQL Server|0 Comments

Why Can’t I Close Existing Connections on Restore?

This morning a customer pinged me with what should be a simple issue:  While restoring a backup to a test environment, the option to Close existing connections to destination database was greyed out. I was able to reproduce the problem and the solution is a bit odd so thought I’d throw this out there. 

The Problem: […]

By |February 10th, 2020|SQL Group, SQL Server|0 Comments

Visual Studio 2019 SSIS Projects

Over the years we have seen lots of changes to the tools we use to develop SSIS packages. With the past few versions, the SQL Server project types (Database Projects, Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)) have been moved from their own installer to installation via Visual Studio Extensions.
This makes perfect […]

By |January 21st, 2020|SQL Group, SQL Server|1 Comment

Boss: Can I have a new Windows workstation? And, some Chocolatey with that?

One of the things I end up having to do quite often is set up a Windows workstation for my daily use.  In many cases, customers prefer that we use a jump box or even a physical machine on their network/domain to access their servers. With all the various tools and things we have at […]

By |January 8th, 2020|SQL Group, SQL Server|0 Comments

Three Perspectives: PASS Summit

The memory is still fresh from attending the 2019 PASS Summit just a few weeks ago, so here we share our three experiences with you. While we mostly came for the three days of knowledge, sharing and networking opportunities, we also came for the camaraderie and celebration of SQL Solutions Group. Our main office is […]

By |December 31st, 2019|SQL Group, SQL Server, SQLPASS|0 Comments

Rethinking RBAR

Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years ago.  I won’t rehash any of that here other than to say that in almost all cases, set operations are faster and more efficient than RBAR. So we spend a lot of time teaching (or […]

By |December 9th, 2019|SQL Group, SQL Server|0 Comments

Strangest Things in SQL Server, Part 2

Strangest Things Pt 2: 505 executions per second
I’ve been a SQL Server DBA for more than 20 years and have spent the last 10 of those consulting.  When you’ve been doing this for as long as I have, there’s not a lot of new issues that come up that you haven’t seen before.  Which is […]

By |July 15th, 2019|SQL Group|0 Comments