Daily Coping 31 Jan 2023
Today’s coping tip is to take a small step towards and important goal. One of my goals this year was to work on a way to score myself with...
2023-01-31
8 reads
Tales From The Field Weekly Wrap Up for the Week of 01-23-2022
Hello Dear Reader! It's been a while since I had time to sit down and write out a Monday re-capThis past week was my birthday week. With all the...
2023-01-31
23 reads
CONCAT_WS Function Truncates Text
I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very...
2023-02-17 (first published: 2023-01-31)
638 reads
Presenting On Basics Is Difficult
Over the last year, at work and after work, I’ve been teaching myself a lot of brand new technologies. As such, I’m reliant on others to have put together...
2023-01-30
20 reads
Flyway Desktop Projects for My PoC
In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up...
2023-01-31 (first published: 2023-01-30)
32 reads
Daily Coping 30 Jan 2023
Today’s coping tip is to plan something fun and invite others to join you. The fun thing is actually skiing today. My wife and I wanted to get some...
2023-01-30
15 reads
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to make sure we are prepared for the scenario where something goes wrong. For instance, if...
2023-01-30
26 reads
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend and colleague Ben E. Weissman, is now available on Pluralsight here! If you want to...
2023-01-28
28 reads
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along with my DCAC colleagues. SQLBits, the largest Data Platform conference in Europe, held this year...
2023-01-27
71 reads
Daily Coping 27 Jan 2023
Today’s coping tip is to try something new to get out of your comfort zone. I did two things here. First, I’ve been participating in a Jan American Cancer...
2023-01-27
17 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