Archive for February 2009
You are browsing the archives of 2009 February.
You are browsing the archives of 2009 February.
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 [...]
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 [...]
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: [...]
Video tutorial showing how to optimise your SQL queries for maximum performance. Talks about indexes, statistics, hints and optimiser plans.
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.