Slacking and data quality (in that order)
Well, I almost missed blogging for the entire month of June. I'm sure that this fact didn't go unnoticed by...
2008-06-30
1,401 reads
Why Format TSQL?
Recently I had the chance to help a student debug a problem on a production server. It appeared to be...
2008-06-29
1,462 reads
Volunteering
Recently I was visiting with an old acquaintance and one of the topics that came up was volunteers. At some...
2008-06-26
2,217 reads
More Kindle
I'm still on the fence here about a Kindle. I pinged someone that bought one and he said they're returning...
2008-06-26
1,500 reads
SQLSaturday Call for Speakers - Cleveland & Olympia
Call for speakers is open for SQLSaturday #5 in Olympia, WA on Oct 10 (note that the MS BI conference...
2008-06-25
1,466 reads
One Note - Part II
Apparently other people like One Note. Microsoft is using it for learning content, and I think that's a cool idea....
2008-06-25
1,575 reads
Employee or 1099?
My friend Wes Dumey does a lot of work in the business intelligence sector as a contract employee and has...
2008-06-24
1,621 reads
SSWUG Virtual Conference II
Today is day one of the SSWUG SQL Server Virtual Conference II. This has been really fun so far. Our...
2008-06-24
1,518 reads
Microsoft BI Conference Oct 6-8, 2008
Had missed the announcement, came up in conversation yesterday with a friend, the BI conference will be Oct 6-8 in...
2008-06-23
1,639 reads
Notes on My Visit to Birmingham SQL Group
Spent last Tues/Wed in Birmingham, speaking at the user group Tuesday night and then presenting a seminar on Wed. Attendance...
2008-06-22
1,405 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