-
Quick tip for OpenAI on APEX
Posting this here simply because I constantly forget it 🤣, and end up wasting hours of my life on a trivial thing! When configuring your APEX workspace to communicate with OpenAI you need to have some credentials. Under Workspace Utilities you’ll see the Credentials option which looks like this: Anyone using APEX is familiar with Read more
-
I got shamed into using AutoUpgrade
Content on Upgrades isn’t my normal thing but the reason I’m talking about AutoUpgrade is a simple one. My good friend Mike Dietrich and I were in India recently for the Yatra tour and he did a talk about patching and AutoUpgrade. And right there, in front of the audience, and he shamed me 🙂 Read more
-
Transactions on LiveSQL
Just a quick gotcha that often catches me out on LiveSQL, so posting it here to make sure you also don’t get caught out. (Quick Segue: If you’ve only used LiveSQL in the past, be sure to check it out again – it has been totally re-jigged give a much more modern experience.) LiveSQL allows Read more
-
Pictorial highlights from Yatra 2025
Nothing tech in this post. Just putting it here to hopefully you inspire you as either an attendee or speaker for next years event! Bengaluru/Mysuru Hyderabad Pune Mumbai Delhi Chennai Read more
-
First dabblings with SQLcl MCP server
If you watched the launch video from the SQLcl team, you were probably just as excited as I was to give it a whirl. So here’s a quick post showing what I did to get it to run and do a basic test. (Note: A few big GIF’s in this post, so it might take Read more
-
Can you prioritise DDL locks?
Anyone who read Animal Farm as a school student, will remember the famous line: “All animals are equal, but some animals are more equal than others” The concept of equality has been the same with database transactions since databases began. We all have equal rights in being able to lock a row for our exclusive Read more
-
Are the Fundamentals Too Much to Ask?
I am submitting (or a better term would be “trying to”) an abstract to a conference that has announced their Call for Papers. Like many conferences, there is a list of tracks/streams that are the focus of the conference, and hence the organizers would like your presentation to fit into one of those categories. For Read more
-
The junior programmer at your company might not be a human being
Prolog: I’m using the tweets in this post to demonstrate that what follows in this post is already a reality, not just an “old man yells at cloud” story :-). But I stress, the tweets serves as examples, not as a call to action to go attack these developers, their companies or their product(s). Vibe Read more
-
The first 10 years
Long time friend and mentor Tom Kyte used to say that you could describe your career by the Oracle versions you have worked with. I started (in the main) with Oracle 6 in the mid 1990s, along with some occasional dabbles with Oracle 5, but 20 years later in 2015, chancing upon a tweet led Read more
-
A new optimizer constant
Warning: This one really just for the old nerds out there 🙂 Decades ago, one of the great contributions to the Oracle community was made by Wolfgang Breitling. This presentation and associated PDF was probably the first true deep dive into how the optimizer works. One of Wolfgang’s discoveries was the default selectivity’s the optimizer Read more
-
Database timezone versus OS timezone
Typically when you install a database on a local server, the database time zone an the OS time zone will all be alignment. However, in the world of global database access this is not mandated to be the case. For example, on the database VM I’m running my laptop here in the Perth, the database Read more
-
Customizing the Oracle Documentation
I spend a lot of time in the Oracle database documentation, and because I like to be able to navigate it as efficiently as possible, I’ll typically download the entire set of the docs to have a local copy. (If you’ve ever experienced the latency from Perth to … well … anywhere except Perth 😁 Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 