-
The Halloween Pumpkins of Terror
For some giggles this Halloween, over on Twitter I tweeted some worst practices each hour during Halloween in the guise of carved pumpkins. Here’s the complete set spanning the 24 hours – hopefully you do not recognise any of these in your data centre! Read more
-
CloudWorld is done!
Just a quick post with a few highlights from CloudWorld, but really this is all about getting you the slides from my presentations, because I know it can be frustrating when they don’t appear for a long time on the official CloudWorld pages. So here’s PDFs of my two talks: SQL Tuning in 45minutes Futuristic Read more
-
CloudWorld – Thursday Thrills
OK, lets close this week on a strong note with another bunch of awesome tech sessions on the database, APEX and SQL. I’m super excited to see that we’ve done away with the previous format of OpenWorld where we “wound things down” during the last day. This year we’ve got content going all day long Read more
-
CloudWorld – Wednesday Avawanche
Well my alliteration puns might not be so good, but the volume of cool stuff on Wednesday at CloudWorld is a lot better 🙂 Here’s my picks for what any database professional should be considering for Wednesday at CloudWorld. In particular, I’d love to see you at my SQL talk in the afternoon. Stop by Read more
-
Easy data access from Excel #JoelKallmanDay
I suspect Joel would have kittens if he knew I would use the appreciation day to talk about Excel instead of APEX but courtesy of an AskTom question I stumbled across this cool little tool for accessing data from your autonomous database via Excel. You might be thinking: “Hold on, we’ve been accessing Oracle databases Read more
-
Quick Tip on Datapatch
When I patch my databases through the various Release Updates, I normally do a blog post showing how easy and trouble-free the experience is. Some readers sometimes claim that this is because I’m just shilling for Oracle and that I’ll never show any problems I encounter So to stake my claim of honesty, openness and Read more
-
CloudWorld – Tuesday Turmoil
I took a quick glance at the schedule for Tuesday for CloudWorld and realised I’m going to need to clone myself to get along to the all sessions and labs that I’d like to see 😀. As I browsed through the schedule, the ones below jumped out as “Yeah, I’d like to get along to Read more
-
What are the Squirrels doing? SQL fun and games
Finding interesting data to improve your SQL skills can be a nuisance. There are of course plenty of freely available data sets out there, but analysing mortgage repayments over a 10 year cycle is not my idea of fun data to play with. (Apologies to any home loan brokers etc out there ).🤣 But how Read more
-
Patching just keeps getting easier
After attending a talk by Mike Dietrich at the DOAG conference, I was pleasantly surprised to hear that in 21c, there was no longer a need to patch the OJVM as a separate activity. But of course, being a natural cynic, I wanted to put Mike’s statements to the test. And yes indeed – patching Read more
-
Can you FLASHBACK an IDENTITY column?
I’ve just got back from the DOAG conference, and what a fantastic event it was. I know I’m considered a “long time presenter” but this was my very first DOAG conference (not counting the virtual one from last year) and I was blown away by the enthusiasm of the attendees and the organization of the Read more
-
INTERVAL partitions in multiple tablespaces
When the “STORE IN” clause is mentioned for partitioned tables, most people’s mind turn toward hash partitioning, because the usage of “STORE IN” within the documentation almost exclusively limited to hash partition examples. SQL> create table t1 2 ( x int, y int, z int ) 3 partition by hash ( x ) 4 partitions Read more
-
XMLTABLE and data “corruption”
One of the cool things with the native SQL handling of complex datatypes is the ability to take something like XML, and with just a simple column mapping definition, get the data you want back in familiar rows and columns form, which typically is a better fit for all sorts of tools, applications and ultimately Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 