Archive for August, 2005

EMS MS SQL Manager

Thursday, August 18th, 2005

MS SQL Enterprise Manager is a powerful tool. But if you are looking for some administration tool for MS SQL / MSDE go for EMS MS SQL Manager.


It comes in two versions Professional & Lite (Compare). It’s a powerful database management tool with:


  • Easy Management of db objects
  • Advanced Data Manipulation Tools
  • Powerful Security Management
  • Visual / Text tools for Query building
  • Data import / exports
  • Administrative Tasks
  • & tons of other features


EMS MSSQL Manager Lite for Windows is free. You can download a copy from their website.

Flow diagrams of Code (T-SQL)

Wednesday, August 10th, 2005

At my work I had a long SQL stored procedure code (coded by someone else) which was difficult to understand at first. I was Looking for some tool which could do the job of creating flow diagram of the code. But didn’t find any.

Few days later a friend sent me an email with a link to a tool which can create flow diagrams of almost any code (T-SQL, Java, VB, .NET etc). I’ve tried its demo version which created a flow diagram of my code in 5 sec. Wow.. That was gr8 if I compare it with the 2 days efforts I took to manually create the flow diagram in Visio. Though after comparison I like my Visio :). But still it’s a handy tool for a quick look at the code.

Check it out these tools.

Visustin v3 Flow chart generator (I’ve tried this one)

Data Flow Diagram (with Case Studio 2)

Later on while searching I found another interesting tool. I haven’t tried it yet, but it looks like you can code (or edit code) just by making diagrams.

Code Visual to Flow Chart v3.3


Windows – SAM (Software Assessment Management)

Monday, August 8th, 2005

SAM (Software Assessment Management) from Microsoft allows you to do:

  • Software Inventory
  • Matching Software with Licenses
  • Review Policies & Procedures
  • Developing a SAM Plan

SAM Procedure walk you through the process of SAM. A list of downloadable documents and templates are available to help you with the implementation of SAM.

Microsoft Assessment and Planning Toolkit (MAP) a free tool from Microsoft allows you to make an inventory of installed Microsoft products on local system or on network.

Contact Softvative for Software Asset Management solution for your organization.

Windows! AD Group Policy Site

Monday, August 8th, 2005

This links is on Active Directory (AD) Group Policy. It elaborates some good features of AD. Check it out at:

Also check the site for other information. It’s a nice site with good information.

SMTP log Analyzer

Monday, August 1st, 2005

Sawmill offers a log analyzer which can parse a range of log file formats. It can be a good tool to analyze SMTP logs.