Posted by Darrell61 on 07/12/07 16:07

See: http://www.sqlexplorer.org/index.php

This is a nice little open source tool. You can run queries against
tables/views. You can see properties of the database/table/indexes, etc.
Downsides may include: requires .NET framework, Java runtime. You can create
connection thru ODBC objects, or you can download and install Microsoft JDBC
client driver software. Does not perform some advanced administration tasks you
may be looking for.

Might look at the Idera stuff too (commercial): http://www.idera.com


> Okay - I've been reading through a ton of blogs, and every other one
> seems to have some neat, new-to-me tool that I've missed that I could
> really use. Our production DBA recently left, and I'd rather find
> code to help me do his job, improve things, and maybe get some
> sleep.
>
> For instance, I hadn't seen these until recently:
> Performance Dashboard - SSMS reports with everything from CPU usage to
> top queries, etc.
> SQL DMVStats - code that builds and populates a repository of
> performance data using DMVs
> SQL Server Hosting Toolkit - potentially a way to better deploy code
> to QA & Production.
>
> What other projects have I missed? Our environment has Clusters,
> VLDBs, a QA environment, etc, etc ... and after finding these I'm sure
> that other, brighter, minds have come up with stuff to make my life
> easier.
>
> Thanks in advance.
>

[Back to original message]