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: January 2016

SQL Server Management Studio Setup and Configuration

This is my first #entrylevel blog post. The challenge identified by the tags #entrylevel and #Iwanttoshare was started by Tim Ford (t|b) to help new comers to SQL Server. With #entrylevel in mind I’ve decided to focus on SQL Server Management Studio (SSMS). I will start… Read more

1 comments, 813 reads

Posted in The Database Avenger on 28 January 2016

Installing SQL Server 2016 Community Technology Preview

This post is designed to explain the installation steps of some of the new features in 2016 and just how easy it is to setup a test rig with the latest SQL Server Community Technology Preview (CTP).

Taking an early look at the up and coming version of SQL Server… Read more

2 comments, 491 reads

Posted in The Database Avenger on 20 January 2016

Managing Change Data Capture T-SQL Tuesday #74

T-SQL Tuesday is here again. This month the host is Robert Davis (b | t)

The topic for T-SQL Tuesday #74 is “Be the Change”. This covers data changes, ETLs, data sanitisation, etc. Basically anything that changes your data.

I want to discuss the management of the SQL… Read more

2 comments, 309 reads

Posted in The Database Avenger on 12 January 2016