In this article, I will explain step by step how to create Continuous Build and Release process for SQL Server Scripts for Database. All the steps are self explanatory with relevant screenshots.
I often get developers who are unfamiliar with the branching and merging process within TFS asking me how it works, so I've put together a short guide that explains the basics.
Typically, when I have worked within Visual Studio on source-controlled projects I have used Team Foundation Server (TFS). With my current employer, we use Mercurial, and we use TortoiseHg to interface with it.