Can You Let Go of Determinism
As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.
2026-02-23
159 reads
software development
Deep Learning and Craftsmanship Matter
GenAI technology is going to change coding, but there is still a lot of work available for humans.
2026-01-26
147 reads
2026-01-21
120 reads
Eight Minutes
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
208 reads
Refactoring SQL Code
Refactoring code is a common task in many software development teams. Steve asks if this is something common for database developers as well.
2025-12-12
443 reads
Done is Better than Good
Getting something done is important, but so is the quality level. Steve has a few thoughts today.
2025-11-26
118 reads
PRs Are Like Trouble Tickets
Adopting a modern development approach brings with it the need to manage PRs, which Steve thinks can be like trouble tickets.
2025-10-01
144 reads
Requiring Technical Debt Payments
Steve found someone using an interesting approach to get developers to address some technical debt.
2025-09-08
251 reads
The Technical Debt Anchor
Technical debt is something all of us deal with in our systems, and today Steve has a few thoughts on the impact of debt on database sysstems.
2025-06-25
197 reads
Patching the Patch
If you have had to fix the thing you just fixed with a fix, you might enjoy today's editorial.
2025-06-16
136 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers