-
New Podcast Episode – The Burden of Proof
There’s a reason we don’t just lump all of our data into Excel, Word and other such tools. Databases exist to give rigour to our data. They are the “statement of record” – the proof that our applications are meeting any business and/or regulatory requirements. The data stored in the database is typically the evidence… Read more
-
Reset a sequence #JoelKallmanDay
It’s funny how “workarounds” to problems become so ingrained in the public eye that they quickly become treated as the permanent solution. That might all be well and good, but often that leads us into the trap of becoming blinkered to better solutions that might arrive later down the track. Here’s a simple example of… Read more
-
SQL Macros will change the world
At CloudWorld, after one of my sessions an attendee came up to me and said: “Wouldn’t it be cool if we could modularise frequent SQL commands”. I initially thought he meant database views, but he clarified his statement further: “For example, I regularly load data from an external source and I need to check for,… Read more
-
Its back! The CloudWorld MEGA download!
We’ve all been there… You head over to the Session Catalog for CloudWorld and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed. Then you discover… you need to click on each session to see the file name to download…. Ugh!… Read more
-
Planning for CloudWorld – Lets bring this baby home on Thursday!
Unlike previous years, the last day of CloudWorld is jam packed with a full day of content. Lots of goodies here starting first thing in the morning. Here’s some of my picks for you to round off a great week in Vegas! For the Early risers… If you don’t party too hard on Wednesday night,… Read more
-
Using the 23ai Free Database VM? Check this setting
If you’ve ever used a cloud database, then it is most likely that database was running in the “time zone” UTC. (UTC is not a time zone per se, but basically we’re running in GMT which means the database and server run at a zero time offset). I’ve done a video in the past about… Read more
-
Planning for CloudWorld … Wednesday is the LAB extravaganza!
Wednesday is THE day at CloudWorld if you’re into hands-on experiences with the tools and products. It’s funny how the same people that like to criticise conferences for being “too much marketing” are the same ones that I never tend to see attending a hands-on lab. I’ve put a link under each one so you… Read more
-
Planning for CloudWorld … Tuesday is a big day
In years gone by, I’ve arrived in OpenWorld/CloudWorld from Australia on the evening before the event starts, and thus been a total zombie for the first day. This year, due to some “excellent planning” on my part (and not at all due to my misreading the event start date! 😂) I will be arriving one… Read more
-
DBMS_STATS – What is going on?
Big thanks to Nigel Bayliss for his input on the post I was helping a customer recently with some of their queries against the data dictionary running more slowly than they expected. When we investigated a little further we discovered that this was no “typical” database. Everyone in their organisation got to have a schema… Read more
-
TIL a new thing about Private Temporary Tables
Many DBAs and Developers are fluent with the use of Global Temporary Tables in the Oracle Database. However, since 18c we have also had another form of temporary table, namely, Private Temporary Tables. If you’re unfamiliar with them, then here’s a quick video explaining one of the core benefits of them. There’s a few restrictions… Read more
-
ChatGPT versus India
I’ve just been on the AIOUG Yatra tour, a rollercoaster ride of 6 conferences across 6 cities in just over a week. As always, the Indian tech community is full of energy and enthusiasm, and the week was a fantastic experience. Good friend Basheer Khan did a keynote on the emergence of AI tools such… Read more
-
Using Express or Free edition? A potential trap
For many people in the Oracle community, downloading and configuring Oracle Express Edition or Oracle Database Free (For the rest of this post, I’ll use the term “Express Edition” to mean both) is about being able to easily bring yourself up to speed on the latest features available in the Oracle Database, as well getting… Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 