Andre Kamman
andrekamman.com
André is a Data Platform MVP. He has done a lot of DBA work on 1000’s of servers where he discovered his love for Powershell, Azure DevOps, Python, Azure DW and Databricks. He loves to tinker with 100TB+ databases.
SQLBits 2012
A better SSIS? Migrating a datawarehouse to SQL Server 2012
SSIS in SQL Server 2012 has a lot of new features to help control larger projects. I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) This session will be a will be a walkthrough of this process and a lessons learned
The new and improved SSIS promises not only rounded edges and new icons ;-)
It has a whole lot of features to help control larger projects.It comes with a migration wizard to allow you to get up and running pretty quickly with all the new features.
But what if you have a large project and have already built a lot of DIY project management.
(error handling, running multiple packages consecutive and / or parallel etc.)I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) to see what the benefits are and how easy it will be.
This session will be a walkthrough of this process and a lessons learned.
It has a whole lot of features to help control larger projects.It comes with a migration wizard to allow you to get up and running pretty quickly with all the new features.
But what if you have a large project and have already built a lot of DIY project management.
(error handling, running multiple packages consecutive and / or parallel etc.)I'm doing a trial migration of our datawarehouse (100+ packages, 1TB+ db size) to see what the benefits are and how easy it will be.
This session will be a walkthrough of this process and a lessons learned.