Recovering Missing Templates in Visual Studio
Recently I decided to expand my coding knowledge and picked up a Visual Basic book. I’ve been working in this...
2009-07-06
785 reads
Episode #3 It's All About The Tools TV Show
Russ Fustino from Microsoft just sent me the link to episode #3 that was filmed at SQLSaturday #14 in Pensacola....
2009-07-06
485 reads
Richmond SQL Server Users Group
Actually a combination meeting of the Richmond .NET and SQL groups, put together for me. They normally meet on consecutive...
2009-07-06
742 reads
Fourth of July
Read the Declaration of Independence and then it’s time for fireworks and grilling, maybe some apple pie too!
2009-07-03
505 reads
Book Review: Rolling Thunder
Rolling Thunder ($7.99 @ Amazon) by John Varley is the third book in the series. I previously reviewed Red Thunder and...
2009-07-02
711 reads
HP Mini Netbook – Day 2
I arrived in Richmond, VA this morning earlier than expected. I was meeting a few people and things were pushed...
2009-07-02
1,463 reads
Stack Overflow, Server Fault, and SSC
Steve Jones sent me a link to a presentation Joel Spolsky did at Google about Stack Overflow (SO) and it’s...
2009-07-01
768 reads
The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
757 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
10,024 reads
HP Netbook 1030NR Setup
Unpacking the netbook was pretty simple. Open it, grab the large one page poster, and then the netbook. There were...
2009-07-01
704 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