SSG Blog
Insights and news from the SQL Solutions Group.
Recent
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 delaying the purchase, could impact
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 to follow up on that
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 change anything in files or
February 10, 2020