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

DBCC Just Runs Faster, Unless You’re Cheap

The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales better in SQL Server 2016.

This is great news for all of us, especially if you are struggling to get all of your maintenance done within your allotted maintenance window. Read more

1 comments, 436 reads

Posted in The Database Avenger on 25 February 2016

SSRS 2016 – Part 2 New Features for Paginated Reports

This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the Community Technical Preview (CTP) 3.3.

Post 1 covered the basics of creating your first paginated report.

Post 3 will cover the new Mobile Reports and KPI features. Read more

3 comments, 949 reads

Posted in The Database Avenger on 22 February 2016

Importing Open Data Sets in SQL Server

Whilst working on an upcoming post I realised that I needed a decent data set on which to test some of the new visualisations in SSRS 2016. I remembered this post on open data sets by Kendra Little that mentioned Data.gov. There are a lot of different data sets… Read more

0 comments, 386 reads

Posted in The Database Avenger on 15 February 2016

SQL Server Reporting Services 2016 – Part 1

This first post of 3 takes a quick peek at SSRS 2016 using the Community Technical Preview (CTP) 3.2. I will be making a quick post installation tweak and then guiding you through the steps to build your first report. If you are experienced with SSRS you can probably just… Read more

1 comments, 913 reads

Posted in The Database Avenger on 3 February 2016