New vCore Compute Levels for Azure SQL Database and Elastic Pools
Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers....
2019-01-10
208 reads
Blog Posts
Power BI World Tour 2019 Tampa
In just a few weeks (Jan 21-22) I will be presenting on two topics at the Power BI World Tour...
2019-01-10
347 reads
Sorting Values in a Column
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-10
280 reads
SQL Server Transaction Log is full due to XTP Checkpoint Error 9002, Severity 17, State 16
I want to take some time and discuss my experiences with a certain SQL Server error, error 9002. Error 9002...
2019-01-10
14,804 reads
Visualizing Hash Match Join Internals And Understanding Their Implications
This post is part 3 in a series about physical join operators (be sure to check out part 1 – nested...
2019-01-10 (first published: 2019-01-02)
2,778 reads
Watch: Can This Team Succeed at DevOps? Panel discussion
I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter. If you didn’t make the meeting, you can catch our 90 minute discussion here about...
2019-01-10
4 reads
Why is the query hash so useful?
An example of how I use the query hash
I wrote a blog on what the query hash is, right here....
2019-01-10
6,657 reads
A Monumental Migration to SQL Server 2016 - Part 2
In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...
2019-01-09
18 reads
A shell for working with Kubernetes
I’m always a fan of tools that can make my life easier.
One tool that I’ve recently come across is...
2019-01-09
172 reads
Back to the future
It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...
2019-01-09
232 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