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.

SQL Server Events in the UK – June 2013

by Richard Douglas

Richard Douglas

Oh my god, there are so many events happening this month it is crazy. I’m going to break with tradition...

2013-06-03

696 reads

SQL Server Events in the UK – May 2013

by Richard Douglas

Richard Douglas

Things are really ramping up in May and June this year, it’s a great time to be an IT Professional with so...

2013-05-01

860 reads

My First White Paper – Top 10 Tips for Optimizing SQL Server Performance

by Richard Douglas

Richard Douglas

Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing...

2013-04-30

1,428 reads

How to provide a better customer service

by Richard Douglas

Richard Douglas

Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a device he has called a FitBit One which...

2013-04-29

1,713 reads

Microsoft let new SQL Server version name slip?

by Richard Douglas

Richard Douglas

There has been lots of speculation in the SQL Server community as to what the official name of the next...

2013-04-18

1,265 reads

T-SQL Tuesday 41 – Presenting and Loving it!

by Richard Douglas

Richard Douglas

Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for...

2013-04-09

784 reads

SQL Server Events in the UK – April 2013

by Richard Douglas

Richard Douglas

The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...

2013-04-04

748 reads

SQL Saturday #194 Exeter – A presenters review

by Richard Douglas

Richard Douglas

This weekend was full of a range of emotions for me. Grab a beverage and I’ll tell you all about...

2013-03-11

867 reads

100th blog post

by Richard Douglas

Richard Douglas

Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is)...

2013-03-01

563 reads

SQL Server Events in the UK – March 2013

by Richard Douglas

Richard Douglas

Welcome to the first of what I plan to be a regular recurring theme. Right here I will list out...

2013-03-01

758 reads

Blogs

SQL Server Journey till 2025 (brief)

By Vinay Thakur

Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...

Building Power BI Reports: Desktop vs Fabric

Why this comparison feels confusing If you’re a Power BI report author who’s just...

Identity Columns Can’t Be Updated: #SQLNewBlogger

I’m not sure I knew identity column values could not be updated. I ran...

Read the latest Blogs

Forums

Can someone please explain what happens?

I have mentioned this several times over several years. Can someone please help me...

SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0

SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...

Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform

Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...

Visit the forum

Question of the Day

Creating JSON III

In a SQL Server 2025 table, called Beer, I have this data:

BeerIDBeerName
1Becks
2Fat Tire
3Mac n Jacks
4Alaskan Amber
8Kirin

I run this code:

SELECT JSON_OBJECTAGG(
    BeerID: BeerName )
FROM beer;

What are the results?

See possible answers