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
233 reads
Steve notes that PostgreSQL 19 is late, but the reasons and implications extend to other platforms, and really, all other software.
2026-10-31
233 reads
2026-10-30
390 reads
“You don’t need more time because you already have all the time that you will ever get; you need more focus.” – from Excellent Advice for Living Boy, I...
2026-10-30 (first published: 2026-10-23)
167 reads
This month I want to look at a few of the things I’ve seen posted about cars during the last month. These are a few headlines, as well as...
2026-10-30
237 reads
2026-10-30
1,018 reads
AI LLMs can help find bugs, especially security vulnerabilities, in code. That appears to be happening with SQL Server.
2026-10-28
178 reads
2026-10-28
915 reads
I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...
2026-10-27
26 reads
The job market is tough and Steve has some advice today on how you approach your career.
2026-10-26
151 reads
2026-10-26
932 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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