Continuous Integration and the Data Warehouse

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover: 
  • Setting up SQL Server Data Tools for automated deployments 
  • Creating DAC Publish profiles 
  • The many actions of SQLPackage.exe 
  • Automating your build and deployments with PowerShell and psake 
  • Guide to configuring TeamCity as your build server 
  • Automated Integration and Regression testing of your Data Warehouse 
  • Automating cube and tabular model deployment