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.

New Year Aspirations – Mark Broadbent – SQLSaturday

by Richard Douglas

Richard Douglas

I’ve known you for quite a while now through Twitter and later at SQLBits (your mum was right kids, don’t...

2013-01-18

1,118 reads

New Years Aspirations – James Rowland-Jones – PASS

by Richard Douglas

Richard Douglas

Thanks for agreeing to do this James; I know as you run your own company your time is billable!
Before we...

2013-01-17

1,534 reads

New Year Ambitions – Brent Ozar – Consulting

by Richard Douglas

Richard Douglas

You are of course someone who needs little introduction in the SQL Server community. A prolific blogger, tweeter, speaker, Microsoft...

2013-01-16

1,880 reads

New Year Aspirations – Chris Webb – SQLBits

by Richard Douglas

Richard Douglas

SQLBits holds a special place for me as it was the first technical conference that I had ever been to....

2013-01-15

934 reads

New Year Aspirations

by Richard Douglas

Richard Douglas

Every year millions of people around the world decide to make new years resolutions. In these resolutions they promise themselves...

2013-01-14

656 reads

#SQLMaiden 2013 dates

by Richard Douglas

Richard Douglas

Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...

2013-01-09

697 reads

Yesterday I was hacked

by Richard Douglas

Richard Douglas

That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident....

2012-09-13

1,046 reads

As one door closes another one opens

by Richard Douglas

Richard Douglas

Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...

2012-07-27 (first published: 2012-07-23)

2,520 reads

Cycling is good for you

by Richard Douglas

Richard Douglas

It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour...

2012-07-22

1,092 reads

Wish you were here

by Richard Douglas

Richard Douglas

When I was growing up, we used to sit round the t.v. (families only had one in those days) and...

2012-03-21

759 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