Post reply

Free Tools for the SQL Server DBA

  • April 15, 2008 at 9:47 am

    #802667

    for web email, I like fastmail.fm better than either yahoo or gmail. been using them for many years.

    ---------------------------------------
    elsasoft.org

  • April 16, 2008 at 8:29 am

    #803119

    Idera offer free tools- so why don't you have a look there.

    John McCutcheon

  • April 25, 2008 at 2:51 am

    #807010

    Oracle SQL Developer with "jtds" is also useful for working with ms sql server 2005 !

  • May 19, 2008 at 4:58 am

    #817075

    PSPad (www.pspad.com)

    Freeware MDI text editor with colour syntax highlighting for a huge number of formats, including SQL.

  • August 18, 2008 at 9:59 pm

    #859791

    AJ (4/14/2008)

    I know that the new version of SQL Prompt is paid.

    Fortunately, when they had just begun with the project, they had free distribution of the software, which i have a copy of.

    If anyone wants the copy, they can let me know either directly, or guide me to a place where i can upload it, for others to download.

    Could you upload this tool on gmail or mediafire? I deleted my copy and now i can not find anywhere on net. 🙁

    Thanks

    Sol

  • September 2, 2008 at 3:27 pm

    #866249

    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

  • October 3, 2008 at 7:08 am

    #880441

    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

  • December 4, 2008 at 9:22 am

    #907709

    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.

  • March 3, 2009 at 6:37 am

    #952383

    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

  • May 4, 2009 at 1:39 am

    #987958

    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

  • June 17, 2009 at 2:59 pm

    #1011293

    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/

  • July 27, 2009 at 4:43 pm

    #1030788

    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

  • November 9, 2009 at 4:56 am

    #1076593

    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[/url] | Follow me on Twitter

  • January 17, 2011 at 7:02 am

    #1274229

    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 Historycomponent "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

    Load Database Statuscomponent "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

    Load Job Historycomponent "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

    Load Jobscomponent "OLE DB Source" (1) failed validation and returned error code 0xC020801C.

    Execute XP_MSVERFailed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Get Database InfoFailed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Get Disk SpaceFailed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Get ErrorLogFailed to acquire connection "MultiServer". Connection may not be configured correctly or you may not have the right permissions on this connection.

    Load Backup HistorySSIS 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 StatusSSIS 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 HistorySSIS 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 JobsSSIS 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 HistorySSIS 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 StatusSSIS 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 HistorySSIS 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 JobsSSIS 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 HistoryThere were errors during task validation.

    Load Database StatusThere were errors during task validation.

    Load Job HistoryThere were errors during task validation.

    Load JobsThere 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

  • August 8, 2013 at 7:37 am

    #1639772

    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 [/url]

Viewing 15 posts - 46 through 59 (of 59 total)

You must be logged in to reply to this topic. Login to reply