Archive for February 2009
You are browsing the archives of 2009 February.
Hiding WordPress categories
When I wrote my first WordPress related post, I admitted that I was only doing it to attract traffic and it would be my last post on the subject. However, I start again. This time around, however, I want to talk about something which isn’t common knowledge and neither did I get any responses on [...]
Remembering your passwords
In today’s online world we have to remember a lot of passwords. Security advice is that they must all be different (so that if one account is compromised, we don’t loose the security of all accounts), and be changed every now and then. It is sometimes difficult to cope with such requirements, without writing down [...]
Generating sequential numbers in a database
You are creating an application that allows organisations to manage employees. One of the tasks that it has to do is generate an employee ID when a new employee is being entered. One way of doing this is through this query: SELECT max(empl_id)+1 FROM employee; However, this query presents a problem in a multiuser environment: [...]
Performance tuning SQL queries in Oracle
Video tutorial showing how to optimise your SQL queries for maximum performance. Talks about indexes, statistics, hints and optimiser plans.
Potted flowers – II
Some more of my potted flower shots, hope you like them. Please leave your comments behind: The first photo, Natural Grace is licensed under a Creative Commons Attribution 2.5 India License. The other photos (eg. ‘Smile Please’), are under the more restrictive license used by the rest of this blog.
