SQL Saturday #62
I had the honor of traveling to Tampa Florida this past weekend and presenting a session to a great group...
2011-01-18
478 reads
Blog Posts
T-SQL Tuesday #014 Roundup
Wow…the inagural 2011 T-SQL Tuesday was so big, it lasted a week! A few quick observations, then on to the...
2011-01-18
1,271 reads
Why Every DBA Needs a Buddy
If you truly desire to be an effective SQL Server Database Administrator then you absolutely must have a buddy.
SQL Server...
2011-01-18
1,906 reads
2011.....So (long pause), what's next for me?
I've actually sat down to write this blog several times. I am never indecisive when it comes to my thoughts...
2011-01-17
1,075 reads
EPM Framework and SQL 2008 R2
This weekend at SQLSaturday 62 in Tampa, I presented my policy-based management presentation. During my presentationone of the cool things...
2011-01-17
1,317 reads
Isolation Levels–MCM Prep
I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew...
2011-01-17
1,328 reads
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-17
4,715 reads
My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
548 reads
Notes from SQLSaturday #62
The weekend started with a later afternoon drive to Tampa, returning a couple calls and then chatting with Steve Jones...
2011-01-17
620 reads
SQL Saturday SQLSaturday #62 - Tampa Review
For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event.As I promised in the...
2011-01-17
1,266 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