SQL RNNR

Blog Post

Powershell, Me and the MCM

If you haven’t heard yet, Microsoft has made some significant changes to the MCM program.  The changes make the certification more accessible to the masses. You can read more...

2010-12-16

5 reads

Blog Post

Tis the Season

This month has been quite the month for change in my family.  The changes that we are experiencing did not end with the birth of our baby girl two...

2010-12-15

11 reads

Blog Post

Wait Stats resources

Today I was out and about looking for past roundups on TSQLTuesday.  While doing that, I came across a post from Paul Randal (Blog | Twitter) about wait stats.  The...

2010-12-13

6 reads

Blog Post

SSIS Job Execution

While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed...

2010-12-13

11 reads

Blogs

Advice I Like: Respect

By

“Don’t aim to have others like you; aim to have them respect you.” –...

Blue Sky Programming – The Optimism Trap

By

Many years ago, before I joined Oracle, I was working on a major modernisation...

Setting Up a Mac for Data Engineering and AI Work

By

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Read the latest Blogs

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

By Terry Jago

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

Alamat kantor BCA KCU JOMBANG Telp:08218154398

By Layanan_24jam

WhatsApp:0821-8154-398 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415...

Alamat kantor BCA KCU MADIUN Telp:08218154398

By Layanan_BCA

WhatsApp:0821-8154-398 9G9F+FFC, Jl. Jend. Sudirman No.79-81, Kejuron, Kec. Taman, Kota Madiun, Jawa Timur 63132...

Visit the forum

Question of the Day

BIT_COUNT I

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

UserID  UserPermissions
15
23
37
What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;

See possible answers