Featured Blogger: Glenn Berry
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
730 reads
Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
458 reads
Kindle Alternatives – B&N on Blackberry
I’m not a fan of Blackberry devices. Actually that’s not true, I really dislike them. They’re not intuitive, and I’ve...
2009-07-22
1,288 reads
My Virtual Lab setup Hyper-V 2008 and Virtual Server 2005 R2
One of the things I’ve maintained over the years is a lab to do everything I need. From testing new...
2009-07-22
3,537 reads
Database Mirroring - Hitting the Limits
When I first heard about database mirroring in 2004, I was excited. Here was a great new feature that would...
2009-07-22
4,386 reads
Meet, Greet, & Remember?
How many of you have said, “I have a real hard time remembering names” or “Excuse me, I know we...
2009-07-21
414 reads
PASS Update 12
Time for another update on all things PASS. I’ve been struggling to find time for PASS activities and having to...
2009-07-21
610 reads
Barnes and Noble eBooks
I saw yesterday that Barnes and Noble released their e-reader for iTouch/iPhone, Blackerrys, Mac, and PCs and at the same...
2009-07-21
795 reads
Contest to Win a Free Trip to PASS
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
711 reads
Security Basics: Physical Security
In IT security, we spend so much time trying to protect servers and computers on the wire (or on wireless)...
2009-07-21
1,259 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