Perks at Work - A Good Thing?
Free oil changes, extra week of vacation when you get married, etc, etc, all things mentioned in this article someone...
2008-02-25
1,423 reads
Lessons Learned from SQLSaturday #2 - Tampa 2008
I posted earlier about the event being a great success with more than 200 attendees, in this post I want...
2008-02-24
1,480 reads
The Advantages of Telecommutting
It isn't often that I see what the real advantages are, and I've been doing it so long that I...
2008-02-22
1,346 reads
LINQ Again!
I recently attended SQLSaturday#2 in Tampa and had the brief chance to chat with David Hayden about LINQ (I suspect I...
2008-02-21
1,812 reads
Call for Speakers for PASS Summit is Open Through March 28, 2008
The Summit is being held in Seattle, WA, Nov 18-21, 2008. Call for speakers is open through March 28. It's...
2008-02-21
1,428 reads
New Book from Celko - Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL
I've been meaning to post this, Joe's latest book Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in...
2008-02-20
1,529 reads
Changing the Command Prompt
I spend a lot of time at the command prompt and to be perfectly honest, I'm tired of looking at:
...
2008-02-20
1,751 reads
Dry Erase Board v2
When we first set up shop for End To End Training we knew we wanted both a flip chart and...
2008-02-19
1,604 reads
Errata for SQL Server Certification Books
Back in this blog post, I indicated which books I was using to complete the MCITP certifications for SQL Server....
2008-02-19
1,742 reads
SQLSaturday #3 - Jacksonville 2008 - Registration and Call for Speakers is Open
My business partnerBrian Knight just finalized the venue for the next SQLSaturday. Number three will be held at the University...
2008-02-19
1,219 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