A simple tip on how to retrieve a history of all Patch Set Update applied to a database via SQL.
Around 14 years ago, I switched from using Reflection to PuTTY because it was free and my employer at the time wouldn’t pay for such extravagance software purchases such as a simple terminal emulator! Since then I’ve become rather accustomed to the way PuTTY behaves, and find Reflections particularly annoying to use on the occasion that I visit a client who insists on using it. However, it is possible to solve most of the biggest annoyances…
I have been running Windows 10 for a while now and every other day or so, I get the Security and Maintenance notification show regarding "disable apps to help improve performance". After a bit of hunting around, I have finally discovered how to disable this notification from appearing any more.
Recently, all my files stored in Dropbox suddenly acquired a "dot underscore" file in addition to the original file, which was then synced to all other computers that were linked to my Dropbox account. This post describes what these files are, and how I resolved the issue.
I'm a longtime Windows user who recently purchased a Mac. Overall I'm very impressed with the machine, but it does have a learning curve, especially for the key bindings. As a DBA and programmer, I use the Home, End, PageUp, PageDown and CTRL keys extensively to quickly navigate code and text documents. And don't get me started... Continue Reading →
This article explains how to convert a list of values/readings into a graph to show month by month comparisons over several years as shown above.
Two short and simple methods to create a URL which will direct someone straight to the recommendations section on your LinkedIn profile. This is useful for highlighting your existing recommendations and at the same time prompting the recipient to leave you a recommendation.
This is a subject that I am often asked about by developers and support teams changing application configuration details: What is the correct format of JDBC connection strings for the thin driver? Oracle's JDBC Thin driver uses Java sockets to connect directly to Oracle. It provides its own TCP/IP version of Oracle's SQL*Net protocol. Because it... Continue Reading →
As a DBA, it is generally a good idea to log all your activity when working on Unix/Linux servers. Logging provides an audit of changes that you have made to a system as well as being a valuable resource for notes and documentation. This article describes how to log all PuTTY sessions and how to automtically maintain the resulting logfiles in a logical directory structure.