SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Database Avenger

My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

Archives: July 2016

Source Control for the Reluctant DBA

This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I encountered at work and how they provided the inspiration for using source control in my SQL Server projects. This post will focus on using the version control system… Read more

1 comments, 734 reads

Posted in The Database Avenger on 13 July 2016

SQL Server and Continuous Integration

This is the 1st in a series of posts on SQL Server and Continuous Integration. Some of the tools I’ll be covering are:

  1. Git
  2. Visual Studio
  3. ReadyRoll
  4. GitLab
  5. tSQLt
  6. SQL Cover

Three months ago I performed my first public talk at my local usergroup in… Read more

6 comments, 587 reads

Posted in The Database Avenger on 7 July 2016