SQL Server

Junk DNA – Junk Oracle, part 0000003 …. DROP TABLE IF EXISTS

Almost every week I write or enhance software components that are deployed into a PROD environment. Every week, the full-fat versions of the ...Read more

SQL Server Installation (end-to-end on new Ubuntu 18.04 Bionic Beaver Virtual Machine/Parallels on MacBook Pro)

Sometimes you get surprises while working in IT, you follow a simple set of instructions and things work for example. Rewording that sentence ...Read more

When you have to resort to statistics, you know it’s time to redesign the software, or throw it away!

Yesterday the system was running fun. Today it is slow. What changed? How many times has this damn question been asked? The answer is ...Read more

SQL Server to Oracle migration – déjà vu 002

Having migrated many systems from SQL Server to Oracle, I used to want to cry when I encounter this type of construct. [code ...Read more

SQL Server to Oracle migration – déjà vu 001

Every time I undertake a project to migrate a system from SQL Server to Oracle, I am reminded how deficient and cumbersome it ...Read more

ANSI SQL/Foundation

I have believed for some time that the SQL FROM clause is optional, that is optional from the standpoint of ANSI/IEC/ISO standards, not from ...Read more