SQLBits 2018

DevOps, CI and the Data Warehouse

DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse
DevOps and continuous integration provide huge benefits to data warehouse development.  However, most BI professionals have little exposure to the tools and techniques involved. John will be showing how you can use VSTS - Visual Studio Team Services (formally known as TFS) to build and test your data warehouse code and how to use Octopus Deploy to deploy everything to UAT and production.  In particular the session will cover:

• Setting up Visual Studio Team Services to act as your build server
• How to use Octopus Deploy to deploy your entire data warehouse
• Developing a build-centric PowerShell script with psake
• Building and deploying SQL Server Data Tools projects with DAC Publish profiles 
• Writing and running automated unit tests 
• The many problems of automating tabular model deployments