Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Free Tools for the SQL Server DBA


Free Tools for the SQL Server DBA

Author
Message
JHop34
JHop34
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 224
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
yonision
yonision
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 164
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



Ismael Medina-428634
Ismael Medina-428634
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
Adrian Charles Chetwynd-Talbot...
Adrian Charles Chetwynd-Talbot
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
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
amit_ary
amit_ary
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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



dejan-1116676
dejan-1116676
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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/
Paul McKenzie
Paul McKenzie
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 48
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
Hemantgiri S. Goswami
Hemantgiri S. Goswami
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 228
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 Specialist & Consultant
SQL Server Citation | Follow me on Twitter
Kim Killian-SiteDataView
Kim Killian-SiteDataView
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 326
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
sqlhuntingdog
sqlhuntingdog
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search