Professional Development – Set the Bar High
Originally appearing at ForITPros.com. Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.” That’s great insight. Too often...
2015-07-23
10 reads
DBTA – Does the Looming Shortage in DBAs Spell Opportunity?
Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available HERE, I described some of the findings contained in an intriguing new...
2015-07-22
11 reads
Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
14 reads
Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
10 reads
Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
10 reads
Rebuilding Existing Partitioned Tables to a New Partition Scheme
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
7 reads
Rebuilding Existing Partitioned Tables to a New Partition Scheme
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
10 reads
Rebuilding Existing Partitioned Tables to a New Partition Scheme
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
10 reads
2015-05-13
14 reads
Performance Impacts of Partitioned Aligned Indexes
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 2. The partitioning includes several major components of work (and can be linked...
2015-05-12
7 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