About Richard Douglas

http://SQL.RichardDouglas.co.uk

Posts by Richard Douglas:

PASS DBA VC Session 25th June

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 watch sessions live from the […]

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

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. The problem is that SQL […]

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

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 more people would see this […]

Two things you probably shouldn’t say in an interview

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 you. For me this is […]

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 why so serious one brought back […]

T-SQL Tuesday #53 Why So Serious

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 pranks. Having posted a couple of April […]

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 fact that some of them are perennial […]

New Undocumented Feature in SQL Server 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 your systems environmental variables. It also […]

Last Day in the UK

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. Now it is time for […]

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

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 your small – mid sized […]