Everything I am writing about here was drilled into me by some of the best DBA’s in the industry that trained me. This post is for developing DBA’s who want to hone their craft and make their SQL code as readable and maintainable as possible.
[...]

One of my co-workers recently asked me if I could help him with the task of automating some of our client's database processes using Stash (Git), PowerShell, SQL Server Data Tools (SSDT), SQL Server and TeamCity. After doing some research and proving out that this task could be done, I decided to write a very basic tutorial on how to automate the deployment of a SQL Server database using Git, Powershell, SQL Server, SSDT and TeamCity. Caveats This tutorial assumes that you are familiar with Git, PowerShell, SQL Server 2014, Visual Studio 2015, SSDT, TeamCity and that you have the proper access and permissions to complete this guide.
[...]