Tag: #sqlrun
Why it Matters: CapEx or OpEx for information technology?
IT expenditure decisions are never purely financial, as those who pull the trigger must consider how the purchase, or perhaps
March 12, 2020
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