Contents tagged with sql server

THE TEN RULES OF FORMATTING IN SQL SERVER FOR MAXIMUM MAINTAINABILITY PART 2

And now for the exciting conclusion of The Ten Rules SQL Server formatting in SQL Server for Maximum Maintainability! [...]

The Ten Rules of Formatting in SQL Server for Maximum Maintainability Part 1

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. [...]

How to Setup Continuous Deployment for a SQL Server Database using Git, PowerShell, SSDT and TeamCity

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. [...]