Understanding SQL

From time to time someone publishes a query on the OTN database forum and asks how to make it go faster, and you look at it and think it’s a nice example to explain a couple of principles because it’s short, easy to understand, obvious what sort of things might be wrong, and easy to fix. Then, after you’ve made a couple of suggestions and explained a couple of ideas the provider simply fades into (more...)

Kan iemand mij uitleggen waar IT heen gaat?

“Als je het niet kan zeggen, zing het dan maar”. Dat was vroeger een veel gebruikte kreet als je niet onder woorden kon brengen of kon benoemen wat je wilde zeggen. Hier moet ik vaak aan terugdenken als ik de fantastische kretologieën voorbij zie komen die nieuwe trends of hypes in onze mooie IT wereld beschrijven. Soms iets van oude wijn en nieuwe zakken of door alleen het oogstjaar te veranderen, maar vaak zijn de (more...)

Guaranteed Method of Boosting your Oracle Skills

I can tell you how to be a better Oracle DBA, Developer, Designer, Architect – whatever your flavour of role or aspect of profession, if Oracle tech is part of your working world I can hand you the key to improvement. And it is easy.

I am totally assured(*) I can do this. It will work for every single one of you reading this post (except for you two, you know who you are). And (more...)

AeroGear Germany tour 2015

Over the last three days Sébastien Blanc and I have been touring through Germany to visit a few JUGs.

The talks

We had the same setup for every evening: First, Sebi was talking about JBoss Tools and Forge and showed how to quickly create a Java EE based backend. Afterwards the audience saw the how to create a good looking Apache Cordova mobile app, that he also generated using Forge! At the end the solution (more...)

Dom Brooks über Plan-Stabilität

Dom Brooks zählt zu den Blog-Autoren, die sich am intensivsten mit Fragen der Stabilität von SQL-Ausführungsplänen beschäftigt haben. In Strategies for Minimising SQL Execution Plan Instability liefert er einen recht umfassenden historischen Überblick zur Entwicklung des Optimizers und jener Ergänzungen, die eingeführt wurden, um seine Informationsgrundlagen und Entscheidungsmöglichkeiten zu erweitern. Dabei gilt natürlich, dass die größere Flexibilität und die Einführung adaptiver Strategien dazu führen, dass die Stabilität der Optimizer-Entscheidungen geringer wird. Die grundlegende Frage dabei (more...)

UKOUG Systems Event 2015

ukougI have a bone to pick with UKOUG. I’m coming from Birmingham and I’m a lazy git, so why the heck am I on in the first slot? :) It was a 04:30 start to the day, for a train journey starting at 05:50. I could have got a later train, but it would have been busier and more importantly, more expensive… After putting the latest of my writing tips posts live and lying in the (more...)

Bash Arrays & Oracle

Last week, I wrote about how to use bash arrays and the MySQL database to create unit and integration test scripts. While the MySQL example was nice for some users, there were some others who wanted me to show how to write bash shell scripts for Oracle unit and integration testing. That’s what this blog post does.

If you don’t know much about bash shell, you should start with the prior post to learn about (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XIV


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we discussed the new Enterprise Manager Database Express 12c, which is the replacement for the earlier Database Control (used in previous versions of the Oracle database such as 11g and 10g, to manage a single database).
One of the menu options in Database Express 12c is the Database Performance Hub. This gives (more...)

Writing Tips : Should I write off-topic posts?

writingI’m a Jedi master at writing off-topic posts! This blog started life as an Oracle blog, but now I just write reviews of Twilight and 50 Shades of Grey. :)

The simple answer is you should do what you are happy with. I had been writing on my website for 5+ years before I started this blog. When I started the blog, I thought it would be technical. It quickly became apparent that the Oracle content was better (more...)

Managing Oracle Database 12c with Enterprise Manager – Part XIII – Database Express 12c


We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog post on this topic, we briefly looked at the changes for Metering and Chargeback. We will now look at the new Database Express 12c.
Oracle Database 12c introduces “Enterprise Manager Database Express 12c” instead of Enterprise Manager Database Control that was available with previous versions of the database, such as 11g and 10g. The important (more...)

