winzip icon

SQLAnalyzer.Net

Email
Submitted on: 1/3/2015 3:10:00 AM
By: Chong Long Choo (from psc cd)  
Level: Advanced
User Rating: By 8 Users
Compatibility: VB.NET
Views: 1521
 
     

As SQL Server administrators, we all know how important it is to document our server configurations. Producing and maintaining complete SQL Server documentation is an important job of every SQL Server administrator. Here are just a few of key benefits of producing such documentation:



- Tracking and documenting SQL object changes during the testing process, or to document changes made after an SQL Server has been put into production.

- Learning about a new SQL Server that you now have been assigned to maintain.

- Providing system documentation for disaster recovery.

Every administrator knows how important good documentation is, but how many of them actually do a good job at it? If I had to guess, I would say the percentage is fairly low. So why would a administrator, who knows how important good documentation is, not create and maintain it? Itís boring. Nobody likes to create, and especially maintain, documentation. Besides that, most administrators I know are so busy that they just donít have the time to provide and maintain good documentation, even if it wasnít so boring.

Given the importance of good documentation, but the lack of desire or time to do it, what can be done? Thatís the question we always ask ourselves. And the answer I came up with is SQLAnalyzer.

Essentially, SQLAnalyzer is SQL Server documentation tool that can automatically document every object in a SQL Server (such as tables, views, stored procedures, etc......), along with documenting all SQL Server server configuration settings.

In conclusion, the overall advantage is that you donít have to do the documentation yourself. SQLAnalyzer will do all of the work for you. Now, there is no excuse not to document the SQL Server that you are responsible for maintaining.

Essentially, SQLAnalyzer is SQL Server documentation tool that can automatically document every object in a SQL Server (such as tables, views, stored procedures, etc......), along with documenting all SQL Server server configuration settings.

In conclusion, the overall advantage is that you donít have to do the documentation yourself. SQLAnalyzer will do all of the work for you. Now, there is no excuse not to document the SQL Server that you are responsible for maintaining.

Features:

  • Generate configurations report in HTML format for all SQL Server objects.
  • Generate system information that you probably need when recover your SQL Server.
  • Compress generated files into a ZIP file.


  •  
    winzip iconDownload code

    Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
    1. Re-scan downloaded files using your personal virus checker before using it.
    2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

    If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com


    Report Bad Submission
    Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
    This submission should be removed because:

    Your Vote

    What do you think of this code (in the Advanced category)?
    (The code with your highest vote will win this month's coding contest!)
    Excellent  Good  Average  Below Average  Poor (See voting log ...)
     

    Other User Comments


     There are no comments on this submission.
     

    Add Your Feedback
    Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
     

    To post feedback, first please login.