More Seattle Food
Was browsing on a break and found this, http://www.seattle.com/dining/. Of them I’ve been to Palomino (good) and Ruths Chris (good),...
2009-10-29
752 reads
Blog Posts
My PASS Summit 2009 Schedule
Hooray! The PASS Summit is upon us (finally)! Here's what my plans look like for next week:
Monday
My week starts...
2009-10-29
656 reads
Need an Aircard for a Few Days?
Ran across this, http://daypasswireless.com/, lets you rent an aircard plus service. Don’t know if it’s too late for those of...
2009-10-29
641 reads
OFF-TOPIC: More about the pregnancy
Quite a few folks have commented about my previous post about missing the PASS Summit, whether publicly or in private....
2009-10-29
891 reads
Special Events at the PASS Community Summit
If you’ve ever been to a PASS Community Summit, you know that each day is packed with a ton of...
2009-10-29
466 reads
SQL University: Multiple Paths and Ownership Chaining
Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...
2009-10-29
2,672 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-10-29
253,715 reads
There was a rancher who had a DBA.... (Getting prepped for PASS)
and B-I-N-G-O was his game-o.
Maybe not that funny, but I think that SQL Bingo will be a fun time. If...
2009-10-29
826 reads
What Should PASS Strive To Be?
Steve Jones had a good editorial earlier this week entitled, What Do We Want from PASS?. It didn’t generate as...
2009-10-29
930 reads
Amazon.com Author Central Page
If you are a book author, Amazon.com now allows authors to promote their books with a new author’s page. The...
2009-10-28
610 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