Organizational tools that can help you be a better DBA

  • SqlOnMyMind

    SSCertifiable

    Points: 5049

    nogoodboyo (2/19/2009)


    Not exactly DBA specific, but very useful non the less, is Log Parser and a nice free UI Log Parser Lizard.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en

    http://www.lizardl.com/PageHtml.aspx?lng=2&PageId=18

    ToDoList...

    http://www.abstractspoon.com/

    All are free.

    Thanks for the tip! I am currently running a home-grown program to parse through a log file. Maybe one of these would be better.

  • yellowdog

    SSC Veteran

    Points: 287

    The Firefox add-ons mentioned are copies of features that have come standard in Opera for years.

    If you want a real productive/powerful browser with a smaller footprint, try Opera 10 (although in beta, still the best browser I've ever used.)

  • sjsubscribe

    SSCrazy

    Points: 2080

    Not to forget delicious, which is browser, os, and whatever agnostic. I can lookup via iPhone or an equivalent PDA. Firefox-based tools are good, but not depending on Firefox is even better.

  • TimothyAWiseman

    SSCrazy Eights

    Points: 8819

    The article was well done, but it was not really relevant to this site.

    Since we are talking about firefox extensions, I find the del.icio.us extension to be top-notch personally.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/

  • Jason Crider

    SSCertifiable

    Points: 6019

    timothyawiseman (2/19/2009)


    The article was well done, but it was not really relevant to this site.

    Since we are talking about firefox extensions, I find the del.icio.us extension to be top-notch personally.

    I believe it was put into the Career category because of the reasons that have been mentioned thus far. I didn't intend to make the weight of the article depend on Firefox because I understand there a good deal of people who cannot use it at work.

    I find dropbox and TiddlyWiki very useful and they have nothing to do with Firefox.

    Let me add a little bit more that I wish I would have included in the article.

    For me, I can setup a dropbox account on my home laptop, home desktop, work pc 1, and work pc2. I can place a folder there called SQLScripts. I can place scripts I need access to anywhere in there and I'll be able to get to them pretty easily from anywhere. I can create a folder called documents and place whitepapers, great ebooks available through Red Gate, or anything else that fits that criteria. I can create a little app folder that has great free apps that can be found in David Bird's excellent series of articles here[/url] and here[/url]. There are other great portable apps (not SQL related) that are on the web that I put in there to help me as well. While I'm praising David Bird I will plug the series that has help me the most from him that can be found here[/url]. That one is a must read for anyone using SSIS.

    If my article makes one person a better DBA(developer, whatever) then I am very happy that I have given something back.

    And yes, I'm trying to thicken my skin as I learn from this first article 🙂

  • Grant Fritchey

    SSC Guru

    Points: 396692

    I'm a little surprised at the "it's not DBA specific" statements. For those who don't know, yes, this site is focused on SQL Server, but it's not a DBA specific site. We've got developers, ETL experts, data miners, BI guys, report writers... just to name a few.

    This article was about managing the flow of information as a part of your job and I think it was very pertinent to the work that we do here. From the article I've already ordered the book Get Things Done from Amazon and I'm looking at the TiddlyWiki stuff (although I'm still more than a bit confused by how I would work that with the existing management tools I have).

    You guys need to lighten up. Not every article should be how to squeeze another 3ms out of your query.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Robert Davis

    One Orange Chip

    Points: 28027

    Grant Fritchey (2/20/2009)


    I'm a little surprised at the "it's not DBA specific" statements. For those who don't know, yes, this site is focused on SQL Server, but it's not a DBA specific site. We've got developers, ETL experts, data miners, BI guys, report writers... just to name a few.

    This article was about managing the flow of information as a part of your job and I think it was very pertinent to the work that we do here. From the article I've already ordered the book Get Things Done from Amazon and I'm looking at the TiddlyWiki stuff (although I'm still more than a bit confused by how I would work that with the existing management tools I have).

    You guys need to lighten up. Not every article should be how to squeeze another 3ms out of your query.

    I would agree with you if the title had not specifically called out that it was for DBA's: Organizational tools that can help you be a better DBA.

    The complaint isn't that the article isn't "DBA specific". The complaint is that the article is not what it claims to be.


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • Grant Fritchey

    SSC Guru

    Points: 396692

    Robert Davis (2/20/2009)


    I would agree with you if the title had not specifically called out that it was for DBA's: Organizational tools that can help you be a better DBA.

    The complaint isn't that the article isn't "DBA specific". The complaint is that the article is not what it claims to be.

    I guess we have to agree to disagree. I thought it was very much directed at better ways to get things done, one dba to another. Seems like a pretty valid point, but I could be wrong.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jason Crider

    SSCertifiable

    Points: 6019

    I need a bigger staff of technical editors. 🙂

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720887

  • Emito

    Mr or Mrs. 500

    Points: 556

    Thanks Jason, great article!!!

    I like the tiddlywiki, tks man.

    Emiliano.

  • Jason Crider

    SSCertifiable

    Points: 6019

    you are very welcome Emiliano.

  • bmotekaitis

    Newbie

    Points: 9

    Another super useful tool (and wow, wiki integration would just make it perfect) is mind mapping software. A good one is a commercial product called OpenMind2 by MatchWare, but the price is perfect for foss FreeMind which does it all minus a little Office integration.

Viewing 13 posts - 16 through 28 (of 28 total)

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