Five Device Sync
Last night I was at the store with Delaney after karate and he mentioned that we needed to go pick...
2009-03-13
862 reads
Make the 2009 PASS Summit Better: Offer Your Speaking Tips to Others
This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of...
2009-03-13
846 reads
Disconnected From Data
I was looking at Twitter the other day and saw a few of the people I follow debating the need...
2009-03-13
800 reads
Dot Net Usergroup in Montreal Presentation notes - Grouping Sets in SQL Server 2008
Yesterday evening I gave a talk about Grouping Sets in SQL 2008 thanks in part to the original front-page blog post...
2009-03-13
656 reads
PASS Update #8
Last week I was in Seattle, so I decided to stay an extra day and drive up to Vancouver to...
2009-03-12
639 reads
SQL Server 2008 SP1 CTP - Released
Hi everyone, just little info that we have available the Service Pack 1 for SQL Server2008!
About overview, instructions, system...
2009-03-12
540 reads
Removing Indexes
I've always told DBAs and developers working for me that backups don't really matter. After all, 99.99% of the time...
2009-03-12
448 reads
Saving an Old Hammer
It's funny how life often gives us the buy or fix decision on some many things, and the hard part...
2009-03-11
589 reads
You Aren't That Interesting
Fundamentally as I get older, I think more and more men are pigs. There is definitely something wrong with them,...
2009-03-11
2,004 reads
SQLServerCentral on Twitter
We’re on Twitter as @SQLServerCentrl. We couldn’t fit the whole name in there given the limitations of Twitter, but feel...
2009-03-11
366 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