Essential Software

  • Does anyone use the Database Publishing Wizard tool from Microsoft?

    http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

  • PrintKey

    BeyondCompare

    Notepad++

    RedGate Toolbelt

    TFS (VSS)

    Password Safe

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • There is a tool that no one has listed and it is Free.

    SSMS Tool Pack. Between this and SSMS 08, I essential get Redgate sql promt for free. Granted, it is trimmed down, but still free.

    Seriously, if you haven't heard of it, go and try it. I think my 3 favorite things are default and user defined sql snippets, window connection coloring that is vastly superior to 08, and the basic formatting it has. The only thing it doesn't do for me is intelli-scense, and that is now free with 2008.

    Outside of this:

    Quest Litespeed

    Confio Ignite

    Fraggle

  • Steve-3_5_7_9 (4/9/2010)


    SQLCompare

    SQLDataCompare

    Ultraedit

    SSMS

    SQLServerProfiler

    Yes to those, PowerShell and and a few utilities I wrote myself.

    --Paul Hunter

  • Fraggle-805517 (4/9/2010)


    There is a tool that no one has listed and it is Free.

    SSMS Tool Pack. Between this and SSMS 08, I essential get Redgate sql promt for free. Granted, it is trimmed down, but still free.

    Seriously, if you haven't heard of it, go and try it. I think my 3 favorite things are default and user defined sql snippets, window connection coloring that is vastly superior to 08, and the basic formatting it has. The only thing it doesn't do for me is intelli-scense, and that is now free with 2008.

    Outside of this:

    Quest Litespeed

    Confio Ignite

    Fraggle

    I like Confio.

    Thanks for the heads up on the Tool Pack.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I agree with a couple of folks above that SQL Sentry is a good 3rd party tool. It's proven itself in our large scale environment. It's monitoring is very reliable and not flakey like Tivoli. Performance Advisor within SQL Sentry is a great diagnostic tool to see realtime performance metrics or historical data.

    Regards,

    Larry Briscoe

    DatabaseNinja

  • Just realized I forgot one.

    SQL Server 2005 Performance Dashboard Report. Based upon the internal DMV.

    Fraggle

  • Hi,

    On my list

    SSMS

    Winmerge for comparing/merging text files

    Context editor

    Notepad++ editor

    A bunch of query templates

    Cheers

    David

  • What we all should be doing is also posting links to the software we like. I'll add a few more to my list. I generally just use SSMS. but I'll add a few to my list of favourites apps that help me do everything else.

    Paint .net http://www.getpaint.net/ Fast and easy way to get custom colours #s

    http://notepad-plus.sourceforge.net/uk/site.htm notepadd++.

    http://virtuawin.sourceforge.net/ Multiple desktops for windows. (for when 3 monitors doesn`t give enough desktop real-estate)

    http://bluemars.org/clipx/ a Clipboard history. I can`t live without it anymore. A machine without this feels like a VIC20

    http://www.realtimesoft.com/ultramon/ I use this for flipping apps from one monitor to another. That way I keel my hands on the keyboard.

    Maybe when this thread quietens down we should make a list so we don`t have to sort through 4 pages.

  • Maybe when this thread quietens down we should make a list so we don`t have to sort through 4 pages.

    Maybe we could all just post a script that does a series of inserts into a table defined as

    create table mylist(

    ssid varchar(30),

    prodname varchar(50),

    url(100))

  • Michael,

    That's a good idea. I might built such a DDL script that people can use to do their own counts and analysis.

Viewing 11 posts - 31 through 40 (of 40 total)

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