Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»

Free Tools for the SQL Server DBA Part 2 Expand / Collapse
Author
Message
Posted Thursday, July 23, 2009 5:13 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 23, 2009 3:55 AM
Points: 56, Visits: 23
Thanks for the list ;)

I would like to add my SQL Express Profiler. SQL Profiler it's and open source application that provides similar functionality the standard Profiler does. For those that use SQL Express or Workgroup edition it's a great tool.

http://sqlprofiler.googlepages.com
Post #758102
Posted Thursday, August 27, 2009 11:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, December 30, 2013 6:22 PM
Points: 25, Visits: 318
I also have a huge list of free tools. It has gone beyond just SQL tools, but very server administrator focused. http://www.sqlwebpedia.com/content/free-sql-server-tools

Chuck Lathrope
@SQLGuyChuck
Post #778900
Posted Friday, August 28, 2009 1:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 04, 2014 5:19 PM
Points: 265, Visits: 2,538
Nice list Chuck! Thanks for sharing.
Post #779295
Posted Saturday, November 07, 2009 8:37 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 20, 2012 10:53 PM
Points: 76, Visits: 126
This is kinda old article but still no tools you mentioned have become obsolete. I would like to mention SqlDBX personal which I think is very fast and good for quick querying.
http://www.sqldbx.com/personal_edition.htm


_____________________________________________________________


'Some people still are alive simply because it is illegal to shoot them... o_O '
Post #815438
Posted Friday, January 22, 2010 1:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 20, 2013 5:32 AM
Points: 4, Visits: 39
Microsoft SQL Server 2008 Management Studio Express isn't pre-packaged with SP1. You either install it with the regular download or (even simplier) with the Web Platform Installer (you can also install the Express database with it). Then just use Windows Update to get the SP1.

Web Platform Installer
http://www.microsoft.com/web/downloads/platform.aspx
Post #851803
Posted Friday, January 22, 2010 1:49 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 22, 2013 11:59 AM
Points: 509, Visits: 719
I have just released some tools which are either free or have free editions - there is:

SQL Everywhere - an IDE with code completion, auditing, multiple execution, lots more - free edition available
http://www.atlantis-interactive.co.uk/products/sqleverywhere/

Schema Inspector - a schema comparison and synchronisation tool - free edition available
http://www.atlantis-interactive.co.uk/products/schemainspector/

Data Space Analyser - a graphing tool to explore the space used in databases - totally free
http://www.atlantis-interactive.co.uk/products/dataspaceanalyser/


Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone
Post #851810
Posted Friday, January 22, 2010 2:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 09, 2014 3:23 AM
Points: 6, Visits: 47
Tried the link to SQL Safe Free Edition, but Idera have pulled it
Post #851827
Posted Friday, January 22, 2010 5:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 11, 2012 2:06 PM
Points: 28, Visits: 78
SQLScrubs Community Edition is a free resource for management, audit and optimization of SSRS 2008. It includes a datawarehouse, SSIS log scrubbers, and a basic kit of report to get you started.

Reporting services execution log review helps you locate the slowest reports, data hogs and areas to tune.

Http://scrubs.codeplex.com


SQLScrubs: SSRS Audit, Optimization & Management reports
Post #851931
Posted Friday, January 22, 2010 5:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 08, 2013 12:39 PM
Points: 29, Visits: 1,016
We have a central database that stores all data from independent companies databases. Does anyone know of a tool that compares data for two or more databases but with filtering functionality? I'd like to be able to compare the central database company A data to the database for company A, central database company B data to the database for company B, etc. The database schema's are identical.

Thanks,

M
Post #851953
Posted Friday, January 22, 2010 6:03 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, July 22, 2013 11:59 AM
Points: 509, Visits: 719
whoops

i thought you said schema, not data!

Red gate's data compare does it quite well, and the tablediff utility is worth investigating...


Atlantis Interactive - SQL Server Tools
My blog
Why I wrote a sql query analyzer clone
Post #851954
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse