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 «««23456

Free Tools for the SQL Server DBA Expand / Collapse
Author
Message
Posted Tuesday, September 02, 2008 3:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:56 AM
Points: 44, Visits: 207
for database comparison, I use sql effects clarity ce which is the free version.

edit_11/9/2009: FYI: the name has been changed to SQL Accord CE
Post #562710
Posted Friday, October 03, 2008 7:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, January 17, 2014 9:07 AM
Points: 52, Visits: 154
hey,
here's another cool free tool:
its something like sql server but monitors your data only. tells you about any data changes that happened in your tables, generate scripts to roll back or forward to any point in time. nice.

http://www.nobhillsoft.com/DataProfiler.aspx



Post #580245
Posted Thursday, December 04, 2008 9:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 10:58 AM
Points: 1, Visits: 109
Amazing!!!!.

Incredible list of tools .

I would add 2. The best performance analisys tools, very useful, makes my tuning job very simple.

Performance Analisys of Logs - CODEPLEX (Useful to identify hardware bottlenecks)
SQL Nexus - CODEPLEX (Useful to identify the top n expensive statements or batches).

This two consume information from PSSDiag and SQLDiag.
Post #613831
Posted Tuesday, March 03, 2009 6:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 10, 2010 5:12 AM
Points: 36, Visits: 31
The section about the FullSun SQL Server Toolkit sounds excellent, the only problem being clicking on the hyperlink connects to the URL http://www.fullsun.net but with no web pages? would be great if the correct website/url was available or guidance to obtain this tool

Post #667246
Posted Monday, May 04, 2009 1:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 12:07 PM
Points: 1, Visits: 31
SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.

It allows exporting the documentation to CHM format (Microsoft Compiled HTML Help). And it is easy and interactive, also allows multiple database documentation.

http://www.amitchaudhary.com/SQLDocSharp_WordToHTML.htm



Post #709222
Posted Wednesday, June 17, 2009 2:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 17, 2009 3:41 PM
Points: 3, Visits: 2
DbOctopus, browsing and editing for SQL Server with strong support for relations. Also includes SQL Editor with code completion. Free licenses until 1st September 2009.

http://www.cogin.com/dboctopus/
Post #737000
Posted Monday, July 27, 2009 4:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 1:49 PM
Points: 5, Visits: 47
Here is a great free tool for rapidly creating SQL Reporting Services Reports. Its quick, easy and will give you fully featured (filtering, sorting, summing and styled) report. Enjoy!

http://www.expressreporting.com
Post #760411
Posted Monday, November 09, 2009 4:56 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, March 29, 2014 4:39 AM
Points: 12, Visits: 148
Hi All,

I was searching for some tool and landed here on this page. It is nice to see great tools. Here are some free tools:

SQLDBDiff V3.0.0 -- This tool can compare data and schema
SQLDBSearch V2.0.0 -- This tool is used to search content or object
SQLDBSize V1.0.0 -- graphical display of sp_spaceused

These tools can be downloaded from http://www.sqldbtools.com/Tools.aspx


Hemantgiri S. Goswami | SQL Server Spcialist & Consultant
SQL Server Citation | Founder & Leader - Surat User Group

Post #815736
Posted Monday, January 17, 2011 7:02 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 1:33 PM
Points: 37, Visits: 264
David, is there any trick to getting this set of reports and ssis working on S2k8? I have this rolled out on my environment which has 2000-2008 and I'm only successfull with SQL 2000 and 2005. On the 2008 machines, I get the following errors:

Load Backup History component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Load Database Status component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Load Job History component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Load Jobs component "OLE DB Source" (1) failed validation and returned error code 0xC020801C.
Execute XP_MSVER Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.
Get Database Info Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.
Get Disk Space Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.
Get ErrorLog Failed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.
Load Backup History SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Database Status SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Job History SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Jobs SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Backup History SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Database Status SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Job History SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Jobs SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Load Backup History There were errors during task validation.
Load Database Status There were errors during task validation.
Load Job History There were errors during task validation.
Load Jobs There were errors during task validation.

I have enabled xp_cmdshell and ole and the dtc service.


Thanks,
Kimberly Killian
Sr. DBA / DB Engineer
www.sitedataview.com
Follow me on Twitter
Follow me on Facebook
Post #1048742
Posted Thursday, August 08, 2013 7:37 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, September 07, 2013 6:50 AM
Points: 11, Visits: 24
Great free tool (Addin for SQL Server Management Studio 2008 / 2012) is SQL Hunting Dog




please use free productivity tool for SSMS - SQL Hunting Dog
Post #1482333
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse