Continuous Integration for SQL Server Projects

Whilst continuous integration (CI) is a well established practice in the context of application development, its use within database development has typically lagged.

In this post I’m walking through a CI framework for SQL Server, that’s built upon Visual Studio 2015, SSDT, GitHub, DACPACs, TeamCity and PowerShell. […] “Continuous Integration for SQL Server Projects”

Predicate Pushdown and Columnstore Indexes

Predicate pushdown in SQL Server is a query plan optimisation that pushes predicates down the query tree, so that filtering occurs earlier within query execution than implied by the logical query execution ordering.

So with an inner join query for example, a predicate that appears in the WHERE clause and that logically […] “Predicate Pushdown and Columnstore Indexes”

A Pattern for Error Handling in T-SQL Stored Procedures

SQL Server MVP Erland Sommarskog has written a staggeringly detailed and thorough series of articles on error handling in T-SQL.

In the first of these articles Erland presents a pattern for error handling that he suggests is suitable for 90-95% of coding situations, and that works for SQL Server […] “A Pattern for Error Handling in T-SQL Stored Procedures”