Top 10 Free SQL Server Tools
What better way to kick off a new year than with a look back at some of the top free...
2013-01-15
12,965 reads
John Sansom
Step Up and Take More Ownership
This post is part of the T-SQL Tuesday Meme, this month hosted by Jason Brimhall. His chosen theme, to come up with...
2013-01-08
1,559 reads
Your Top 10 Posts of the Year
Top of the Flops
Short and sweet today, here’s what you enjoyed reading the most this year on the blog. No...
2012-12-17
783 reads
The Great DBA Getaway
Free, at last!
It’s holiday season which means it’s a time for you all to buy me gifts super busy time for Data...
2012-12-12
1,032 reads
A Journey To SQL Authority
I am delighted to welcome to the blog someone who is without a doubt one of the biggest names in...
2012-10-09
1,128 reads
Clients Love The Way I Jiggle
It’s one of the most enjoyable things about being a consultant.
I’m not talking about my suspect dance moves here. I’m...
2012-09-18
1,142 reads
Something for the Weekend – SQL Server Links 14/09/12
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server Links,...
2012-09-14
1,531 reads
How To Simply Say You’re a DBA
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply?...
2012-09-03
978 reads
The Hollywood DBA
I’m delighted to welcome a fellow Brit to the blog to share their story in today’s guest post. Many of you will...
2012-07-18
1,001 reads
Lunch is for Wimps
A real life DBA tale from the trenches with some awesome advice. That’s what one reader chose to share with...
2012-07-03
1,265 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