Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Richard Douglas

Richard Douglas is a SQL Server Professional working in the UK where he recently worked as a DBA in women's clothing, not literally he hastens to add! He is certified in SQL Server 2008, runs the Maidenhead SQL Server User Group Pass Chapter and is on the organising committee for SQL Relay. In his spare time plays the trumpet in local symphony orchestras.

His online presence includes:

My First Ever SQL Saturday Pre-Con

Like most people I have a bucket list of things to do before I depart for other things. However I chose to have two bucket lists, one personal and one professional. I’m now one step closer to ticking another one off of my professional bucket list, the title should give… Read more

0 comments, 118 reads

Posted in Richard Douglas on 13 March 2015

50 Shades of Brown – The Series

That’s right I’m cashing in on the “50 Shades” franchise and twisting it to meet my own sordid needs to tell you about something that is critically important to every business. But why Shades of Brown if it is critical? Everybody knows that it’s red alerts that signify things are… Read more

0 comments, 111 reads

Posted in Richard Douglas on 3 March 2015

SQLBits XIV – Welcome to the UK

A number of you will have heard of SQLBits before. It’s Europe’s largest conference dedicated to SQL Server. What was something just for people from the UK has been transforming into something much larger, more multicultural and more engaging as the community grows. Now we find that quite a large… Read more

1 comments, 106 reads

Posted in Richard Douglas on 2 March 2015

(Ctrl+E) was pressed. Waiting for the second key of chord…

I first came across the error “(Ctrl+E) was pressed. Waiting for the second key of chord…” last year, these weird errors have a tendency to come at the worst times. The first time it happened I was presenting the first of two of my sessions at a User Group meeting… Read more

0 comments, 141 reads

Posted in Richard Douglas on 8 January 2015

PASS DBA Virtual Chapter Webcast 20141112

Today I have the honour of presenting a session for the PASS Database Administration Virtual Chapter. The great thing about the PASS Virtual Chapters are that they are completely free, you just need to be a member of PASS in order to register. That’s right, free SQL Server training… Read more

0 comments, 145 reads

Posted in Richard Douglas on 12 November 2014

I need your help

The Situation

On the 19th November I am going to be presenting two sessions for the Luxembourg PASS chapter at the Microsoft offices there, you can register for the event here.

One session is on Wait Statistcs, which is fine. I’ve done it before as a webcast for Dell… Read more

14 comments, 5,543 reads

Posted in Richard Douglas on 7 November 2014

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay privilege of hosting the “Experts Perspective” webcast series. The only difference being for the next event which is held this week on 14th August 2014 that I won’t be hosting… Read more

0 comments, 136 reads

Posted in Richard Douglas on 12 August 2014

PASS DBA VC Session 25th June

It’s always an honour to be able to speak at an event, but events can be expensive to attend and they don’t always occur at a time or location that is convenient for you. Thankfully those smart people at PASS have created a number of Virtual Chapters so you can… Read more

0 comments, 149 reads

Posted in Richard Douglas on 24 June 2014

Spring may be long gone but you still need to clean up MSDB

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look after itself. In fairness it does to a certain extent (no, that’s not a pun), it’s configured out of the box not to be the fastest, but to be stable.… Read more

0 comments, 298 reads

Posted in Richard Douglas on 12 June 2014

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.

This morning I checked my Twitter feed and saw this post from Nicholas Cain, it’s really important to take note of this so I decided to write a few lines in the hope that… Read more

0 comments, 1,809 reads

Posted in Richard Douglas on 10 June 2014

Two things you probably shouldn’t say in an interview

If you look online you can find thousands of pages of advice on interviews as well as people asking for questions to ask or looking for answers to common questions. If you are looking for those things right now stop reading this and go elsewhere, this post isn’t really for… Read more

1 comments, 275 reads

Posted in Richard Douglas on 22 May 2014

Monthly Reflections – April 2014

April was quite a busy month and so apart from the last reflections post and TSQL Tuesday entry Why So Serious everything else that was published last month was actually written some time back. I did have a lot of fun with the April fools ones though and also the… Read more

0 comments, 187 reads

Posted in Richard Douglas on 9 May 2014

T-SQL Tuesday #53 Why So Serious

This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long? Is hosted by the awesome Matt Velic. Matt posted this invitation T-SQL Tuesday #53 – Why So Serious? (Announcement) on April Fools Day and so the subject is that of… Read more

1 comments, 256 reads

Posted in Richard Douglas on 8 April 2014

Monthly Reflections – March 2014

After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my blog had fared over the last month in essentially what was a re-launch. The list below is one of popular posts rather than a top N format due to the… Read more

0 comments, 206 reads

Posted in Richard Douglas on 4 April 2014

New Undocumented Feature in SQL Server 2014


Today is the eagerly anticipated launch of SQL Server 2014, I have downloaded and installed a copy of the RTM product and had a play. During some intensive testing I found that there is a new undocumented feature which will allow all registry keys to be available inside of…

Read more

3 comments, 355 reads

Posted in Richard Douglas on 1 April 2014

Last Day in the UK


The driver behind the move


After over two and a half years at my current employers I am afraid to say that today is my last day. I’ve had a great time, met some wonderful people both internally and externally through a number of different customer facing engagements.…

Read more

3 comments, 198 reads

Posted in Richard Douglas on 1 April 2014

5 Top Features Your Company Can Use in SQL Server 2014 Standard Edition

In a few days SQL Server 2014 will be made available, we’re not all lucky enough to be running Enterprise Edition even the largest of corporations still have a large number of Standard licences about their estate. The big question is; What can SQL Server 2014 do for you and… Read more

0 comments, 462 reads

Posted in Richard Douglas on 26 March 2014

Grant View Server State

There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without having these permissions there are a number of diagnostic queries that you cannot perform. Whilst one way to deal with this is to make users a member of the sysadmin… Read more

0 comments, 2,991 reads

Posted in Richard Douglas on 25 March 2014

Speaking at Luxembourg SQL Server User Group

Tomorrow evening I have the honour of speaking at Microsoft’s office in Clausen, Luxembourg. The session I will be presenting is entitled “Natural Born Killers; Performance Issues to Avoid” which I serialized in a succession of blog posts here – Natural Born Killers (The series).

Natural Born Killers; Performance…

Read more

0 comments, 300 reads

Posted in Richard Douglas on 25 March 2014

Remaining Vigilant, my contribution to #DBAJumpStart – Part 3

This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned previously, this post has been split into 3 more manageable chunks as I know you’re all busy people. Today heralds the third and final instalment of the mini series, you can find part one… Read more

0 comments, 848 reads

Posted in Richard Douglas on 20 March 2014

Older posts