Tools of the trade

Nigel Vining
December 1, 2013
Nigel Vining

A few months back i was asked to visit a client’s site to improve the performance of an application.
This usually wouldn’t be an issue, but ….. I was hesitant to say yes. why?
Because I knew getting the appropriate access and tools would take longer than the actual job. I get paid for time on site so if the client wants to slow me down, that’s their prerogative. What I do mind though, is wasting time – the clients, and my own.
This made me start thinking about the minimum ‘toolkit’ I need to do my job effectively – and I came up with the following list:

  1. Administrative access to a PC – if I can’t install the software I need (listed below) i’m going to have to improvise and find workarounds which can take ALOT of time. I have worked on sites where every time I needed to execute a client application I would need to ring a support desk so they could remote login and use the administrative password to allow the software to run!
  2. A good text editor like NotePad++ which highlights syntax and provides a great place to view logfiles, sql, javascript and html. If you don’t believe me, try reading a log file in NotePad :0
  3. SQL Developer or Toad with enough permissions to be able to run explain plans. Tuning performance without appropriate access to the database and explain plans is a bit hit and miss!
  4. Firefox (with Firebug installed) – allows me to quickly and easily ‘see’ and ‘debug’ what the particular application is doing. It also goes without saying, internet access …. having to cover multiple platforms, technologies, and scripting languages (which is what I enjoy most about Business Intelligence!) would involve carrying around a HUGE stack of manuals. These days the internet provides us access to the current online versions, and the user communities that support them.
  5. An LDAP browser. It’s the easiest way to check users, groups, permissions, server configuration and organisational hierarchy information when setting up connections and security.

Thinking about my list – what would your ‘toolkikt’ have in it ? and what cant you do without …
Till next time… Nigel

Copyright © 2019 OptimalBI LTD.