Bringing back an informative SQL Server Agent job email notification on failed SSIS packages

Introduction
The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework (see Fig #1) making SQL Server Integration Services more robust and enterprise-friendly by providing the following features:

Database […]

By |February 17th, 2020|SQL Group, SQL Server|0 Comments

Why Can’t I Close Existing Connections on Restore?

This morning a customer pinged me with what should be a simple issue:  While restoring a backup to a test environment, the option to Close existing connections to destination database was greyed out. I was able to reproduce the problem and the solution is a bit odd so thought I’d throw this out there. 

The Problem: […]

By |February 10th, 2020|SQL Group, SQL Server|0 Comments

How to fix a failed “SSIS Server Maintenance Job” job

In this article we will explore how to fix a failed “SSIS Server Maintenance Job”.
Introduction
The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter the MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL […]

By |January 28th, 2020|SQL Group, SQL Server|0 Comments

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 past few versions, the SQL Server project types (Database Projects, Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS)) have been moved from their own installer to installation via Visual Studio Extensions.
This makes perfect […]

By |January 21st, 2020|SQL Group, SQL Server|0 Comments

Can not create Catalog (SSISDB) due to an error

Introduction
The SSISDB database (a.k.a. the SQL Server Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter the MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing the following features:

Database […]

By |January 14th, 2020|SQL Group, SQL Server|0 Comments

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 daily use.  In many cases, customers prefer that we use a jump box or even a physical machine on their network/domain to access their servers. With all the various tools and things we have at […]

By |January 8th, 2020|SQL Group, SQL Server|0 Comments

Three Perspectives: PASS Summit

The memory is still fresh from attending the 2019 PASS Summit just a few weeks ago, so here we share our three experiences with you. While we mostly came for the three days of knowledge, sharing and networking opportunities, we also came for the camaraderie and celebration of SQL Solutions Group. Our main office is […]

By |December 31st, 2019|SQL Group, SQL Server, SQLPASS|0 Comments

‘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 an homage to that post five years ago, we present to you this year’s version….

‘Twas the day of PASS Summit, when all through the venue,SQL experts were hungry and grabbing a menu;Sandwiches were made and […]

By |December 23rd, 2019|SQL Group, SQL Server, SQLPASS|0 Comments

SSISDB Catalog Defaults Best Practices

Introduction
The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 to de-clutter the MSDB database and provide an in-house logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework making SQL Server Integration Services more robust and enterprise-friendly by providing:

Database backup
Database encryption
Support for environments
Support project and package parameters
Package […]

By |December 18th, 2019|SQL Group, SQL Server|0 Comments

Rethinking RBAR

Much has been written about the performance implications of the dreaded RBAR, a term coined by Jeff Moden many years ago.  I won’t rehash any of that here other than to say that in almost all cases, set operations are faster and more efficient than RBAR. So we spend a lot of time teaching (or […]

By |December 9th, 2019|SQL Group, SQL Server|0 Comments