Adding Objects to our SCA Project
In my last post, I started out with a new SCA project, getting a connection to my database up and...
2019-03-08 (first published: 2019-02-13)
2,684 reads
Blog Posts
I’ve added data classifications. Now what?
About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...
2019-03-08 (first published: 2019-02-20)
2,546 reads
Pausing the Learning for March
In my last update, I was disappointed with my February progress. Busy with life and work, I didn’t do much...
2019-03-08
865 reads
VMware vExpert for 2019
I’m honored and humbled to be awarded the VMware vExpert award for the seventh year in a row! Thank you...
2019-03-08
306 reads
Writing my presentation 2: Designing the presentation
This series is about my process for writing my upcoming presentation at SQL Saturday Chicago #825.
Today’s goals
Today I’m going to...
2019-03-08
342 reads
Can you speak at my User Group or Conference? No? Sweet As – can you help people register please?
This blog post is not going to be a technical one…. but it’s about technology – well more accurately about bringing...
2019-03-07
297 reads
Creating custom SQL Server Helm charts
In my previous post I went through how to deploy SQL Server to Kubernetes using Helm in which I used...
2019-03-07 (first published: 2019-02-20)
3,030 reads
Finding single use plans in the plan cache
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,908 reads
Writing my presentation part 1: The brainstorm/dump
For this session, I’m relying on a mixture of previous blog posts and new material/demos that I’ll have to write....
2019-03-07
396 reads
#DataInDevon – Getting up to speed with PowerShell or spend a day with one of four other MVPs :-)
Saturday 27th April is Global Azure Bootcamp day
What’s Global Azure Bootcamp?
The website says it best
…. communities will come together once...
2019-03-06
301 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 KANTOR BCA KCU KISARAN TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200174
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas 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