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
123 reads
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
123 reads
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
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
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,393 reads
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
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
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
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
136 reads
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
7 reads
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
2025-01-31 (first published: 2025-01-20)
278 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers