Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
902 reads
Blog Posts
Modifying SQL Server Synonyms
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,390 reads
Public Role and Security
A good rule of thumb with the public role is to leave it be. Do not add permissions to this role. Add permissions on a per database and per...
2011-12-20
16 reads
SQL Server 2012 – new conversion functions
With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...
2011-12-20
1,198 reads
SQLSaturday Goes International
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
657 reads
Contracting is business not employment: Read the small print
This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...
2011-12-19
1,206 reads
Creating a Service Master Key in SQL Server
The basis for all the encryption in SQL Server is the Service Master Key, which is the top of the...
2011-12-19
4,535 reads
Junk dimensions
Junk dimensions are dimensions that contain miscellaneous data such as flags and indicators. When designing a data warehouse, you might...
2011-12-19
1,380 reads
PASS Summit 2012 Evaluation Results
I say it all the time because it’s worth repeating, feedback is a gift. Good, bad or indifferent (well, not...
2011-12-19
1,732 reads
Pitching Pebbles – Using Certificates to Grant Privileges
If you fill the jar with pebbles first, you'll never have room for the big rocks.
I’m sure you’ve heard the...
2011-12-19
1,215 reads
Blogs
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...
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
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