Task After BI developers have completed the design and testing for an SSIS Project, they may require some help from DBAs to deploy project to the SSIS Catalogs. How To SSIS Projects  in SQL Server 2012 now use the Integration Services Catalogue (https://msdn.microsoft.com/en-GB/library/hh479588.aspx) which is the coordination center for SSIS Project works within Integration Services. The catalog… Read More

This post is part of a series which walks through the steps required to build a ‘High Availability’ and ‘Disaster Recovery’ (HADR) solution using both AlwaysON technologies. The AlwaysON technologies were introduced in SQL Server 2012 and include Failover Cluster Instance (FCI) and Availability Group (AG). In this series, the focus is on a particular… Read More