SQL Server Standard, Volume 6, Issue #1
It’s alive! It’s alive!
That’s enough from Colin Clive.
It’ll be out for the Summit. SQL Server Standard lives again! Although, not quite in...
2009-10-27
709 reads
SQL University: Diving into Authorization
It's good to see all your bright and chipper faces here at SQL University. Hopefully you've digest Monday's lesson on...
2009-10-27
6,148 reads
Four New Zealand Cities are Final Stops on 30 Day Speaking Tour
After making seven presentations in Australia, I headed to New Zealand where I made four presentations in four cities, on...
2009-10-27
486 reads
Deterministic Functions
Do you know what determinism is? It's something that comes up periodically in Books Online as various SQL objects require...
2009-10-27
1,836 reads
Where Will We PASS Each Other?
In my a post on Monday, I talked about who I want to meet while at the PASS Summit. Today...
2009-10-27
870 reads
Book Review: Murach’s JavaScript and DOM Scripting by Ray Harris
In early September I received a complimentary copy of Murach’s JavaScript and DOM Scripting by Ray Harris (Amazon) to review. ...
2009-10-26
511 reads
Annoyed with LinkedIn
Funny how tools can surprise you. I’ve had in mind to set up a sub-group and invite all the SQLSaturday...
2009-10-26
603 reads
Notes on a Migration from Oracle to SQL Server
I have to admit, when asked to perform a migration from Oracle to SQL Server over the past couple of...
2009-10-26
586 reads
Special Events at PASS Summit
Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a...
2009-10-26
616 reads
Beginning T-SQL 2008
My book "Beginning T-SQL 2008" came out about two weeks ago. http://www.amazon.com/Beginning-T-SQL-2008-Kathi-Kellenberger/dp/1430224614/ref=sr_1_1?ie=UTF8&s=books&qid=1256604424&sr=8-1 It's a beginning book because I assume that the...
2009-10-26
794 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