What is the APEX Open Mic Night at Kscope15?

At the upcoming ODTUG Kscope15 conference, on Monday night, June 22, there will be the Monday Community Events.  The Community Event for the Oracle Application Express track at Kscope15 is the ever-popular Open Mic Night.  Without a doubt, this is one of my favorite events at the Kscope conference.

An Oracle employee sent me an email today, inquiring about the Open Mic Night.  This employee, who is a user of Oracle Application Express at Oracle, (more...)

Installing PeopleTools 8.54

In this step-by-step tutorial, I will show to get the latest PeopleTools up and running on your laptop within minutes so that you can fully utilise your local PeopleSoft installation.

Part1 Configuration Evodesk

Installation was not bad.

Evodesk is the 2nd company I am aware of for using recesss nuts for desktop installation.

This makes much more sense than using wood screws.

However, pondering if Evodeskk will be the first company to used recess nuts for all components and get rid of wood screws.

Don’t you think the legs make  great towel rack?

install1

install2


Free MIT Computer Science Classes Online

This is very cool:

There are a bunch of nice computer science classes online from mit: Free online MIT computer science classes

Here is an introductory computer science class: Intro to computer science

Here is a graded version of the same class on edX: Graded version of MIT intro CS class starting June 10th.

edX does not have as many computer science classes but edX may motivate students because edX classes include grades and certificates for those who (more...)

The Database Protection Series Concludes- Final Thoughts and Wrap-up

Let’s conclude this series of articles on database security by reviewing what we learned in previous installments. Along the way, I’ll provide some additional hints and tips to tie everything together.

Introduction
We learned that database administrators, since the inception of their job descriptions, have been responsible for the protection of their organization’s most sensitive database assets. This envious responsibility will not change. As DBAs, we will be forever tasked with ensuring that our critical (more...)

My Toddler Knows More About Computers Than I Do. Help?

This is a feature post written by Tonya Rae Moore (@tonyaraemoore, website). Long years working for Oracle as the caretaker for Java.net, she went over to help with kick-starting ZEEF marketing. Working with communities and individuals has always been her passion. Strong believer in equality in tech and fighting anything which doesn't respect minorities. Marketer at heart, knows everything about beer, and is a loving mother married to a sport talk-show host. Member of the (more...)

That Depends

In every universe there are questions that either:

Have no answer
or
Have an answer that is situation-dependent

and that includes the Oracle universe. Sometimes it’s difficult to get that concept across to the less knowledgeable. Let’s go back to a simple example from a previous post to illustrate this.

In Resurrecting The Dead flashback operations were discussed as an option to restore table data to before an errant update. The post started with this:

 (more...)

The Long Goodbye

I'm in the process of saying a long goodbye to my iPad 2...and tablets in general, at least for now.  I'm losing my tablet for a couple of reasons.

First, I've pushed the limits of my iPad's usability.  I really have...for a couple of years.  But I just don't find myself using it for any kind of serious work.  My MacBook Air has really taken over for both premise-based and cloud-based work.  Even (more...)

Flipkart and Focus 3 – There’s Something (Profitable) About Your Privacy

The third in my series on Flipkart and focus appeared in DNA on April 18th, 2015.



Part III – There’s Something (Profitable) About Your Privacy
Why do so many companies hanker after apps? Smartphone apps, tablet apps, iOS apps, Android apps, app-this, app-that….
Leave aside for a moment the techno-pubescent excitement that accompanies the launch of every new technology (if you are not old enough to remember words like “client-server[1]”, then “soa[2] (more...)

Delphix announces masking acquisition

I’m excited to announce the first acquisition by Delphix (portending many to come). Dephix has just acquired the data masking company  Axis Technology Software. Delphix is integrating the Axis masking technology into the core Delphix product. Masking is a feature that 9 out of 10 customers have asked for after buying Delphix. Delphix eliminates the data cloning bottleneck  for application development environments and naturally the next concern that arises is how to mask the data from production (more...)