Azure SQL Database Roadmap
I do not usually link straight to other blog posts or technical papers but I really had to with this...
2019-01-24
306 reads
Blog Posts
Extended Events: Detect Implicit Conversions that affect execution plans
Implicit Conversions – Introduction
In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that...
2019-01-24 (first published: 2019-01-15)
2,854 reads
Time Animation with ArcGIS Maps in Power BI
(2019-Jan-14) Dynamic maps with dynamic visualization usually attract my attention, especially when I look at the satellite images of various cloud...
2019-01-24 (first published: 2019-01-14)
7,386 reads
17 months of podcasting – recap
Before I publish the next episode of “Ask SQL Family” podcast, I would like to stop and look back for...
2019-01-23
154 reads
All Day, Training Day at SQLBits
It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February...
2019-01-23
233 reads
Azure SQL Database and Transaction Log
Checking out the transaction log in Azure SQL Database. If you are curious like me, you will want to know...
2019-01-23
1,632 reads
DevOps and Automation Will Eliminate the DBA
I’ve been reading about the death of the DBA ever since I first made the jump from full time developer...
2019-01-23 (first published: 2019-01-14)
2,689 reads
Dodging Deadlocks With Indexes
A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index....
2019-01-23 (first published: 2019-01-14)
6,489 reads
Don’t Forget To Take Break
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More often than not this leads to the “not seeing...
2019-01-23
8 reads
Don’t Forget To Take Break
So many times we get sucked into a rabbit whole when fixing/troubleshooting things we forget to take a break. More...
2019-01-23
162 reads
Blogs
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...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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