Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018. I will be presenting two sessions, What is Power...
2018-11-12
6 reads
Blog Posts
Speaking At SQL Saturday DC
I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018.
I...
2018-11-12
159 reads
SQLCLR vs SQL Server 2017, Part 9: Does PERMISSION_SET Still Matter, or is Everything Now UNSAFE?
(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...
2018-11-12 (first published: 2018-10-31)
3,396 reads
Zombie SQL
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...
2018-11-12 (first published: 2018-10-31)
2,900 reads
Getting Started with Installing Kubernetes On-Prem
Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines.
Kubernetes is a distributed system,...
2018-11-11
1,225 reads
Getting Started with Installing Kubernetes On-Prem
Let’s get you started on your Kubernetes journey with installing Kubernetes on premises in virtual machines. Kubernetes is a distributed system, you will be creating a cluster which will have...
2018-11-11
12 reads
Happy Veterans Day to my SQL Brothers and Sisters!
Thank you all for your service!
I was fortunate to have attended PASS Summit again this year. As an added bonus...
2018-11-11
172 reads
Last week reading (2018-11-11)
Hello folks, how are you today? It was a very comprehensive week and many of my friends returned home after...
2018-11-11
85 reads
Data Classification in SQL Server 2019
One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS...
2018-11-09 (first published: 2018-10-24)
3,214 reads
Is your SQL Server environment ready for GDPR? Part 2
In my previous blog post of this topic, I talked about the definition of what GDPR is and also described...
2018-11-09 (first published: 2018-10-30)
3,477 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