New PASS Chapter in Orlando–MagicPASS
Kendal Van Dyke is launching a new PASS Chapter called MagicPASS in Orlando this week, with the first meeting on...
2011-01-19
684 reads
Blog Posts
SSMSDeploy Now Available!
I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...
2011-01-19
606 reads
Time To Get Your #SQLRally Vote On!
It’s week two of voting for the upcoming SQLRally. This week, we are voting for the Database & Application Development sessions...
2011-01-19
453 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,087 reads
Who do you want to see at SQLRally and 24HOP?
I dig democracy: I like all this voting for SQL sessions at events.
Voting is open this week, Jan17 – 23, for...
2011-01-19
615 reads
You Need Two SLAs for Disaster Recovery
Continuing on with my MCM prep, I was listening to the High Availability/DR prep module today and I was once...
2011-01-19
1,880 reads
31 Days of SSIS – Environmental Variable(17/31)
31 Days of SSIS
It’s time to go back to discussing the environment when it comes to SSIS packages. For the...
2011-01-18
2,530 reads
Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2
Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...
2011-01-18
2,634 reads
DBA 101: Why is my log file full?
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-18
2,674 reads
Distincting an IN subquery
This is going to be a quick one…
I keep seeing forum code (and production code) that includes the DISTINCT in...
2011-01-18
6,133 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