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 – Gina Walters – User Groups

by Richard Douglas

Richard Douglas

Thanks for agreeing to do this Gina; from your emails things do sound quite frantic at the moment so I...

2013-02-12

868 reads

FLOAT datatype casting issue

by Richard Douglas

Richard Douglas

Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...

2013-02-01

5,134 reads

New Year Aspirations – Christian Bolton – Author

by Richard Douglas

Richard Douglas

As a former mentor Christian is used to me asking him all sorts of random questions, but this time it’s...

2013-01-29

1,535 reads

New Year Aspirations – Annette Allen – WiT

by Richard Douglas

Richard Douglas

Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be...

2013-01-28

936 reads

New Years Aspirations – Kevin Kline – Presenting

by Richard Douglas

Richard Douglas

I’ve been very privileged to be able to work alongside Kevin on a few projects during our time together at...

2013-01-25

883 reads

New Year Aspirations – Jonathan Allen – DBA

by Richard Douglas

Richard Douglas

Thanks for agreeing to do this Jonathan, I know you’re busy with arrangements for SQL Saturday #194 in Exeter

Before we...

2013-01-24

1,077 reads

SQLSaturday 194 (Exeter)

by Richard Douglas

Richard Douglas

It’s an exciting time for SQL Server Professionals in the South West of the UK, we’re now just a few...

2013-01-24

733 reads

New Year Aspirations – Gavin Payne – MCA

by Richard Douglas

Richard Douglas

Thanks for agreeing to do this Gavin. It’s great to be able to interview an MCA as there are so...

2013-01-23

945 reads

New Year Aspirations – boB Taylor – MCM

by Richard Douglas

Richard Douglas

Thanks for agreeing to do this boB. It’s great to be able to interview the Microsoft program manager for the...

2013-01-22

1,890 reads

New Year Aspirations – Thomas La Rock – Blogging

by Richard Douglas

Richard Douglas

Most readers will know you already, but before we start on the main part of the interview, tell us all...

2013-01-21

1,018 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