December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out...
2011-11-30
1,628 reads
Blog Posts
Download: Troubleshooting a day – Nov 2011
As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here....
2011-11-30
1,431 reads
Forgiving Mistakes
My main phone line at the house has been on the fritz for about 3-4 weeks. Yes, we still have...
2011-11-30
2,430 reads
GO statement breaks SSIS Execute SQL Task
I have lost an hour today trying to find a bug in my SSIS package, and it was so small...
2011-11-30
6,819 reads
It was a pleasure to work with the NomCom
With the announcement of the official slate for the BoD election for this year, the job of the NomCom is...
2011-11-30
2,548 reads
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,325 reads
Saxophone Fire and Bad Words
There is nothing like having two children to remind you how strange, funny, and complicated language can be. Try answering...
2011-11-30
1,598 reads
SQLRally 2012 - Dallas Registration Is Open!
Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price...
2011-11-30
2,039 reads
SQLRally 2012 Registration Open
The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the...
2011-11-30
1,488 reads
Start Documenting Your Day! Why Now?
I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about...
2011-11-30
1,532 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