Free Tools for the SQL Server DBA

Question

Post reply

Free Tools for the SQL Server DBA

Viewing 15 posts - 16 through 30 (of 59 total)

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

Vishal Verma-436010 SSC Enthusiast Points: 124 More actions · Answer 1

I ran SQLRecon. I get a scan result like the following sample:

how do you tell if the SQL server is licensed?

Thanks

Rudy Panigas SSChampion Points: 10702 More actions · Answer 2

The product will show the version number. Nothing will tell you if it's registered to you

or you company

Rudy

RSingh-135921 Default port Points: 1438 More actions · Answer 3

SQLServerToolKit is an amazing tool. Toad for SQL Server is also a useful tool. Thanks a million David for sharing these tools.

RSingh

anna.ellis@getronics.com Default port Points: 1465 More actions · Answer 4

SQLSpy from HybridX (http://www.hybridx.com/SqlSpy.Aspx )

David Bird SSCarpal Tunnel Points: 4669 More actions · Answer 5

Thanks for all the feed back on the article. I enjoyed reading about the additional free tools available and your comments on the article. I can't wait to give these other tools a try.

I did take a quick look at the open source tool KDiff3 mentioned by cowboy_k. The tool works great for scripts created by SQL Server 2005 Management Studio. Examdiff was unable to compare these scripts because it would treat them as binary files. KDiff3 has another nice feature. When it finds differences between files, only the differences are highlighted instead of the entire line.

Carlo, you should be able to access the link http://www.fullsun.net/. I am unaware of any alternative link.

David Bird

cutespn SSCommitted Points: 1669 More actions · Answer 6

cutespn

SSCommitted

Points: 1669

May 27, 2007 at 10:10 am

#709135

David,

Thanks for good article.

Regards,
Sudheer

Mohammad O. Ali SSC Rookie Points: 26 More actions · Answer 7

Hello

great article; thanks for the effort you have put to deliver this.

as for the zip utility I faced the same issue with files larger than 4GB; I am using winRAR, great tool in my opinion.

Regards

Mohammad O. Ali

cmille19 SSCertifiable Points: 5970 More actions · Answer 8

Nice article, here's a list of free/open source tools I've used:

Quest Comparison Suite for SQL Server -- Free version

DBDesigner4 -- (http://www.fabforce.net/dbdesigner4/) Data modeling tool generates MySQL scripts from diagrams, small change to make scripts SQL Server compliant.

ClearTrace (http://www.cleardata.biz/cleartrace/default.aspx)

SQLQueryStress (http://www.sqljunkies.com/WebLog/amachanic/archive/2006/10/21/24261.aspx)

Sherlock Block Monitor (http://www.sqlteam.com/downloads/sherlock13.zip)

A decent Terminal Services Connection manager is RoyalTS (http://www.code4ward.net/cs2/files/folders/rts1/entry12.aspx)

sqlpal -- Light weight Oracle query total that doesn't require messing with tns files. (http://www.sqlpal.com/)

GnuWin32 ports of grep, sed tr, paste, cut, etc.

Sourceforge hosted tools:

WinDirStat -- For finding and visualizing what's using space on servers. Doesn't need to be installed on server. I run with it \\servername\driveletter$ from my workstation

WinMerge -- For comparing files

Password Safe -- encrypted password keeper.

PDFCreator -- create a pdf document from any program

vicky_yu SSC Enthusiast Points: 139 More actions · Answer 9

Thanks for all the useful info.

Wondering if there is a DBA tool available for retrieving SQL password for database logins? Thanks.

Todd Carrier Hall of Fame Points: 3951 More actions · Answer 10

I don't think I've seen Clear Trace on anyone's list...

I use it every couple of months... very easy to use, and provides very valuable information regarding Prolile trace files

ClearTrace imports SQL Server 2000 and 2005 trace (and profiler) files into SQL Server and displays summary performance information. It is designed to provide the same performance summary as Read80Trace but in a graphical environment and for SQL Server 2005.

http://www.cleardata.biz/cleartrace/default.aspx

Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)

Al Siks Old Hand Points: 360 More actions · Answer 11

also, Siccolo - free tool for SQL Server management from mobile device.

at http://www.siccolo.com :

Start/Stop SQL Server Agent
Start/Stop/Restart SQL Server Job
View SQL Server Job Information - steps, schedule, execution history
View Available Databases and Database Objects
Restart SQL Server
Execute SQL Command and view "select command" results
View SQL Server Event Logs (Application, System etc)
Run SQL Query window (with semi-automated Insert/Update/Delete/Select Statements) Open/Save SQL Scripts in multiple tabs Save/Email results
Explore SQL Server Browse databases and database objects (tables/views/stored procedures)
Browse/Manage SQL Server jobs
Browse/Manage windows services (start/stop) View event logs (Application, System)

all from mobile device!

Got SQL Server? Manage It with Siccolo