Expense Reporting
I got a $25 app card with my iTouch, and forgot about it. However when we had guests over last...
2009-09-07
473 reads
Blog Posts
MIF Busters
Management Information Format (MIF) files are formatted text files containing additional information about hardware and software components. The MIF format originated...
2009-09-07
1,598 reads
Running with more permissions
Recently someone was asking how they could execute some ALTER DATABASE commands without requiring sysadmin permissions. This person's company didn't...
2009-09-07
353 reads
SQLPSX Developer Blog
Powershell enthusiast, DBA and new SQL Server PowerShell Extensions developer Mike Shepard started a blog. Mike addresses a common question...
2009-09-07
490 reads
Uploading a List of Names For a LinkedIn Group
It’s been a couple months since we set up the OPASS group on LinkedIN and we’ve had some people join,...
2009-09-07
296 reads
Workaholics Anonymous – Providing A Development/Deployment Management Template on Labour Day
As mentioned by Phil Factor during the previous post’s comments regarding an example disaster recovery template/plan, and to keep in...
2009-09-07
1,936 reads
Tampa Code Camp Date Announced
The next Tampa Code Camp will be Nov 7th, 2009 at the KForce Building in Tampa. For the first time...
2009-09-06
311 reads
e-Readers - $50?
I don’t think this survey was done well. Most people want an e-reader for $50, according to the survey. That’s...
2009-09-05
514 reads
Networking Successes
Over the last few weeks I’ve had several instances where I’ve had to learn new things and, in my struggles,...
2009-09-05
472 reads
Product Review: SQL Pretty Printer
SQL Pretty Printer for SQL Server Management Studio $39.95 single user $99.95 site license
having coding standards is a must for...
2009-09-05
1,889 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