SpeakerRate – Need Your Feedback
Everybody loves a compliment. Not everyone enjoys criticism, even if it’s constructive and politely delivered, but the fact is that...
2009-09-08
771 reads
Windows 7, UAC, and SQL Server
This is just a quick note, almost a continuation of my Access Denied, Not Possible post. I have been working...
2009-09-08
376 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
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
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
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
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
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
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
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Forums
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
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