SQL Bits 2019: The Great Data Heist
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL...
2019-01-14
729 reads
Blog Posts
Today, I’m making my 100th post on SQLShack
The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join...
2019-01-14
173 reads
Today, I’m making my 100th post on SQLShack
The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join an excellent group of elite authors. When I joined...
2019-01-14
21 reads
Why Can't I Shrink TempDB?
I know, I know....#OMGShrinkingIsBadDontEverDoThatOrElseEtcEtcEtc
We all know that there are simply times you have to shrink some files. There are risks...
2019-01-14 (first published: 2019-01-01)
545 reads
WordPress's Block Editor and the Publicize Feature
Like many folks using Wordpress, I post a tweet each time I publish a blog entry and that’s done automatically by Wordpress. In the Wordpress Classic Editor, there was...
2019-01-14
13 reads
Last Week Reading (2019-01-13)
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
196 reads
MongoDB Replica-Set
The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can...
2019-01-13
171 reads
MongoDB – Storage
MongoDB has a Storage Wired Tiger by default MongoDB generated some standard wt (WiredTiger extension) files, WiredTiger uses MultiVersion Concurrency Control...
2019-01-12
175 reads
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you...
2019-01-12
248 reads
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out...
2019-01-12
6 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
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
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
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...
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
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 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers