AI is everywhere, and if you spend any amount of time looking for answers on the Internet to your coding challenges, you've likely encountered a lot of poor, average, good, bad, amazing, and just-helpful-enough AI content. For awhile, I was avoiding the AI summary from Google as the quality seemed slightly off, but lately it's […]
2026-01-28
95 reads
GenAI technology is going to change coding, but there is still a lot of work available for humans.
2026-01-26
98 reads
An ETL issue with Excel causes issues, because the users didn't realize a limitation.
2026-01-23 (first published: 2020-10-19)
474 reads
2026-01-21
97 reads
We need data that represents the problem we want to solve, or we might not achieve our aims.
2026-01-19 (first published: 2021-01-21)
221 reads
Steve doesn't see a reason why we should have default passwords on systems ever.
2026-01-17
69 reads
When I was at the Small Data 2025 conference, one of the speakers was talking about their work with AI technologies. This person uses it a lot in their day job, often to complete tasks that they would have struggled to work on in the past, mostly because of time constraints, but also a lack […]
2026-01-16
172 reads
JSON has become a very popular data format used in many software applications. However, it's not magic.
2026-01-14
238 reads
SSIS is still in use by many customers. Steve discusses a few changes to SSIS in SQL Server 2025.
2026-01-12
354 reads
Many of us aspire to be senior level professionals at some point in our careers, but what separates us from others? Steve has a few thoughts today.
2026-01-09
114 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