We have numerous Azure Analysis Services servers running in the cloud and needed a way to have near-real time monitoring of the queries being run. This KQL query will...
2024-02-21 (first published: 2024-02-06)
241 reads
I first saw this at Schneier on Security. David Kahn, author of The Codebreakers, has passed away at 93. The Codebreakers was considered the best book on the history...
2024-02-05
52 reads
Last week, the Cybersecurity & Infrastructure Security Agency (CISA) put out an emergency directive which ordered federal agencies to pull Ivanti Connect Secure and Ivanti Policy Secure installations from...
2024-02-23 (first published: 2024-02-05)
196 reads
I love this logo. Our marketing people were very creative. After the van tour last year, we decided to go with a plane this year. I wrote about the...
2024-02-05
48 reads
All Spark Connect Posts
Code
Goal of this post So there are two goals of this post, the first is to take a look at Apache Arrow and how we can...
2024-02-05
103 reads
Azure SQL Database and SQL Server 2016 introduced a new security feature for SQL Server databases called Always Encrypted. Always Encrypted is a feature designed to protect sensitive data,...
2024-02-19 (first published: 2024-02-04)
581 reads
Flyway Desktop changed the navigation and a few people were surprised. I was as well, so I decided to do a short tip on the changes. This is part...
2024-02-16 (first published: 2024-02-02)
194 reads
The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...
2024-02-02
41 reads
tarrion – n. an odd interval of blankness you feel after something big happens to you bt before you feel the resulting emotional reaction – stunned by a sudden...
2024-02-02
84 reads
Quite a long title for quite an annoying issue. Let me explain the set-up first: I have pipelines running in Azure Data Factory and I want to send e-mails...
2024-02-03 (first published: 2024-02-02)
33 reads
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Comments posted to this topic are about the item BIT_COUNT II
Comments posted to this topic are about the item I Can't Make You Learn
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
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