This blog post is about YAML pipelines in Azure DevOps. I had a repo called InfrastructureAsCode for a client. I have been transitioning them to use YAML for their...
2021-08-02 (first published: 2021-07-15)
178 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a recent post, I started looking at...
2021-07-14
141 reads
My user group, the Calgary Data User Group, has been recording videos since April of this year, so at the time of this writing we have just two videos...
2021-07-14
14 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-14
17 reads
One of the biggest impacts on resource consumption for Azure SQL DB are repeated data pulls by the application layer. No matter how fast those queries execute calling the...
2021-07-14
55 reads
One of the biggest impacts on resource consumption for Azure SQL DB are repeated data pulls by the application layer. No matter how fast those queries execute calling the...
2021-07-14
93 reads
GitHub Actions is a very cool tool for automating CI/CD pipeline workflows or any routine task. Once the code resides in Github, automating tasks from using Github actions is...
2021-08-04 (first published: 2021-07-13)
160 reads
As you sit and wonder about when the next Star Wars movie is going to come out, do you ever get the thought of “I wonder if all my...
2021-08-04 (first published: 2021-07-13)
402 reads
Meet your posting goals on your site with this new feature in the iOS and Android apps.
2021-07-13
33 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-07-13
21 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
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