I normally don’t recommend tools on this blog. But over last month I have been working with couple of tools that are worth a mention.
The first tool on the list is SQL Prompt by Red-Gate. I have been a fan of red gate bloggers for a while now at http://www.simple-talk.com/. SQL Prompt is without a doubt one of the most useful ad-ins for SQL Management Studio and Query Analyzer. This little tool is Intellisense for SQL Server. This tool dynamically looks up common functions and syntax as you type. It’s a free download until September 2006.
Check out: SQL Prompt
The second tool was recommended to me by Chris Webb. It’s a replacement for SQL Manager for stoping and starting all of SQL Server 2000/2005 services created by Jasper Smith at SQLDBA.com
Check out: SQL Manager
The last tool on my list is a new migration script by Marco Russo. If you were like me and followed the DTS best practices guide that MS put out and used UDL data sources. You will find that are unable to migrate your DTS packages. Marco has put together a great tool for converting UDL and other DTS objects that do not migrate.
Check out: A tool to improve DTS to SSIS migration