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
Tag: #SQLLearning
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
Three Perspectives: PASS Summit
The memory is still fresh from attending the 2019 PASS Summit just a few weeks ago, so here we share
December 31, 2019
‘Twas the Day of PASS Summit…
In 2014, we published a SQL-themed “Night before Christmas” blog post that proved highly popular with the SQL community. As
December 23, 2019
Rethinking RBAR
Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years
December 9, 2019