Impostorism: It’s (mostly) Okay if You Feel Like a Fraud

I’m a loserI’m a loserAnd I’m not what I appear to be
— John Lennon

As a SQL Server or other IT professional, do you ever feel like you’re doing it with smoke and mirrors? Do you fear you’ll soon be exposed as a pretender? Do you feel like a fraud, merely acting in your role? You’re […]

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

Linked Server in SQL Server: the good, the bad, and the way to make it perfect!

One of the all-time best performing posts on our blog is from Randy Knight and outlines how to use Linked Servers the right way. In this post from Steve Rezhener, he shows how OPENQUERY can make all the difference with Linked Servers.
Introduction (the good)
If you are not familiar with a linked server concept in SQL […]

By |April 7th, 2020|SQL Group, SQL Server|0 Comments

Social distancing in IT: Five tips to make working from home work for you

So, it’s here: a global pandemic impacting billions around the globe and changing the ways we live, work, and interact with each other. Our new normal, for an unknown length of time, is all about social distancing and that means working from home for many of us.

At SSG, this is nothing new to us, and […]

By |March 18th, 2020|SQL Group, SQL Server|0 Comments

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 other departments, from marketing and regulatory to operations and human resources. Once you have made the decision to proceed with an outlay, you then must decide: Capital Expenditure (CapEx) or […]

By |March 12th, 2020|SQL Group, SQL Server|0 Comments

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. Before you say, “we’re migrating to the cloud,” realize on-premises is alive and well, and probably always will be.

To Cloud Or Not To Cloud
When considering cloud vs. local options, one thing becomes quickly clear: There is no […]

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

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