SQL Server Quickie #44 – SQL Server on Docker
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker.
2023-01-23 (first published: 2023-01-16)
222 reads
Misleading SSMS Connection
Foreword
The other day I managed to confuse myself. I was looking up some information from an Extended Events (XE) session, but my eyes were playing a trick on me....
2023-01-16
16 reads
Updating Documents in Cosmos DB: A Step-by-Step Guide on Creating and Executing a Stored Procedure
Cosmos DB is a powerful, fully-managed, globally distributed, and multi-model database service provided by Microsoft Azure. One of its key features is the ability to create and execute stored...
2023-01-23 (first published: 2023-01-13)
12,057 reads
How Long Will it Take to Encrypt Your Existing Data with TDE?
As we’ve seen in previous posts, the process of turning TDE on for an empty database with no data is instantaneous. Most of the time though you’ll be applying...
2023-01-13
93 reads
Daily Coping 13 Jan 2023
Today’s coping tip is to take five minutes to sit still and breathe. Sounds simple. I find this to be very challenging. If I’m just sitting here, why am...
2023-01-13
27 reads
You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta support today for Apple’s...
2023-01-25 (first published: 2023-01-12)
198 reads
New year, new role, and new book
Happy new year to everyone! As I enter my 9th year at Microsoft, I have switched roles, and am now an Industry Advisor in Federal Civilian, helping our Federal...
2023-01-20 (first published: 2023-01-12)
316 reads
Daily Coping 12 Jan 2023
Today’s coping tip is to write a list of things you feel grateful for and why. My wife – our relationship continues to grow, and I cherish this after...
2023-01-12
26 reads
Azure SQL Managed Instance – Cost Saving!
We all would like to save money when operating in the cloud, Microsoft has released a stop / start concept for SQL Managed Instances – preview mode! At the...
2023-01-12
61 reads
Getting Started Connecting to a Database with Flyway
In a previous post, I got Flyway installed as a CLI utility (command line interface). This post will look at the first connection to a database. If you need...
2023-01-27 (first published: 2023-01-11)
420 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 Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
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