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,721 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,273 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

790 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

568 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

768 reads

Blogs

Learn about Modern Microsoft Apps in San Diego

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps

Fabric has CI/CD built in, but if you've tried to use it for database...

A New Word: Attriage

attriage – n. the state of having lost all control over how you feel...

Read the latest Blogs

Forums

SSRS Reminded Me of the Time Microsoft Retired TMG

Comments posted to this topic are about the item SSRS Reminded Me of the...

Getting results from a Procedure to join to a query

I have a need to execute a stored procedure and return the results to...

Upgrade 2016 Standard to 2022 Express

Title pretty much says it all - can this be done? I've tried several...

Visit the forum

Question of the Day

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers