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

Certain DBs in an AG not Backing Up

Last week, I received an alert that the percentage of transaction log in use on one of our production databases was increasing more than it should have been. I’ll refer to this database as DB1 from here on in. It had reached 18%, which is above the normal 5-10% we… Read more

4 comments, 592 reads

Posted in The Database Avenger on 29 March 2016

The ‘In Recovery’ Mystery

Last week I received an email from one of our sysadmins asking why one of our databases kept showing as ‘In Recovery’.

The database in question wasn’t stuck in recovery, it would slip in and out of the status throughout the day. Normally, I would only ever expect to see… Read more

6 comments, 1,530 reads

Posted in The Database Avenger on 22 March 2016

SSRS 2016 – Part 3 Mobile Reports

This is the final post of 3 on SSRS 2016. This time I’m looking at the new SSRS 2016 mobile reports.

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

Post 2 covered the new features for the SSRS portal and paginated reports.

Mobile Reports

To install Mobile… Read more

10 comments, 5,107 reads

Posted in The Database Avenger on 14 March 2016

No Joke, SQL Server on Linux

Yesterday Microsoft made the earth shattering news that a version of SQL Server with the “core relational database capabilities” will be available for Linux systems in mid 2017. The full announcement can be found here.

You can sign up for the preview here.

Couple of thoughts on the… Read more

4 comments, 290 reads

Posted in The Database Avenger on 8 March 2016

SWITCHing IDENTITY in the Pub

I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY columns. His application was incrementing the max value of the ID column in each table by 1. This isn’t particularly efficient and it’s potentially open to race conditions.

As… Read more

0 comments, 243 reads

Posted in The Database Avenger on 1 March 2016