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:

SQL Saturday Southampton Pre-con

It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with both of these events happening in Exeter a few months back. At that time I did a joint pre-con with Mark Pryce-Maher called Performance Troubleshooting for the (Accidental) DBA which… Read more

0 comments, 159 reads

Posted in Richard Douglas on 1 October 2015

Voting in the PASS Election 2015


Another year, another set of elections. It’s that time where those who care about their industry and the future of the community we work within take to the PASS website to see who has put themselves forward and weigh up who they think should be on the PASS Board… Read more

0 comments, 159 reads

Posted in Richard Douglas on 17 September 2015

Career Progression

Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part of one of the world’s most recognisable technological brands and was doing something that I enjoyed. So in that case why did I tweet earlier this week that I had…

Read more

1 comments, 162 reads

Posted in Richard Douglas on 7 August 2015

T-SQL Tuesday 66 Monitoring – Agent Alerts

Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you need to get a wriggle on and upgrade to SQL Server 2014. If you are still wondering whether to upgrade I did write a post on it some time back… Read more

1 comments, 588 reads

Posted in Richard Douglas on 12 May 2015

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

2 comments, 229 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, 236 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, 196 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, 330 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, 232 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,659 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, 235 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, 252 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, 465 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, 2,052 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, 399 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, 271 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, 372 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, 299 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, 512 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, 281 reads

Posted in Richard Douglas on 1 April 2014

Older posts