Building SQL Server Projects with GitLab Runners

This is the eighth part in the series: SQL Server and Continuous Integration. This post describes the set-up required for GitLab runners to automatically build SQL Server projects after each commit. I use ReadyRoll for my SQL Server projects, but SSDT projects could also be built in the same way. Topics covered so far in this series are: […]

Is Your Data Open to Abuse? T-SQL Tuesday

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. This month’s host is Kennie Nybo Pontoppidan (b|t) and this months topic is: The daily (database-related) WTF. Some of the biggest WTF moments I have had when working with SQL Server have been poor […]

GitLab for SQL Server Projects

This is the seventh part in the series: SQL Server and Continuous Integration. This post demonstrates the use of GitLab to build SQL Server projects. I use ReadyRoll for my SQL Server projects but SSDT projects could also be built with GitLab. Topics covered so far in this series are: Git Visual Studio ReadyRoll Installation ReadyRoll Configuration ReadyRoll […]

SQL Server on Ubuntu

They finally did it! Finally SQL Server for Linux was announced. I’ve been waiting for this for quite a while, so let’s jump in and get it installed. After that I’ll test some of the features that until today were only available in enterprise edition. I’m installing Ubuntu 16 on a Hyper-V VM. I’ll be using […]

Starting a ReadyRoll Project

This is part 5 in the series named SQL Server and Continuous Integration. This post will cover the steps I follow to setup a ReadyRoll project. Topics covered so far in this series are: Git Visual Studio ReadyRoll Installation I’m using ReadyRoll in my Continuous Integration setup to generate migration scripts that will intelligently update existing instances […]

Sign Up

James Anderson SQL Server DBA

Hi, I'm James Anderson. When I'm not blogging about SQL Server, I do this.

DBA Stackexchange Profile