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…
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.
So you've saved a lot of notes into Evernote and you're wondering how to back them up in case something goes horribly wrong. Some might call you paranoid, but a glitch in a client update could wipe out your notes (and because Evernote syncs to the cloud it would wipe out all your notes in the cloud too). So how can you backup your data?
If you use a lot of keyboard shortcuts then will have already discovered that, by default, the F-keys on the touch/type keyboards are mapped to "helpful" shortcuts such as volume up/down and search. Rejoice however, as there is a simple solution to make the keys act as proper F-keys again without the need to hold down the Fn key.
Here's a very search tip to help identify all the receipts and order details for products and services in your GMail account. Simply enter the following and hit search:
subject:(order OR booking OR receipt OR cancellation) -unsubscribe
You can take this one step further by creating a Filter / Rule which will automatically label the emails to give you a visible indication in your inbox. Read more in the full article.
After installing a new graphics card I discovered that that the Start screen in windows 8 was appearing on a different monitor to the one I originally had it on in my multi-monitor setup. After a little digging, I discovered that there are two very quick and easy ways to switch which monitor it appears... Continue Reading →