T-SQL Tuesday #183 Invite: Tracking Permissions
It’s time for T-SQL Tuesday again and this month I’m hosting. I realized that I didn’t host in 2024 and since I run the thing, I ought to be...
2025-02-04
124 reads
Blog Posts
Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger
Recently I was talking with someone who had not named any of the primary keys (PKs) in their database. They used system generated names and when they ran comparisons,...
2025-02-03
102 reads
Monday Monitor Tips: Using the PowerShell API
Redgate Monitor has grown tremendously from its early days and I find many customers using this to monitor lots of servers, like thousands. In those cases, some of tasks...
2025-02-03 (first published: 2025-01-20)
325 reads
Using OneLake for Excel Files in Microsoft Fabric
Hey data friends! This blog is to discuss an edge case I’ve run into in Microsoft Fabric. I won’t go into all the context, but the goal was to...
2025-02-03 (first published: 2025-01-21)
2,420 reads
Advice I Like: Why am I doing this?
You are never too young to wonder “Why am I still doing this?” You need to have an excellent answer – from Excellent Advice for Living I’d say that...
2025-01-31
12 reads
Another AI Faux Pax
I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it...
2025-01-31 (first published: 2025-01-20)
416 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-01-31
21 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-01-31
149 reads
Common Issues When Using Change Tracking for Data Warehouse Incremental Loads
I have a few clients that incrementally load tables from a SQL Server source into their data warehouse or lakehouse by using change tracking. Lately, they encountered some issues...
2025-01-31
9 reads
Data Governance: The Invisible AI Accelerator
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
2025-01-31 (first published: 2025-01-20)
279 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