Accessing Managed Instance via SSMS
It used to be that the only way to use SQL Server Management Studio (SSMS) against Azure SQL Database Managed Instance (SQLMI) was to create a VM on the...
2020-05-11 (first published: 2020-04-27)
556 reads
Blog Posts
Daily Coping 11 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-11
15 reads
How Does The CHOOSE Command Affect Performance?
Questions absolutely drive my blog content and I really liked this one: how does the T-SQL CHOOSE command affect performance. On the face of it, I honestly don’t think...
2020-05-11 (first published: 2020-04-27)
643 reads
Learn TSQL for free online – starting today
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required — we don’t...
2020-05-11
73 reads
SQLpassion Online Training about Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2020-05-11
15 reads
The Bite-Sized Redgate Summit comes back this week
This week we have another edition of the Redgate Summit taking place on May 13, 14, and 15. We have different times each day to cover the world. The...
2020-05-11
15 reads
T-SQL Tuesday Live – 12 May 2020
Once again, I’ll be live tomorrow, ready to just chat, shoot the breeze, answer tech questions, anything. No agenda, but I’m on for an hour. If you’re bored, struggling,...
2020-05-11
18 reads
Daily Coping 8 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-08
19 reads
Dropping a Database Now–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I find myself doing...
2020-05-08 (first published: 2020-04-27)
292 reads
TSQL for Beginners–#RGCommunityCircle
As a part of the Redgate Community Circle, giving back in this strange time, each of the advocates for Redgate is teaching a free course. We’re doing this live...
2020-05-08
144 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