Tag: SQL

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
March 4, 2020

Yes, On-premises Infrastructure has a (Bright) Future
With AWS and Azure leading the way, it’s easy to think the future of on-premises infrastructure is grim…
February 25, 2020

Why Can’t I Close Existing Connections on Restore?
The Problem: Can’t Close Existing Connections Typically when restoring a backup using the SSMS GUI, you choose the device, then
February 10, 2020

Simplify SentryOne Upgrades using the Enhanced Platform Installer (EPI), Part 1
As many of our readers and customers know, SQL Solutions Group has been a partner and advocate of SentryOne for many years.
February 5, 2020

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
January 21, 2020

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
January 8, 2020