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:

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, 98 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, 161 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,488 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, 176 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, 123 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, 143 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, 119 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, 237 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, 126 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, 271 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, 1,492 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, 175 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, 723 reads

Posted in Richard Douglas on 20 March 2014

Remaining Vigilant, my contribution to #DBAJumpStart – Part 2

This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned yesterday, this post has been split into 3 more manageable chunks as I know you’re all busy people. You can find yesterdays post here - Remaining Vigilant, my contribution to #DBAJumpStart – Part 1 Read more

0 comments, 692 reads

Posted in Richard Douglas on 19 March 2014

Remaining Vigilant, my contribution to #DBAJumpStart – Part 1

This post is part of the SQL Community Project #DBAJumpStart by John Sansom.

“If you could give a DBA just one piece of advice, what would it be?”

Last year John asked 19 successful and experienced SQL Server professionals and me (for some baffling reason) this exact question. Due to… Read more

0 comments, 175 reads

Posted in Richard Douglas on 18 March 2014

A Tale of Two SQL Server Webcasts

Things have been quiet on my blog of late (hosting issue) but now things are back online. Talking of online, on 20th March 2014 I shall be taking part in not one but two SQL Server webcasts – Dell like to keep me busy.

In the morning (10:00 GMT) I… Read more

0 comments, 155 reads

Posted in Richard Douglas on 17 March 2014

PASS Performance Virtual Chapter Webcast

A quick check of my calendar this morning reminded me that I am presenting a session for the PASS Performance Virtual Chapter this week. It’s completely free, you just need to be a member of PASS in order to register.

Not a member of PASS or unsure what it offers… Read more

0 comments, 169 reads

Posted in Richard Douglas on 2 December 2013

SQL Server events in the UK – December 2013

The Christmas countdown has begun for a number of us. This doesn’t mean it’s time to relax, there’s still plenty of events around the UK that you can get your learn on.

Date Location Event Time Details
4th December Southampton User Group Evening With Dave Ballantyne
Register here
4th December

Read more

0 comments, 138 reads

Posted in Richard Douglas on 2 December 2013

SQL Cruise competition, and the winner is …

Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win a free place on the next SQL Cruise which is taking place on the 25th January 2014 in Miami, returning on 2nd February.

In between… Read more

0 comments, 163 reads

Posted in Richard Douglas on 26 November 2013

#SQLRelay 2013 R2 – Week 2

If you haven’t heard of SQL Relay and you live in the UK then shame on you. SQL Relay is an annual community run series of SQL Server training events across the UK. Our aim is to enhance the existing SQL Server community in the UK by bringing free world… Read more

0 comments, 252 reads

Posted in Richard Douglas on 21 November 2013

Older posts