Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
10 reads
Blog Posts
Implicit Conversion Fail
Implicit conversions are not uncommon in the computing world and can be viewed as kind of a fail-safe for when we don't quite follow decent practices when designing the...
2019-05-31
9 reads
Moving to Serverless for Azure SQL DB
After the announcement of Serveless Azure SQL Datbase at //build/, I decided to give it a try. I have some Basic databases, so what would Serverless mean for me?...
2019-05-31 (first published: 2019-05-15)
913 reads
Puzzles and Daily Trivia
One of my favorite database automations is to send trivia style questions daily. This helps me to mentor and assess other dba talent within an organization without being too...
2019-05-31 (first published: 2019-05-14)
258 reads
See You at SQL Saturday South Florida on Saturday June 8th!
SQL Saturday South Florida is on Saturday June 8th and its just around the corner! The event is hosted at the Nova Southeastern University campus in Davie, Florida near...
2019-05-31
47 reads
DBAs: Stop Denying Sysadmin to Developers
I recent chatted with some folks who have a permissions problem in SQL Server. The permissions problem isn’t technical — it’s a process problem. The issue is that these...
2019-05-30
14 reads
Find identical duplicate indexes
The purpose of this query is to find identical duplicate non-clustered indexes i.e. indexes on same table with same columns in same order. If you have a need to...
2019-05-30 (first published: 2019-05-15)
881 reads
I’m moving my permissions scripts to GitHub
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are ... Continue reading
2019-05-30
68 reads
Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event last week, the major announcements in the data platform and AI space were: Machine Learning...
2019-05-30 (first published: 2019-05-16)
310 reads
See you at SQLSaturday Dallas!
Both my wife and I will be speaking this weekend at SQLSaturday Dallas, back-to-back in room 1.102, and both on topics perfect for entry level IT pros, job seekers,...
2019-05-30
16 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kontak Bank BCA KCP Cijerah WA {08218154393}
WA:08218154393 Istana Regency Sudirman, Jl. Raya Cijerah Raya No.2 Ruko No 19 & 20,...
Alamat Kontak BCA KCU BANDUNG WA {08218154393}
WA:08218154393 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
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