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

604 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

686 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,741 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,097 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

885 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

678 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

827 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

663 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)

93,189 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

Flyway Tips: AI Generating Migration Script Names

AI is a big deal in 2026, and at Redgate, we’re experimenting with how...

The Book of Redgate: Get the right stuff done

Another of our values: The facing page has this quote: “We admire people who...

Runing tSQLt Tests with Claude

Running tSQLt unit tests is great from Visual Studio but my development workflow...

Read the latest Blogs

Forums

No Defaults Passwords Ever

By Steve Jones - SSC Editor

Comments posted to this topic are about the item No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

Hi, We have low latency high volume system. I have a table having 3...

The Long Name

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Long Name

Visit the forum

Question of the Day

The Long Name

I run this code to create a table: Create table with unicode name When I check the length, I get these results: Table with length of name shown as 132 characters A table name is limited to 128 characters. How does this work?

See possible answers