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:

Blog: http://SQL.RichardDouglas.co.uk

Twitter: http://Twitter.com/SQLRich

LinkedIn: http://www.Linkedin.com/in/RichardPDouglas

Maidenhead User Group: http://www.sqlstudy.org

Interests: Usual stuff: family, SQL Server, shiny things.

Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast

by Richard Douglas

Richard Douglas

Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...

2014-08-12

599 reads

PASS DBA VC Session 25th June

by Richard Douglas

Richard Douglas

It’s always an honour to be able to speak at an event, but events can be expensive to attend and...

2014-06-24

683 reads

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

by Richard Douglas

Richard Douglas

Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.
This morning I checked my...

2014-06-12 (first published: 2014-06-10)

2,740 reads

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

by Richard Douglas

Richard Douglas

System databases are often neglected, part of this is due to Microsoft’s message of SQL Server will run and look...

2014-06-12

1,095 reads

Two things you probably shouldn’t say in an interview

by Richard Douglas

Richard Douglas

If you look online you can find thousands of pages of advice on interviews as well as people asking for...

2014-05-22

882 reads

Monthly Reflections – April 2014

by Richard Douglas

Richard Douglas

April was quite a busy month and so apart from the last reflections post and TSQL Tuesday entry Why So Serious...

2014-05-09

674 reads

T-SQL Tuesday #53 Why So Serious

by Richard Douglas

Richard Douglas

This month’s T-SQL Tuesday which is now at a staggering number 53, can it really have been going that long?...

2014-04-08

824 reads

Monthly Reflections – March 2014

by Richard Douglas

Richard Douglas

After a bit of an enforced sabbatical from blogging (short but boring story), I was interested to see how my...

2014-04-04

661 reads

Grant View Server State

by Richard Douglas

Richard Douglas

There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without...

2014-04-02 (first published: 2014-03-25)

92,523 reads

Last Day in the UK

by Richard Douglas

Richard Douglas

The driver behind the move
After over two and a half years at my current employers I am afraid to say...

2014-04-01

612 reads

Blogs

Advice I Like: Failure

If it fails where you thought it would fail that is not a failure....

Logged in as a member of an Azure AD Group Error while Deploying DACPAC

By Koen Verbeeck

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Data Conferences – Worth Every Dollar

Some of the best career enhancers you can buy. Why I Go to...

Read the latest Blogs

Forums

A Place where AI Technology Shines

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Place where AI Technology...

Alternate for xp_delete_file

alternate for xp_delete_file

Select @ for different fields

I have a need where I need to pass a field name to a...

Visit the forum

Question of the Day

Getting the Object Code

What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?

SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; 
GO

See possible answers