Help for DBAs Who Support SSIS…

SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.

Training: Zero to BIML

A four-day course aimed at BI developers who want to use Business Intelligence Markup Language (BIML) to generate SQL Server Integration Services packages.

Migrating SSIS Projects and Parameters, Part 1

In this first part to looking at deploying SSIS packages to new environments, Andy Leonard looks at a few options for migrating your work to a new instance.

Never Stop Learning

A successful career in DevOps requires continuous education.

Data Warehouse Development: Version 0

What do you do first when developing a data warehouse? MVP Andy Leonard brings us a look at the foundation he uses, which might surprise you.

SSIS Properties

The Execute SQL Task

An Example of Test-Driven Development, Part 5

The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.

An Example of Test-Driven Development, Part 4

Continuing on with his testing series for T-SQL code, MVP Andy Leonard looks at deployment here.

SSIS Execute Package Task