[Video] Azure SQL Database – Failing Over (Failover Groups)
Quick video showing you how to failover your Azure SQL Database between your primary and secondary location.
2020-11-18
90 reads
Blog Posts
Daily Coping 18 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-18
24 reads
Monitoring and Tracking SQL Server Blocking & Deadlocks process
Introduction SQL Server deadlock one of the issues that can be happened in any SQL Server, today in this article I will not explain what is Deadlock and How...
2020-11-18 (first published: 2020-11-08)
534 reads
PowerShell Arrays and Hash Tables–#SQLNewblogger
I was watching the GroupBy talk the other day and noticed that Cláudio Silva was using arrays, or what appeared to be arrays, in his talk. That was an...
2020-11-18 (first published: 2020-11-09)
374 reads
Setting yourself up for online streaming success, PASS Virtual Summit style
Last week I presented on three separate occasions during what is considered the biggest Microsoft Data Platform conference of the year, the PASS Summit: Full-day pre-conference session Speaker Idol...
2020-11-18
74 reads
Thoughts on the 2020 PASS Virtual Summit as an Attendee
Last week was the first PASS Virtual Summit. This was the first time that the event wasn’t held in a live setting, and this was the third conference for...
2020-11-18
110 reads
[Solved] SQL Backup Detected Corruption in the Database Log
Summary: In this article, we will discuss about the ‘SQL Backup Detected Corruption in the Database Log’ error. It will also describe the reason behind the error and manual...
2020-11-17 (first published: 2020-11-06)
2,642 reads
Daily Coping 17 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-17
26 reads
Reflections on PASS Virtual Summit 2020
PASS Summit 2020 has wrapped up (or is in the process of wrapping up), and as with years past, I’m getting this written while the experience is still fresh...
2020-11-17
6 reads
T-SQL Tuesday #132 Pandemic Coping
This year, 2020, has been crazy. What started as a normal year for me, including a sabbatical, turned into a crazy, shutdown, lockdown, stuck at home pandemic around the...
2020-11-17 (first published: 2020-11-10)
237 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