8 Clicks to What Changed

  • Bill Wunder

    Old Hand

    Points: 317

    Comments posted to this topic are about the item 8 Clicks to What Changed

    Bill Wunder

  • Jeff Moden

    SSC Guru

    Points: 993661

    I hope this was at least a paid entry. Other wise, I'd have to rate it as some seriously overdone SPAM.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Bill Wunder

    Old Hand

    Points: 317

    Sorry, Not paid and not my intention to SPAM anyone. I was worried about it being over the line but figured I'd at least make a few people chuckle. My mistake.

    Bill Wunder

  • chris.turner

    Old Hand

    Points: 372

    Perhaps not the most subtle...but that lack of sublety did make me chuckle. And whilst I don't think our company is likely to invest in the software at the moment, it's handy to know that it's available in the marketplace.

    C

  • M Chabot

    SSCrazy

    Points: 2511

    I find it unusual that the requirement of SQL Server 2008 is not mentioned until you actually try to install the utility.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714105

    Hmmm, I'm not sure how this is SPAM. It's listed as a case study, the description says it's a tool.

    We run these sponsored articles, and they are paid for. In this case, I waived the fee for Bill since he's been a great help to the SQL community and a friend.

  • Jeff Moden

    SSC Guru

    Points: 993661

    Sorry... didn't realize that it was a sponsored article in that, if you go directly to the article itself, there's nothing in the article or it's header to indicate that's what it was. I should have known better because people can actually post their own articles. My humble appologies.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714105

    People can't post their own articles. They can submit them, but they're all reviewed.

  • Bill Wunder

    Old Hand

    Points: 317

    To be honest, it does not really require SQL Server 2008, only the SQL Server 2008 SMO assemblies. However, if you try to target a SQL Server 2008 from a SQL Server 2005 without .NET 3.5 SP1 and 10.0 SMO the results are incomplete. Its the same problem you have with trying to use DMO on a 2005 instance.The backward compatibility scenario is a much better experience. So I decided it was better guidance to point yoou toward SQL Server 2008. I think it is spelled out a little better in the "Installing SQL Clue" help file.

    I added that installer check box page with the SQL Server 2008 requirement message last week. The check list is there as a reminder. It helps eliminate confusion about why the install fails when it fails. It also allows you to bail on the installation before anything happens.

    The true prerequisites - those checked in the Visual Studio setup project - are Windows Installer 3.1, .NET 3.5 SP1, ReportViewer 2008, and [a minimum of] SQL Server 2005 Express SP2. These can all be downloaded directly from Microsoft (at no cost).

    SQLClue is a great first SQL Server 2008 box for the DBA. It is an application fully under the control of the DBA and it uses features new with 2008. While the stuff installs, configures and runs nicely, you get an opportunity to get some time behind the wheel in a low stress but highly useful way before the shop adds a line of business 2008 instance.

    Bill Wunder

  • Jeff Moden

    SSC Guru

    Points: 993661

    Steve Jones - Editor (2/23/2009)


    People can't post their own articles. They can submit them, but they're all reviewed.

    And, I even phat-phingered my response... I meant to say "can't" and it came out "can".

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • RBarryYoung

    SSC Guru

    Points: 143327

    I am completely lost. Is SQLClue a product? And this article is a product review? Who makes it then?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • M Chabot

    SSCrazy

    Points: 2511

    It is a product created by the author of the article. He is selling it through his personal Web site.

  • Adam Bean

    One Orange Chip

    Points: 26440

    I am getting ready to start working with SQLClue myself as I have been using Bill's DDL Archive products since it's early form in DTS years ago. I have implemented the DDL Archive Utility (version prior to SQLClue) in three environments over the past 5 years and I can not put into words the value this product brings to a SQL environment from a DBA/Developer/Management perspective. From what I've demo'd, read about and spoken to Bill on, SQLClue appears to be far above and beyond the DDL AU and I can't wait to see what it has to offer. The DDL AU really gave me and all the individuals involved with the SQL environment a much better insight to as how frequently objects in our environment were changing, as well as provided a nice point in time snapshot for recovery purposes. I can't tell you how many times a developer changed an object without source safing and/or saving an existing version that came to me crying "help me ... I messed up X object". Because of Bill's product, I got to be the hero more times that I care to think about. That and as I've come to learn, even if you have the most locked down, secure and properly source controlled environment ... there will always be exceptions that were not caught or saved whereas Bill's tools will always be your warm security blanket.

    There are very few tools I use, much less pay for as a DBA as I prefer to create my own processes. Minus LiteSpeed and SQLCompare, Bill's software is the only other software that I will purchase. I have over the years demo'd several products similar to this and I have yet to find one that was worthwhile. Again, this is all in regards to the DDL AU ... SQLClue appears to bring so much more to the plate that as of today, I see no competition.

    I have been in touch with Bill for several years and have to say that Bill is truly a stand up guy. His product is amazingly priced. He has always provided very prompt and excellent support. He has taken the time several times to help me on issues not pertaining to this product. I can't recommend this guy enough, he is one of the best people I've met in this industry since I've become a DBA.

    Good luck on SQLClue Bill. I'll be harassing you soon enough once I'm underway with it in the new environment. I'll be sharing all my custom reporting and such with you and hopefully the community soon enough. As I've told Bill, I now manage and maintain an environment with well over 200 production instances of SQL and upwards of 800 total instances of SQL Server. This environment will be a great test for your product and I'll be happy to report back with my findings.

    ---
    SQLSlayer
    Making SQL do what we want it to do.

Viewing 13 posts - 1 through 13 (of 13 total)

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