With the New Year 2012 not far off, let me take a moment to tell you some of the tools that I have used for almost ages without even thinking twice. These get installed almost every time I do a refresh / rebuild on my Laptop. Couldn’t resist and hence thought of sharing. (Order of the tools are just random)
1. Sysinternals – ZoomIt and Process Explorer
I have been using the SysInternal tools for such a long time. As a presenter, the ZoomIT tool is a must have for any session. It gets used almost in every session I am involved. The second tool that I use with passion is the Process Explorer. When used correctly, there is so much learning that you can get from this tool. I have also used Process Explorer sometimes to understand how SQL Server works – that powerful this tool is.
2. TreeSize – Free Version
Finding the space utilization of your HDD is something I grapple with almost when my HDD runs out of space. HDD space is so cheap and we have so much to learn.
I still remember the days when I had to use floppy disks to boot and work on BASIC, FORTAN etc. Those were the days :). Now even with 500GB HDD I seem to be looking out for where to get that extra ounce of space free – what an irony !!!
How many of you use a Paging file in your machines? Ever since I got 6+GB of RAM I stopped using them.
There is a Professional version of the Tool giving you great color formatting and other extra features, but if you are a home power user, the Free version just fits the bill in my opinion.
3. WordWeb – Free Version
This was a wonderful utility that one of my friend pointed long time back. Ever since I started getting into a typing routine, this tool has come handy. With a flip of CTRL + ALT+ W, I have a dictionary for quick reference. Loved the shortcut when highlighting and selecting the shortcut I get to the meaning directly. Atleast, this is one step easier when compared to Copy and Paste this over a website for the meaning. The Free version here again has worked wonders for me.
4. SpaceMonger v1.4.0
I don’t know how many space visualizing tools I will use, but apart from TreeSize I also use this nifty tool. Check the free software of v1.4.0 and it is quite handy. This is similar to the SQL Internals Viewer available on CodePlex now for your HDD space.
5. Slickrun
This is another tool which once my good old friend Sanjay Shetty from INETA introduced to me. This tool reminded me of the old days TSR programs that I wrote in my college days :). The sleek blue mini-bar can be placed at any location over the screen and it so prominent. I have used this to watch my timing when doing sessions. The super cool part of this tool is the concept of MagicWords which can be used as shortcut to commonly used programs. Powerful and interesting tool.
Conclusion
This is not an exhaustive list of tools I use, but this was a start that I thought was worth sharing. Also, tell me if you have used these tools or you have better tools to suggest that you use almost daily at work.
Do pass me your comments to if you want to see something similar list for working with SQL Server? Your comments are most welcome !!!

More and more I get an opportunity to talk with the Enterprise CxO’s, I get to hear more of these terms coming up. Yes, the investments are already out there within the enterprises and these cannot go anywhere. So the need to use the existing storages and extend the future needs of storage to the cloud can be a viable option that exec’s always want to contemplate and discuss. The whole concept of limitless (based on costing) storage that hardly requires upgrades, replacements and with no additional capital investment means quite a lot to these CxO’s – especially the CFO’s love to see the ROI here.
This is a very simple tip to all programmers who are into this IT world. More and more I get to interact with developers and DBA’s I see this striking behavior that people memorize the syntax and the API’s more than understanding HOW these API’s really work. And there are so many of them who do neither but use their favorite search engine to give them almost any code block. Use intellisense with Visual Studio to help you rather than memorizing the API’s and methods available.
There is no exception to this rule. In fact, we need to be careful and sensitive to their feelings before jumping into a comment. Their real life situations and emotions (passion) with which they are expressing their experiences – these are REAL. We should have an unqualified, unconditional respect to their views – PERIOD.
What do you look out for in conferences? I have been on both the receiving end and the giving side for years now and there is one thing that comes out clear for me personally – the Networking effect. I thought let me take this opportunity to talk out what are my perspectives to events and what we need to be aware when attending conferences in the future especially from Networking perspective. As an attendee the conferences are filled with boring moments and monotonous small talks back-to-back. Only the speaker has the luxury to make it exciting or put you to sleep – now trust me, try to put your kid to sleep and it is such a tough job. Last thing as a speaker you don’t want to work hard to put 100+ people to sleep in one sitting :).





