Notes on the South Florida Code Camp
I attended the South Florida Code Camp this past Saturday and it turned out to be quite an event. More...
2008-02-04
316 reads
Ask for SQL Server 2005 SP3
In case you haven't seen this elsewhere, if you want Microsoft to release SP3 for SQL Server 2005. It's time...
2008-02-03
945 reads
SQL Server MVP Randy Dyess webcast on SQL Server 2008 Security
SQL Server MVP Randy Dyess has a short webcast which provides the highlights of SQL Server 2008 security.He includes some...
2008-02-03
617 reads
SQL Server MVP Andy Leonard on .NET Rocks!
SQL Server MVP Andy Leonard is on the latest edition of .NET Rocks! If you're not familiar with .NET Rocks!,...
2008-02-01
751 reads
The Importance of Verifying Database Backups Regularly
Yesterday, as I was pulling into my driveway, my front left tire gave. Thankfully, I was going really slow and...
2008-01-31
1,665 reads
A Long Overdue Database Security Rant
I've been dealing with a security product from a security company in recent days that breaks best practices with respect...
2008-01-30
2,305 reads
Hello Secure World - MS Site Worth Looking At
Saw this in the MSDN flash yesterday, MS has a new Silverlight site up (newest toy and all!) that focuses...
2008-01-29
1,398 reads
The Long Tail
Another book I read recently, The Long Tail by Chris Anderson of Wired Magazine goes into detail talking about some of the changes...
2008-01-29
1,483 reads
Part II of Troubleshooting Memory Issues
The Windows Server Performance Team has published part 2 of troubleshooting memory issues.
This one covers excessive paging and memory...
2008-01-29
1,680 reads
First Heroes Happen Here (HHH) Comic
Microsoft and Seagate have partnered togethered to put together an IT Heroes comic (daily even). The first one is here:
...
2008-01-29
1,562 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
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...
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