Free Tools for the SQL Server DBA

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » Free Tools for the SQL Server DBA

59 posts, Page 6 of 6

«««2 3 4 5 6

Free Tools for the SQL Server DBA

Rate Topic

Display Mode

Topic Options

Author

Message

Jay Hopping

Posted Tuesday, September 02, 2008 3:27 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, August 30, 2012 9:37 AM
Points: 44, Visits: 202

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

yonision

Posted Friday, October 03, 2008 7:08 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 11:39 AM
Points: 52, Visits: 151

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

Ismael Medina-428634

Posted Thursday, December 04, 2008 9:22 AM

Forum Newbie

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

Amazing!!!!.

Incredible list of tools w00t

.

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

Adrian Charles Chetwynd-Talbot...

Posted Tuesday, March 03, 2009 6:37 AM

SSC 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

amit_ary

Posted Monday, May 04, 2009 1:39 AM

Forum 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

dejan-1116676

Posted Wednesday, June 17, 2009 2:58 PM

Forum 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

Paul McKenzie

Posted Monday, July 27, 2009 4:43 PM

Forum 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

Hemantgiri S. Goswami

Posted Monday, November 09, 2009 4:56 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:15 AM
Points: 12, Visits: 136

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

Kim Killian-SiteDataView

Posted Monday, January 17, 2011 7:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 12:06 PM
Points: 30, Visits: 233

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

Post #1048742

« Prev Topic | Next Topic »

59 posts, Page 6 of 6

«««2 3 4 5 6

Permissions