What is SQL Saturday?
I saw the following post from Andy Warren (blog | twitter), one of the creators of SQL Saturday. He was trying to...
2011-12-29
2,790 reads
Blog Posts
2011 PASS Board Election Results
Results of the 2011 PASS Board of Directors election were officially announced this morning. I want to congratulate my friends...
2011-12-28
781 reads
Learn SQL 2012
Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...
2011-12-28
1,621 reads
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out of curiosity, I decided to take a look at...
2011-12-28
4 reads
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out...
2011-12-28
840 reads
PASS Election Results
The 2011 Election results were just posted, congratulations to Adam Jorgensen, Denise McInerney, and Rob Farley for taking the top...
2011-12-28
690 reads
Retrieving position() value of node by using XQuery alone
You can only use the position() function within an xquery predicate and can't use it to return the position value...
2011-12-28
6,789 reads
SQL Server – Row count for all views / tables
Getting row count for all tables in a database is straight forward. You can display row count for all tables...
2011-12-28
2,833 reads
SQL Server 2012 (“Denali”): Master Data Services
SQL Server Master Data Services (MDS) has a number of enhancements in SQL Server 2012:
Improved web user interface – If you...
2011-12-28
1,836 reads
What’s new in SQL Server RC0 setup
Datacentre Edition is no longer available as a MS SQL Server 2012 RC0 candidate, Read MoreMS SQL Server 2012 RC0...
2011-12-28
717 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