Search

Top 60 Oracle Blogs

Recent comments

April 2020

Submitting to Oracle Code One 2020

While I’ve been out of the conference circuit the last few years, given the amount of work I’ve been doing brushing up on my PL/SQL knowledge, which will soon be featured in a series of blog posts, I figured I’d submit a session. Here it is: CON1381 – Demystifying PL/SQL: The Life of a Compilation […]

The post Submitting to Oracle Code One 2020 appeared first on Oracle Internals.

Expertise might not be the way forward

I caught up with friend Rob Lockhard who is doing interviews with community members. He asked me about the future of IT and what is in store for the the budding IT professional coming out of college/university.

Social Media can really boost a good product!

Isn’t it nice if you can make an impact with your tweets and posts? That’s what I thought today while investigating our online learning registrations.
As you may know, Exasol offers free online learning – recently also combined with free certification. We have also recently changed our course curriculum to better suit customer demands.

Together with very many IT people being in home office, that all leads to quite high numbers in registrations to our online learning platform called Exacademy: 617 in 2020 so far.

That’s many for a still quite small training & certification department like ours, and we couldn’t possibly educate that many customers with instructor-led courses.

Today, I looked at the Exacademy registrations per day:

Jobs at RDS

I’m personally interested in using explain plans to identify missing indexes opportunities.  Let me know directly if that is of interest to you. This could be in the roll of database engineer and design or development engineer on design and coding.

My manager has a bunch of openings in all sorts of areas from database performance monitoring, recommendations, proxy

raw timestamp

Many years ago I wrote a note with some comments about conveting the low_value and high_value columns of user_tab_columns to see what values they actually held. At the time the dbms_stats package held a few procedures to convert raw values and it was necessary to wrap these procedures in user-defined functions if you wanted a function to do the job.

In recent versions of Oracle (18c onwards) the package has finally acquired several functions to do a proper job, these are:

Expert Advice: How to Start Selling on Your Website

Are you just taking your first steps selling a product or service online and don’t know where to begin? Be sure to register for our next 60-minute, free webinar, where our expert Happiness Engineers will walk you through the basics of eCommerce and show you how to set up your online store.

Date: Thursday, April 16, 2020
Time: 5 p.m. UTC | 1 p.m. EDT | 12 p.m. CDT | 10 a.m. PDT
Cost: Free
Who’s invited: business owners, entrepreneurs, freelancers, service providers, store owners, and anyone else who wants to sell a product or service online.
Registration link

COVID-19: The Coming Peak in the UK & Beyond.

<<<<<
<<<< Why we had to go into lock-down
<< What we could do to help ease social distancing

The UK government is now talking more in it’s daily briefings about what will come “next”, that is after we have seen the number of diagnosed cases & deaths continue to grow, plateau, and then fall. It will plateau & fall, so long as we all keep staying at home and limiting our social interactions. If we do not, we risk the virus spreading out of control again.

Virtual Conference: Systematic Oracle SQL Optimization Interview Videos

Update: I have added an interview with Jonathan Lewis to YouTube too. We talk a bit about the last 10 years and Jonathan describes what he’ll be talking about in his virtual conference talk:
 I will add a few more videos in the coming days. The conference interview playlist URL is here.
You can sign up for the conference here. See you soon!
 

Virtual Conference: Systematic Oracle SQL Optimization Interview Videos

Update: I have added an interview with Jonathan Lewis to YouTube too. We talk a bit about the last 10 years and Jonathan describes what he’ll be talking about in his virtual conference talk:
 I will add a few more videos in the coming days. The conference interview playlist URL is here.
You can sign up for the conference here. See you soon!
 

Import Your WordPress Site to WordPress.com — Including Themes and Plugins

It’s been possible to export your posts, images, and other content to an export file, and then transfer this content into another WordPress site since the early days of WordPress.