Randy Knight

About Randy Knight

I founded SQL Solutions Group in October 2010, after more than 20 years in the technology industry. What I love about my work is solving, fairly easily, what can seem to others to be insurmountable problems. I was once called the “database whisperer” by a customer. I thought that was pretty cool. In addition to 17 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.

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 |October 4th, 2016|Security, SQL Group, SQL Server|0 Comments

SQLIntersection In Orlando–Why Wouldn’t You?

Orlando in April, and then you add SQL on top of that? What’s not to like?

I’m really excited to be part of the Spring SQLIntersection event, coming up April 18-21 at the Walt Disney World Swan. SSG was an exhibitor at the Spring 2015 event, and at the Vegas event last fall, I had the […]

By |February 13th, 2016|SQL Group|0 Comments

Participation Trophies: Is Showing Up Enough?

As you may have heard, Pittsburgh Steelers linebacker James Harrison recently decided to not allow his sons to keep participation trophies they had received from, apparently, Next Level. For Harrison, and his kids, only earned trophies will be kept.

The idea of awarding every child, regardless of talent or contribution, a trophy or medal for merely […]

By |August 26th, 2015|SQL Group|0 Comments

A Tale of Two DBAs: A Cautionary Tale

“It was the best of database consulting times…it was the worst of database consulting times…” 

One of the most common things we do here at SSG is help new customers who have hired us because they have run into big problems, usually performance related. In many of these cases, there is either no DBA on staff […]

By |January 27th, 2015|SQL Group|0 Comments

T-SQL Tuesday #61–Giving Back

The topic for this month’s T-SQL Tuesday (Giving Back to the SQL Server Community) is one that is near and dear to me so I figured this would be a great way to finally get started participating in T-SQL Tuesday. Blogging is something I haven’t been very consistent with so I guess my first commitment […]

By |December 9th, 2014|SQL Group|0 Comments

T-SQL Anti-patterns: 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 and thought some blog articles on the big ones I see over and over again would be a good thing.

Today I want to talk about User Defined Functions (UDFs). UDFs […]

By |October 21st, 2014|SQL Group|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 |September 9th, 2014|SQL Group|0 Comments

There’s something about GUIDs

There is a popular practice among developers to use globally unique identifiers (GUIDs) as primary keys.  At first glance, it seems like a great solution.  They are guaranteed to be unique and can be generated anywhere, avoiding a round trip to the database just to get the unique key.  While this sounds great in theory, […]

By |August 26th, 2014|SQL Group|4 Comments

An SSIS design pattern for capturing and reporting on bad data

One of the requirements of ETL is ensuring that bad data does not cause the whole ETL process to stop with an error. Failure to do this results in a very brittle process in which one row of bad data can cause a whole day’s worth of data loading to fail. My favorite war story […]

By |June 24th, 2014|SQL Group|4 Comments

Winter 2012 Performance Palooza!

This Thursday, December 6, 2012, the SQL PASS Performance Virtual Chapter will be holding online sessions all day long in an the first ever Performance Palooza!.  There are  eight one-hour online sessions, covering a variety of performance related topics.  It is a fantastic speaker line-up, of which I feel privileged to be part of.  All […]

By |December 4th, 2012|SQL, SQL Group|0 Comments