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:
  • Interests: Usual stuff: family, SQL Server, shiny things.


Introducing system-versioned ledger tables


As long-time readers of this blog know, I’m a big fan of temporal tables,...

Daily Coping 15 Sep 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My upcoming Online Trainings and Speaking Engagements


Over the next few weeks I have again some online training and speaking engagements...

Read the latest Blogs


Subselect / Group by - Error multiple values

By bent

Hi there! I need to update n attribute in the table "rm_request" by summing...

Query with a column containing JSON text

By Roust_m

Hi I have a table MyFiles with columns Id, FileName, FolderName, KeyPairs. The last...

Parsing XML data

By maijoe

Hi all, I need help to extract data from a xml field. My data...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers