‚ÄčAchieving Continuous Delivery for Your Database Using SSDT [DBA]

Hamish Watson
75 minutes
Scale
Scale
Consultant, Database Developer, DBA, IT Pro
200
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.

Share
cage-aids
cage-aids
cage-aids
cage-aids