I ran SQLRecon. I get a scan result like the following sample:
how do you tell if the SQL server is licensed?
The product will show the version number. Nothing will tell you if it's registered to you
or you company
SQLServerToolKit is an amazing tool. Toad for SQL Server is also a useful tool. Thanks a million David for sharing these tools.
SQLSpy from HybridX (http://www.hybridx.com/SqlSpy.Aspx)
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.
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.
Mohammad O. Ali
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.
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
Thanks for all the useful info.
Wondering if there is a DBA tool available for retrieving SQL password for database logins? Thanks.
Hall of Fame
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.
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
also, Siccolo - free tool for SQL Server management from mobile device.
all from mobile device!
Hey DatabaseWorkBench is not free. I think we are looking for free tools, but not bad product for the price.
Here's one more: Try http://www.sqlscripter.com
Two more free tools that may be helpful:
SQLpermissions: Creates a T-SQL script to automitically move or copy SQL Server logins & permissions
SQLsafe Freeware: Free SQL Server backup
Viewing 15 posts - 16 through 30 (of 59 total)