A Big Year for Travel
I do tend to travel a good amount as my kids have gotten older. The pandemic slowed things for a year, but only then. Someone remarked on this year...
2022-12-23
19 reads
Daily Coping 23 Dec 2022
Today’s coping tip is to be generous. Feed someone with food, love, or kindness today It’s often a family day today, as work ends and we prepare for Christmas....
2022-12-23
19 reads
Daily Coping 22 Dec 2022
Today’s coping tip is to buy an extra item and donate to a local food bank. The food banks in my area are only open limited days, especially post...
2022-12-22
25 reads
Use the output of a Script activity as the items in a ForEach activity in Data Factory
In early 2022, Microsoft released a new activity in Azure Data Factory (ADF) called the Script activity. The Script activity allows you to execute one or more SQL statements...
2023-01-09 (first published: 2022-12-22)
373 reads
Daily Coping 21 Dec 2022
Today’s coping tip is to listen wholeheartedly to someone else, without judging them. I get the chance to talk with lots of people. I make it a point when...
2022-12-21
22 reads
Understanding Keys and Certificates with TDE
When you first look at the encryption hierarchy for TDE in SQL Server it can be a bit daunting. There seem to be a lot of objects involved and...
2023-01-04 (first published: 2022-12-21)
340 reads
T-SQL Tuesday #157- “End of Year Activity” – RECAP
I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
257 reads
Daily Coping 20 Dec 2022
Today’s coping tip is to do something helpful for a friend or family member. Easy one for me. My daughter came home from University yesterday, and I took time...
2022-12-20
19 reads
VMUG Ireland Relaunch Event
SAVE THE DATE: VMUG Ireland Relaunch Event February 9th, 2023 Location: Dublin VMUG Ireland is back! We are hosting a VMUG Relaunch event in Dublin on February 9th, 2023....
2022-12-20
25 reads
Monitoring with the Pure Storage FlashArray OpenMetrics Exporter
This post introduces you to the Pure Storage FlashArray OpenMetrics Exporter. It shows you how to get started quickly using Docker Compose so you can monitor your Pure Storage...
2023-01-04 (first published: 2022-12-20)
343 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