Daily Coping 23 Feb 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-02-23
13 reads
Blog Posts
Merging PDFs with Power Automate Desktop
In this video we start exploring some of the simple actions that are available within the Power Automate Desktop to create a solution that can
2021-02-23 (first published: 2021-02-16)
452 reads
Passing JSON arrays between pipelines in Azure Data Factory
(2021-Feb-15) This post a continuation of my personal experience working with arrays (or simply JSON structures) in Azure Data Factory (ADF). It just happened that the more I work with...
2021-02-23 (first published: 2021-02-15)
8,985 reads
Calgary Data User Group – 24 February 2021 at 5pm MST
This Wednesday, from 5pm to 7pm Mountain Standard Time, the Calgary Data User Group is presenting two sessions for your virtual attendance. 15 minutes: A lightning talk on Kubernetes...
2021-02-22
24 reads
Daily Coping 22 Feb 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-02-22
15 reads
Grant or Revoke Permission on Power BI Report Server
I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last...
2021-02-22 (first published: 2021-02-10)
537 reads
Installing and Configuring containerd as a Kubernetes Container Runtime
In this post, I’m going to show you how to install containerd as the container runtime in a Kubernetes cluster. I will also cover setting the cgroup driver for...
2021-02-22 (first published: 2021-02-14)
422 reads
Turn Your WordPress.com Blog into a Podcast with Anchor
If you’re a blogger, you’ve already done the hard part by creating great content — so you should share that content as widely as possible! One way is by...
2021-02-22
30 reads
Virtual User Group Presentations, Feb 23-24
I'll be presenting at two virtual SQL data platform communities this week on a couple well-rehearsed topics, each with fresh updates.
Tuesday, February 23, 2021
12:00 PM to 1:30 PM EST
DBA...
2021-02-22
12 reads
Using Docker on Mac to have persistent SQL Server settings and databases
This is a super simple way to retain the data and settings that you create and change on your SQL Server Docker instance. There’s a lot of talk about...
2021-02-21
21 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