A New PiHole in the Sky
Last year I set up a PiHole server on my RaspberryPi to help block some ads and malicious stuff (tracking,...
2019-01-11 (first published: 2019-01-03)
2,395 reads
Blog Posts
ASF 018 video invitation
What popular tool has he created in 2006?
What popular tool has he created in 2006? How many people do live...
2019-01-11
184 reads
Book Review: SQL Server 2017 on Linux
I don’t have any statistics but I think most IT Professionals in the SQL Server field are managing or developing...
2019-01-11
465 reads
Cool Stuff in Snowflake – Part 2: LISTAGG
I’m starting a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2019-01-11
187 reads
Execution plans: RetrievedFromCache
I first came across the value for RetrievedFromCache when I was reading a confusing execution plan. At first, I thought...
2019-01-11
714 reads
Why I’m Breaking Up with Facebook
I have been in a serious relationship for more than 12 years. My partner in this relationship has brought me...
2019-01-11 (first published: 2019-01-01)
3,207 reads
#SQLCareer 4/4 January 2nd 2019
Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be...
2019-01-10
173 reads
Automatic Tuning Monitoring and Diagnostics
Cool new toys/tools have been made available to the data professional. Among these tools are query data store and automatic...
2019-01-10 (first published: 2019-01-04)
2,701 reads
Big Changes for WaterOx Consulting
March of 2019 would have marked that start of the 8th year of WaterOx Consulting, Inc. running. That isn’t going...
2019-01-10
179 reads
Donating Hair Again
There are several organizations which take hair donations, but the one I prefer to donate to is Wigs for Kids,...
2019-01-10
190 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