Achieving Continuous Delivery for Your Database Using SSDT [DBA]
Consultant, Database Developer, DBA, IT Pro
Continuous Delivery allows developers and DBAs alike to streamline and automate the process of software delivery. SQL Server Data Tools (SSDT) allows the integration of Application Life Cycle Management practices to managing database deployments.
Using SSDT we can achieve automation from code push to delivery of consistent published artifacts (or packages) when integrated with Continuous Delivery.
The DEMO will showcase these processes and will include creating a consistent database model using SSDT, feature branching in source control and include running automated Continuous Integration build tests using SQL Server on Linux. Using Visual Studio Team Services for Continuous Delivery will achieve automated reliable deploys.
This session will also show how to utilize Infrastructure as Code using PowerShell, combined with Azure Resource Manager, to automate the deployment of a scalable SQL Server solution that is a hybrid database solution (on-premises and Azure SQL database).
This session will assume that people will have a basic understanding about SQL Server databases but is not mandatory.