8 Clicks to What Changed

Question

Post reply

8 Clicks to What Changed

Bill Wunder

Old Hand

Points: 317
More actions
February 22, 2009 at 2:38 am

#95093

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

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

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

Jeff Moden SSC Guru Points: 1004321 More actions · Answer 1

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Bill Wunder Old Hand Points: 317 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

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: 736172 More actions · Answer 5

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: 1004321 More actions · Answer 6

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 7

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

Bill Wunder Old Hand Points: 317 More actions · Answer 8

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: 1004321 More actions · Answer 9

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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 10

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 More actions · Answer 11

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: 26631 More actions · Answer 12

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.