Thinking About Robert Davis
It’s been more than a year and a half since Robert Davis passed away. I wrote a bit about Robert’s passing last April. I haven’t written about him since,...
2019-10-25
9 reads
Building my schedule for PASS Summit 2019
It’s just ten days until PASS Summit 2019 begins in Seattle. The schedule is up and there are loads of good sessions. Here’s what I’m putting on my calendar...
2019-10-24
10 reads
Workshop Report: Overcoming Obstacles on the Journey to Continuous Delivery for Databases (video with transcript)
I am living the dream, y’all: yesterday I was finishing up my workday and needed to record a video, but realized that our puppy had spent enough time in...
2019-10-17
7 reads
2019-10-10
12 reads
2019-10-10
36 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
84 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
769 reads
Leveraging WHILE LOOP
WHILE LOOP can be used for batch processing and can be helpful if you are dealing with huge data processing. Recently I did an analytics project where I had...
2019-10-09
22 reads
Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell
Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way....
2019-09-02
18 reads
Git Command Line Tutorial with SQL Change Automation for SSMS (video)
I’m really excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS). SQL Change Automation lets DBAs and developers use a migrations-first approach to create...
2019-08-26
20 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