MS, kill Begin/End!
It's funny - sorta - how you become used to the quirks of the tools you. I try not to rant too...
2007-11-29
1,414 reads
Another use of OpenRowSet()
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,412 reads
Why Don't People Go to Free Training?
I was having this discussion recently with Shawn Weisfeld, President of ONETUG and it's definitely a frustrating topic. As a...
2007-11-28
1,424 reads
Google CIO and IT Strategy
CIO Magazine has a interesting article about Douglas Merrill, the CIO of Google. One of the things he dicusses in...
2007-11-26
1,706 reads
Community Search vs Brute Force Algorithms
I was reading an interview with Jimmy Wales (the Wikipedia guy) in Selling Power magazine (I have ecletic reading preferences...
2007-11-26
1,364 reads
Passed 70-431
After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of...
2007-11-25
1,450 reads
Honeypots in the Database
As a follow up to my post about Cesar Cerrudo's new whitepaper, earlier this month David Litchfield talked about putting...
2007-11-23
2,349 reads
Whitepaper on Malware to Attack Databases
Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing...
2007-11-23
1,976 reads
Buying a New Cell Phone
For the page 10 months or so I've been using a Samsung Blackjack, before that I used various Blackberries for...
2007-11-21
1,437 reads
Logging Server Reboots - What the Heck MS?
Maybe someone at MS can explain this; they have that nice dialog that comes up after a reboot where you...
2007-11-21
1,406 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
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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