Microsoft Fabric – the first look
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
463 reads
Microsoft Fabric – the first look
Microsoft has just announced Microsoft Fabric during the Microsoft Build conference. This is a unified analytic solution of the era of AI. Microsoft Fabric is an end-to-end, unified analytics...
2023-05-24
9 reads
Weekly reading #30
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
42 reads
Weekly reading #30
Good morning in November! We were all looking at the Microsoft Ignite in Orlando last week. And it happened! SQL Server 2019 is now generally available – more details...
2019-11-11
13 reads
Interview with Bob Ward
This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...
2019-10-30 (first published: 2019-10-18)
377 reads
Weekly reading #29
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...
2019-10-21
26 reads
Weekly reading #29
The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad practices for security in SQL Server. He summarizes all the most important areas you should...
2019-10-21
11 reads
Interview with Bob Ward
This is the eight interview we have done. This time our guest is the one and the only Bob Ward! Bob Ward is a Principal Architect for the Microsoft...
2019-10-18
10 reads
Interview with Joe Sack
This is the seventh interview we have done. This time our guest is Joe Sack! Joe is Principal Program Manager for Azure SQL Database with a focus on query...
2019-10-11 (first published: 2019-10-03)
316 reads
Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
32 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