SQL Saturday #21 – Orlando
Well we are less than two weeks away from SQL Saturday #21 in Orlando, FL. My bags are packed and...
2009-10-05
531 reads
Blog Posts
SQL Server 2008 Change Data Capture
SQL Server 2008 has a new Change Data Capture feature that allows you to track Inserts, Updates, and Deletes on...
2009-10-05
2,384 reads
A Hint For Recruiters (And You!)
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
357 reads
SQLSaturday 26 Session Files
SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...
2009-10-04
1,037 reads
Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,346 reads
Pitching in at SQL University
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,133 reads
Red Gate's SQL Data Generator
I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...
2009-10-03
3,041 reads
Southwest Florida Code Camp II
I presented a Powershel session at the SW Florida .Net Code Camp IIl. The session demonstrated the following uses cases for...
2009-10-03
537 reads
Choosing a career path; which way do I go?
“Should I get an MBA or an MCSE?” What an odd question. At least these days it seems odd. But,...
2009-10-02
301 reads
Editorial on the Incidental DBA
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
255 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 Kontak Bank BCA KCP Surabaya WA {08218154393}
WA:08218154393 Jl. Surabaya No.88 B-C, Ps. Baru, Kec. Medan Kota, Kota Medan, Sumatera Utara...
Alamat Kontak Bank BCA KCP Perak WA {08218154393}
WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT 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