Looping Over Values in Power Automate Desktop
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to implement a solution that leverages the
2021-08-03
57 reads
Blog Posts
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity Virtual Group entitled “3 Reasons Why Focusing on Tech Is The Worst Way To Deploy...
2021-08-02
14 reads
Azure Platform Series – renaming your YAML pipeline in Azure DevOps
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
Daily Coping 2 Aug 2021
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-08-02
16 reads
Padding a string in SQL Server
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to ... Continue reading
2021-08-02 (first published: 2021-07-15)
422 reads
The PowerBI Volleyball Report – Organizing Data To Start
One of my goals this year was to build a report that I can present to kids and parents showing the skills progression of their kids. I have attempted...
2021-08-02
17 reads
Estimating Nonclustered Index Size in SQL Server (Powershell)
I recently encountered a requirement to estimate the size of (a lot of) nonclustered indexes on some very large tables due to not having a test box to create...
2021-08-01
21 reads
Goal Progress for July 2021
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2021. As I look at goal progress for 2021, I’m going...
2021-07-31
18 reads
Daily Coping 30 Jul 2021
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-30
15 reads
Exporting Lists in SQL Multi Script
SQL Multi Script is a lesser known tool from Redgate Software that is designed to easily allow you to run scripts against many server instances with one click of...
2021-07-30 (first published: 2021-07-19)
322 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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