When does it make sense to hire a data science consulting company?
Going into 2019, data science and machine learning is all the hype. Organizations in every industry are starting to realize...
2019-01-06
43 reads
Blog Posts
One tip for presenting: have a conversation
I like public speaking, but I haven’t always liked it. It started when I read Dale Carnegie’s book on public...
2019-01-05
39 reads
Short Circuiting Your Session
It isn't very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule - Extended...
2019-01-05
15 reads
Automatic Tuning Monitoring and Diagnostics
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...
2019-01-04
28 reads
Fun Time Friday: New Year! Drones, Autism and SQL Server 2008
Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New...
2019-01-04
223 reads
Fun Time Friday: New Year! Drones, Autism and SQL Server 2008
Welcome to the first Fun Time Friday of 2019 and with that I'd like to wish a very Happy New Year to our friends, customers and clients.
SQL Server 2008...
2019-01-04
24 reads
How to upload a vagrant file while provision a server
How to upload a vagrant file while provisioning a server
I was recently introduced to vagrant and i found it very interesting. I picked up a task that which is creating...
2019-01-04
48 reads
How to upload a vagrant file while provision a server
How to upload a vagrant file while provisioning a server
I was recently introduced to vagrant and i found it very interesting. I picked up a task that which is creating...
2019-01-04
13 reads
Identity Gaps–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-04 (first published: 2018-12-26)
2,305 reads
Looking Forward
2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new...
2019-01-04
246 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