LogParser – Converting IIS logs to local date and time and filtering by date range

This is a note to myself to remember how to convert the UTC date/time to the local timezone.

logparser “SELECT TO_TIMESTAMP(date, time) AS utc-timestamp, TO_LOCALTIME(utc-timestamp) AS local-timestamp,* FROM D:\Log\SearchServiceWrapperLogs\SearchServiceWrapperLogs\u_ex1202* WHERE local-timestamp between timestamp(‘2012/02/02 00:00:00′, ‘yyyy/MM/dd hh:mm:ss’) and timestamp(‘2012/02/03 00:00:00′, ‘yyyy/MM/dd hh:mm:ss’)” -recurse:-1 -o:csv >> fulllog.csv

LogParser – Converting IIS logs to local date and time and filtering by date range

Show Folder Tree in Windows 7 Explorer

I spend a lot of my time switching between folders in Windows explorer and the Windows 7 explorer has been driving me nuts lately.

Win7 (or at least the build I have) by default does not auto expand the tree view when you navigate between folders.

The result being you don’t see the usually tree hierarchy on the left pane. Which makes it quite painful if you want to go up a few levels or see the other parent folders.Windows7-Explorer

Luckily there is a new Folder Option called Navigation Pane to switch them back on again. You need to press Alt + T or Organize –> Folder Search Options in Windows Explorer to get to the dialog. Windows7-FolderOptions

Switch both of them on and viola I get my beloved tree view back.

Windows7-Explorer-Expanded 

PS- Most of my UW colleagues use other explorers and didn’t have to feel this pain.

Show Folder Tree in Windows 7 Explorer

Backup your data for free

I ran across this on ScottH’s post today. The Mozy.com gives you 2GB of backup storage for free.


Currently, I use the free SyncBack utility to backup the stuff to an extra hard-drive on the local machine. I’ve thought of using GMail Drive as a remote backup option but then I would have had to muck around with all the syncing. Plus it’s basically a hack with the 10MB and .zip/.exe blocking limitations of GMail.


Mozy on the other hand makes it all a breeze! The initial setup identified all my stuff like IE/Firefox favorites, contacts and email, My Documents, Visual Studio projects, the list goes on. I can also set when it should sync and how much bandwidth it should take etc. Cool!


Backup your data for free

Microsoft vs. BlueJ

I was first introduced to BlueJ when I started lecturing on OOP using Java at Keele (IIT) for their MSc program. Teaching first time programmers about objects and creating instances using the BlueJ IDE was a ‘wow’ moment.

A couple of years later I’m sitting at the regional MVP Summit in Singapore and watching a presentation by one of the Microsoft Program Managers (under NDA) about the new ‘Object Test Bench’ feature. The moment I saw it, I turned around to Prasanna and commented about its similarity to BlueJ. Other people too notice this and later even Microsoft admits that the idea was from BlueJ.

“*My* interpretation of the above statement is basically that our academic customers wanted this because of the success of this BlueJ feature.” (D Fernandez)

Fast forward to last weekend, Michael, one of the authors of BlueJ is alerted that Microsoft has patented BlueJ, Dan Fernandez (a Microsoft Product Manager) then works inside Microsoft to remove the patent. With a final update from Michael.

As a part-time educator who teaches both Java and .NET technologies what’s funnier is that Microsoft copied the feature based on feedback from teachers and hilariously doesn’t include it in the free versions of Visual Studio (Express Editions) which is chiefly intended for students and hobbyists.

Instead it is a high-end feature which is available only on the paid versions. I guess Architects can use that feature to teach new SE’s about objects and instances (grin).

Hopefully D Fernandez who is the Lead Product Manager for Visual Studio Express will “fix” it in the next version.

Microsoft vs. BlueJ

Counting my blessings

Happy New Year everybody!

Looking back, 2006 for me has been a very special year and one that I’m thanking God for blessing me so wonderfully.

I got married to the love of my life, nearly ten years after we fell madly in love with each other. I switched jobs to go back to my old company where I absolutely love coming to work in the mornings and I finally bought my very own house.

To top off everything, the Lord blessed us with our wonderful son Joshua!

Counting my blessings