2026-11-02
90 reads
software development
PostgreSQL 19 Is Late
Steve notes that PostgreSQL 19 is late, but the reasons and implications extend to other platforms, and really, all other software.
2026-10-31
209 reads
Choose the Second One
Steve talks software design and architecture today with an interesting idea: design it twice.
2026-10-23
94 reads
Designing for Teams
When we build software, or we put together a process, we need to consider how teams use it, not just individuals.
2026-09-28
121 reads
Absolute and Relative References
One of the challenges in digital systems involves how we reference other resources. Steve discusses whether absolute or relative references are better.
2026-09-26
85 reads
Make It Routine
Solving problems can be challenging, but once you have something built, it should be easier the next time.
2026-09-21
138 reads
2026-09-19
191 reads
2026-08-14
231 reads
Building Great Software
Steve notes that building great software isn't easy, and there is a lot of work that goes into this. Even in today's age of AI.
2026-08-12
250 reads
Imagine the Physical World
Today Steve notes that he often compares the work a computer does to what might happen if the same actions occurred in the physical world.
2026-08-10
190 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