About Richard Douglas

http://SQL.RichardDouglas.co.uk

Posts by Richard Douglas:

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

Grant View Server State

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 group, it really doesn’t adhere […]

Speaking at Luxembourg SQL Server User Group

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 Issues to Avoid Learning SQL is […]

Remaining Vigilant, my contribution to #DBAJumpStart – Part 3

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 here  and part two here.  […]

Remaining Vigilant, my contribution to #DBAJumpStart – Part 2

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 “If you could give a DBA […]

Remaining Vigilant, my contribution to #DBAJumpStart – Part 1

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 some technical problems and a […]