Aim: Increase logging generated as part of database deployment via Octopus to assist when investigating failed deployments & reviewing successful deployments. In a previous post…
Author: Deirdre O'Leary
This week I found out how to perform matrix multiplication using SQL. I don’t think I’ve touched matrix multiplication since university so first I gave…
Aim: Set up a Windows Azure virtual machine to serve as a testing environment for the new features available in SQL Server 2014. Set up a Windows…
I recently encountered this error when attempting to build a solution with a new SSDT project in TeamCity. The error occurred at the 01 –…
Aim: Automatically run the tSQLt tests from TeamCity following each successful build & deploy. Fortunately, there is a TeamCity runner for tSQLt available at https://github.com/cprieto/tsqlt-teamcity…
Aim: Deploy the tSQLt framework & tests using TeamCity & Octopus Deploy. In production, you may have separate TeamCity, Octopus Server & Tentacle environments. However,…
A note on cross-database testing In my previous post, I outlined how to install tSQLt on a specific test database. To test a database called…
Aim: Include a SQL Server test framework in an existing SSDT project so it can be added to version control & deployed to environments. Set…