Home About Me Contact Me RSS ATOM

MVP Image

- Posts By Category

- Posts By Date

- Search The site


Subscribe by Email

- Sites I visit


Locations of visitors to this page

- Recent Blogs

Free SQL Server tools available from Microsoft
Microsoft provided free SQL Server 2000 tools.
Posted on 5/27/2007 7:30:11 AM in #SQL SERVER

Hi

There are many things that we want to do in SQL server which do not ship with the product but are still freely available. There are many free tools available for SQL server that are less known to the developers because they do not ship with the product. But these tools can be more than handy for many situations. And very importantly these tools are freely available from Microsoft.

Here is a list of tools available from Microsoft freely for SQL server 2000. [Note: These list is not exclusive. There are more tools available from Microsoft. Please check Microsoft’s Site for the same.]

Read80Trace - It is a command line utility for processing trace files generated by SQL Server 2000.

SQLIO - It is a tool provided by Microsoft, which can also be used to determine the I//O capacity of a given configuration.

SQLH2 Performance Collector - The SQLH2 Performance Collector is a stand-alone service of Microsoft Windows that collects and stores performance counter data from selected servers.

SQL Server 2000 Best Practices Analyzer - Microsoft SQL Server Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices.

SQL 2000 Check - SQL Check scans the computer on which it is running for instances of SQL Server 2000 and MSDE 2000 that are vulnerable to the Slammer worm.

SQL 2000 Management Pack - The Microsoft SQL Server 2000 Management Pack provides both proactive and reactive monitoring of SQL Server 2000 in an enterprise environment.

Thanks
Vikram

Feedback

Arthur
Posted on 11/30/2010 1:40:55 AM

I would like to add that SQL Everywhere by Atlantis Interactive (even though a Microsoft tool) - even its free edition is very helpful for both database developers and administrators. I liked the most the object search feature and the intellisense, code snippets support. The tool is very customizable, too!
Link to it: http:////www.atlantis-interactive.co.uk//products//sqleverywhere//featureshowcase.aspx

Please post your comments:

Name:  
Email (optional): Your email address will not be posted.
URL (optional):
Comments: HTML will be ignored, URLs will be converted to hyperlinks  
Enter the text you see in the box:
 

Copyright © 2006 - 2012 Vikram Lakhotia