Video : Ranking using RANK, DENSE_RANK and ROW_NUMBER : Problem Solving using Analytic Functions

Today’s video is a run through ranking data using the RANK, DENSE_RANK and ROW_NUMBER analytic functions.

There is more information about these and other analytic functions in the following articles.

The star of today’s video is Chris Saxon, who is one of the folks keeping the masses up to speed at AskTom.

Cheers

Tim…

Technology : You have to keep working just to stand still!

This is a topic of conversation that has come up a lot recently, both at work and whilst updating the computers for family members, so I thought I would write something down.

I don’t think people realise how much work it takes to stand still in the technology world.

When we think about the pieces that make up your typical on-prem web application running on virtual machines, what does standing still mean? To me it means the following.

  • Database : A regular patching cycle for the database and the operating system it sits on. Also, upgrades/rebuilds as required.
  • Application Server : See database.
  • Web Layer : See database.
  • Load Balancer : Regular patching of the appliance, and replacements/upgrades as required.

Now multiply all that up for all the projects you are working on. That represents a substantial amount of work, whether you call is Business As Usual (BAU) or Internal Projects. What’s worse, there is no “visible benefit” from this work. Most users won’t have a clue it is happening, as they won’t get a new screen or a new widget to play with. It’s pretty much invisible, but it has to happen, just to remain static.

At this point I can hear people saying, “But standing still is literally doing nothing, so what are you talking about?” Well, if today I have a fully patched system using supported versions of all software, to stand still I have to remain on a fully patched system using supported versions of all software. If that means upgrades or rebuilds of kit, so be it.

Remember, if I do nothing at all, I’m no longer standing still, I’m moving backwards!

Think about that for a second. To stand still I’ve got to learn all the new stuff so I can upgrade to 19c and get long term support for my databases, even if I didn’t want to. Same goes for other products. Even if I use none of the new features. There is a big investment needed by a company, and for you personally, just to stand still. Now breaking new ground, well that’s a whole different ball game… ๐Ÿ™‚

So what are the solutions:

  • It helps if you recognise the problem in the first place. Far too many people think doing nothing is standing still, when it’s not.
  • Automation will help you stay on top of things. Reliable and repeatable processes make keeping things up to date a lot simpler. Automated testing is the icing on the cake here.
  • Cloud? Platform as a Service (PaaS), when it is done right, can help you keep on top of things. Having a service where you don’t have to worry about OS, DB and app server patches, because it’s all handled by the platform is a big bonus.

Cheers

Tim…

Some related posts:

Dbvisit Standby 9 Installation on Linux (and Vagrant)

The folks at Dbvisit recently released version 9 of their Dbvisit standby product.

It’s been a while since I last played with the product, so I downloaded the free trial and gave it a whirl.

I have to admit I forgot just how easy it is to work with. It feels pretty much like “unzip and go”. The result of my playtime was this article.

I also knocked up a Vagrant build, so I can easily recreate it. You can find that here.

I stuck to a basic configuration of a single instance primary (node1) and standby (node2), with the console on a separate VM (console). If you want to try something more exotic, or you are using Windows, you can get more information from the Installing Dbvisit Standby documentation.

Cheers

Tim…

PS. This isn’t a sponsored post. I’ve known the folks at Dbvisit for years so I keep an eye on what they are doing.

Video : Multitenant : PDB Snapshot Carousel in Oracle Database 18c Onward

In today’s video we take a look at the PDB Snapshot Carousel feature, introduced in Oracle 18c.

I also have a Multitenant YouTube playlist.

Thereโ€™s a lot more information about this feature and other multitenant functionality in these articles.

The star of today’s video is Nassyam Basha. ๐Ÿ™‚

Cheers

Tim…

Video : Multitenant : Proxy PDB in Oracle Database 12.2 Onward

In today’s video we demonstrate the Proxy PDB feature, introduced in Oracle database 12.2.

I also have a Multitenant YouTube playlist.

There’s a lot more information about this feature and other multitenant functionality in these articles.

The star of this video is Anton Els of Dbvisit fame. I recorded this video last week and picked Anton for the “.com”, then they go and release Dbvisit Standby 9. Coincidence or conspiracy? ๐Ÿ™‚

Cheers

Tim…

PS. Mike, I’ve downloaded version 9 and I’m going to give it a run through… ๐Ÿ™‚