2015-09-18
9 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
5 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
7 reads
House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
5 reads
SQL Sentry Grows in the UK and Beyond
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
13 reads
Professional Development – A Recipe for Success
Originally appearing at ForITPros.com. Joe Webb’s father-in-law spent most of his adult life as a cardiologist. That’s a highly specialized and highly technical area in the field of medicine that...
2015-08-06
8 reads
DBTA – StretchDB, a Cool New Feature in vNext SQL Server
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...
2015-08-05
15 reads
Professional Development – What a Difference 60 Years Makes
Originally appearing at ForITPros.com. In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government...
2015-07-30
13 reads
DBTA – IT Employers Must Adapt to the Looming DBA Shortage
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing...
2015-07-29
17 reads
2015-07-24
5 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