When Technical Support Fails You
I have had the pleasure of being a vendor, and technical support for both hardware and software products. I know...
2009-10-30
1,508 reads
Twitter SQLBingo at the PASS Community Summit
Who are the people in your SQL neighborhood?
Stuart Ainsworth (Blog, Twitter), Brent Ozar (Blog, Twitter), and some other really bright...
2009-10-30
1,447 reads
MCTS: Business Intelligence Developer 2008 & MCITP: Business Intelligence Developer 2008
I am not about to get into a theoretical discussion of whether certifications will benefit you in your career. I...
2009-10-30
1,449 reads
OFF-TOPIC: God is Still Good, Even as We Mourn
Kimberly and I went to the high risk doctor's office this morning for the ultrasound. Unfortunately, they realized very quickly...
2009-10-30
1,920 reads
Fun in Seattle
I know there are a number of people heading to Seattle this weekend for the PASS Summit next week. I...
2009-10-30
1,624 reads
Running to the PASS Summit
Well, not literally. I’m not going to run to Seattle from Denver, but I’ll be running at the Summit.
Last year...
2009-10-30
1,525 reads
PASS Presentation Rehearsal
My friend Trevor Barkhouse called me up a couple of nights ago and asked if I could host a Live...
2009-10-30
1,582 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
Diners, Drive-Ins, and Dives – In Seattle
If you’re going to spend 3-5 days in Seattle at the PASS Summit it’s worth sampling the local food rather...
2009-10-29
1,749 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
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