Blogging From the 2009 PASS Community Summit
Like a lot of other SQL Server bloggers, this week I will attempt to write regular blog entries each day,...
2009-10-31
1,385 reads
Blog Posts
Not Attending/Presenting at SQL Connections
Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept...
2009-10-31
1,386 reads
PASS Officers for 2010-2011 Announced
Posted yesterday at http://www.sqlpass.org/Community/PASSBlog/articleType/ArticleView/articleId/118.aspx, Rushabh Mehta is the incoming President, Bill Graziano is the VP Finance, and Rick Heiges is...
2009-10-31
1,424 reads
SQL Server 2008 cluster install and slipstreaming!
I was asked to set up a SQL Server 2008 cluster on Windows 2008 R2 this past week. One interesting...
2009-10-31
2,127 reads
The Gift Count
I went by Best Buy this afternoon, with my updated budget, to grab 2 last gifts and blow out the...
2009-10-31
1,453 reads
When Technical Support Fails You – UPDATE and Answers!
As promised and update on what has happened so far. A correction needs to be made. the P800 is a...
2009-10-31
1,732 reads
Consider this while doing any UPDATE
Trigger:
When you create trigger for insert and delete we will get two reference table as “inserted” and “deleted” respectively now...
2009-10-30
1,495 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
Happy Halloween to the DBA - Pumpkin Carving as a Team Building Exercise
The past couple of days we have had some fun with a TeamBuilding exercise by means of designing our Pumpkin...
2009-10-30
2,078 reads
Heading back to Seattle
I love visiting Seattle, even in November. Getting to catch up with old friends and meet new people is always...
2009-10-30
1,458 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