February 2016

On building SQL

I had a fun question on AskTom over the weekend, that of, how to display a monthly calendar for any provided date using just SQL.

You can see the question and the answer here

But I thought it might be worth explaining the process.  Of course, the way I approach the problem might be totally different to the way others would, and that’s fine.  But for the novice, you might get something useful out of this.

So here is January 2016. 

image

The first thing I’m thinking to print a calendar is

C# Web-Based Forms with Oracle Database Access

February 20, 2016 I have been experimenting a bit with ASP.Net, having used classic ASP (with VBScript) for generating various web-based reports somewhat extensively more than a decade ago.  While before I used little more than Microsoft’s Notepad application and occasionally Microsoft FrontPage for HTML syntax verification, the development environment that I have been using […]

The Ten Rules of Database Administration

I’m a Leaf on the Wind, Watch How I Soar.

This is one of my favorite lines from the movie Serenity.

Oracle Linux 7 disks and udev

I was setting up disk devices for ASM in Oracle Linux 7. I knew things have changed between Oracle Linux 6 and Oracle Linux 7, but only just a little bit.

First of all, let’s take a look at the current disk usage. To see what disk devices are visible and how they are used, use lsblk:

Friday Philosophy – Being the Best Manager

I’d like you to spend a minute thinking back on your career and decide who your best manager has been.

Surely your best manager ever deserves a good cup of tea

Surely your best manager ever deserves a good cup of tea

I don’t mean the manager who you personally got on best with or was most popular with the team – though being one (or even both!) of those does not rule them out as being the best manager you had.

It does not have to be in IT – or even work, actually, cast the net wide to include people who have managed teams and groups outside of work that you have been in.

Problem Solving (Breaking Things Down)

direction-1033278_640Some people are great at problem solving, others not so much. The people I meet that are good at problem solving always have one very important skill, the ability to break stuff down into its constituent parts. With practice, it can seem like they are making massive leaps of faith, but that is based on their experience. That experience came from breaking problems down and dealing with the little stuff. Here are some examples, including some you may not consider as classic problem solving, but illustrate the point.

Displaying CPU Graphs For Different Time Ranges in Enterprise Manager

This question was posted in Twitter from @matvarsh30, who asked, “How can I display CPU usage over different periods of time for databases in Enterprise Manager?”

A Book of Friday Philosophies?

It has been suggested to me by a friend (not a publisher!) that I should do a book of my “Friday Philosophy” posts. I’m not sure. I’d like to know what people think.

If you read my blog but “Friday Philosophy” has somehow passed you by (how could they, most of my posts now are Friday Philosophies!) they are usually posted at the end of the week and deal with the non-technical side of working in IT. They are my thoughts and experiences on management, development paradigms, things that seem to still be wrong after 2 generations of programmers have painfully learnt the same lessons. Some have nothing to do with IT. The occasional one is about my life. Nearly all have an element of humour in them (even if it is only when I am laughing at myself and my own stupidity).

I’ve never really meant them to be more than a bit of light relief for people to read at the end of the week, but also to make people think.

DEFAULT SEQ.NEXTVAL in 12c

One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as the default value for a column.

Of course, some may say “big deal” – after all, it is trivial to create a simple trigger to do the job.  And perhaps, we “crafty” folks at Oracle are just doing a hidden trigger in the background anyway Smile

Well… we’re not.  We’ve put some work into this to make it sing.  Let’s look at a demo.  First, here’ s the trigger-based approached.

Sharknado 3: Oh Hell No!

sharnado3Sharknado took the bad B-Movie concept to it’s ultimate conclusion, making it an instant classic. A tornado sucks up a bunch of sharks to create a sharknado that passes over Los Angeles.

Sharknado 2: The Second One was a parody of Sharknado, with everything bigger, crazier and better. Not one, but two sharknados, threatening to merge to forms a super-sharknado over New York!