Free Tools for the SQL Server DBA

  • David Bird

    SSCarpal Tunnel

    Points: 4669

    Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/dbird/2959.asp

    David Bird

  • Eko-197477

    SSC Enthusiast

    Points: 114

    Hi ... my name Eko from Indonesia

    Thanx U for your free tools list

    Regards,

    Eko

  • rdobrich

    SSC Veteran

    Points: 240

    Hi,

    I just wont to put one free tool. I just can't live without it.

    http://sqldigger.bdsweb.be/

    This tool search within sql server objects.

    Radovan

  • russella0-96423

    SSC-Addicted

    Points: 448

    Really usefull ! SQLInForm will be especially usefull for me.

    Another free tool I find extremely usefull for scripting table data is SQLScripter :

    http://www.sqlscripter.com/

    Can really save some time and has a great interface - requires the .NET runtime.

  • sham-424431

    SSC Enthusiast

    Points: 132

    two additions (to a useful list):

    1. SQuirreL - a true multi platform SQL Client. Supports SQL Server, Oracle, Access, MySQL, Firebird, PostgreSQL, Sybase,Informix, Excel, text files, and more....from ONE interface. It's not the ideal tool, but it is good, easy to use, great (free) support and if you're working with different databases, there is nothing else around that I know of...

    http://squirrel-sql.sourceforge.net

    2. Forget Yahoo - though an improvement over MSN, it's a million miles away from GMail (which includes integrated chat window)

    http://mail.google.com

  • SuperDBA-207096

    SSCrazy Eights

    Points: 8176

    I think it's pretty good, but a couple of other additions that are useful:

    The microsoft health and history monitoring tool.... it's pretty slick and is very helpful when it comes to monitoring your servers health.

     

  • Carlo-403060

    SSC Enthusiast

    Points: 155

    The tools that I have tried out from here are awsome - Especially the link with the 46 best free -> Quite nice for someone who ventures out of just the DBA tasks.

    One thing though : I can't access the fullsun link http://www.fullsun.net/

    Is there an alternative link??

  • David J. LaFlamme

    SSC Enthusiast

    Points: 108

    Working tools, GOOD

    FREE working tools, better!!

    Thanks!

  • Steve Brokaw

    Old Hand

    Points: 396

    Excellent article, thanks David for taking the time to create it!  I've only used one or two of these, looking forward to trying the others.


    Steve Brokaw

  • Rudy Panigas

    SSChampion

    Points: 10695

    Here are some more free tools that I use a DBA. You can google the names to get the to the web sites.

    DTSBackup2000 - Backup and restore DTS packages. Easy and fast

    SQL Recon - Scan the network for SQL servers. Great to see if you have new SQL servers that you didn't know about

    Scuba - Free db assessment tool from Imperva

    Visustin - Creates flow chart from sql scripts and many other languages likc VB, .NET. C#, Java, etc

    SQL Digger - Allows to to search for anything within DBs

    DumpSQLSec - Audits / reports on users roles, permissions, etc

    Hope you enjoy them!

    Thanks.

    Rudy

  • cowboy_k

    SSC Veteran

    Points: 200

    I'm not sure how it compares to ExamDiff, but I like KDiff3 - http://kdiff3.sourceforge.net/

  • Carl Federl

    One Orange Chip

    Points: 25384

    Be carefull when using the sysinternals handle executable as part of a SQL Server Job. For more details see:

    http://forum.sysinternals.com/forum_posts.asp?TID=9912&KW=sql+server&PID=43231#43231

    Formum post but noone has replied:

    SQL Server 2000 has an Agent service that can run jobs that can perform file manipulation and a frequent problem is that the file is open by another process. An example is a job to perform database backups which also deletes prior backups that are older than a specified criteria. I have set up a SQL Server jobs that runs handle.exe when the database backup job step fails.

    Handle version 3.02 works fine but handle v3.20 cause the SQL Server job to hang, that is, the SQL Server Job status is executing and it never finishes. This hang does not occur when handle is run as a windows scheduled task.

    SQL = Scarcely Qualifies as a Language

  • Vishal Verma-436010

    SSC Enthusiast

    Points: 124

    Is there a freeware utility that will scan the network for SQL servers to see if there are any SQL servers not properly licensed?

    Thanks

    Vishal

  • Timothy J. Bruce

    SSChasing Mays

    Points: 648

    One tool I've found absolutely critical is the ability to format and write SQL - in other words - an editor.

    The one I use is Context.  It's free and provides color highlighting for SQL and many other languages.  It's available from http://www.context.cx/

    It's fast, and it works well, and I've written some scripts to help me load it quickly, passing the filename as a parameter.  I've also associated the .SQL extension with it, so double-clicking on the file sends it to Context rather than to ISQL/OSQL/etc.

    Tim


    Timothy J. Bruce

  • Rudy Panigas

    SSChampion

    Points: 10695

    SQLRecon - see my earlier post It will display the versions of sql it found on your network

    Rudy

Viewing 15 posts - 1 through 15 (of 60 total)

You must be logged in to reply to this topic. Login to reply