About Richard Douglas

http://SQL.RichardDouglas.co.uk

Posts by Richard Douglas:

I need your help

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 Software and will be doing a […]

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

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 it, I’ll be hosting and […]

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 […]