Database development


Continuous Delivery series

Once more, the Rabo Tech Blog community gave me an awesome opportunity to write a Continuous Delivery series inspired by the well known Dave Farley. In these three-part series, you will learn to apply the principles and practices on .NET SDK database development.


SDK style database development - part 2

If you went through the first part of this tutorial series, you are going to add an existing project side-by-side you're working project. This is also known as a **composite** project, where you will create a reference to the other main database project, and also include the tSQLt DacPac as a reference for deployment, as this includes all the objects to run tSQLt tests. So, if you did not follow along with the first series, make sure you do that first to follow along with this second part! If you're already there, let's get started


SDK style database development

SQL Server Data Tools (SSDT) is one of the modern development tools to build SQL Server databases. SSDT development is done in Visual Studio, which even in recent years have become smaller in size of the required installations needed to start developing, Microsoft have launched a new release of the SQL Database Projects extension for Azure Data Studio and VS Code. Inside this release, a new preview for an SDK-style SQL project based approach has been introduced, introducing several advantages especially for developers that ship through CI/CD pipelines or are working cross-platform.