SSRS Migration: Data Sources Supported in Reporting Services 2012/2014

Migrating your Reporting Services instances to SQL Server 2012/2014 has a few key considerations. First, the oldest version you can upgrade from is Reporting Services 2005 and that must be patched to SP4 (9.00.5000). Next, any SQL Server 2005 report data sources are still supported in SQL Server 2012/2014. Here are the full list of […]

SSIS: Execution History Catalog Dashboard To Go

The SSISDB contains a wealth of statistical data for your SSIS package executions and messages.   In a package failure scenario, trawling through SQL Management Studio to get detailed reports becomes quite tedious.  For a very quick and easy dashboard looking at the most recent events try a simple Reporting Services report with two tables […]