Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


More Than One Way to Skin a Cat


More Than One Way to Skin a Cat

Author
Message
James Goodwin
James Goodwin
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1363 Visits: 1107
Re: Defaults

First off, I'm pretty sure there is some sort of team/committee for each Microsoft product that decides on what the defaults should be. I'm also sure that decisions reached by that committee aren't going to suit everyone, even those on the committee.

I think that for a product like SQL Server that is meant to be administered by a professional, there should be very few, if any, defaults. Instead of setting defaults and forcing the administrator to navigate through various menus to set up the server "properly" (i.e. the way he wants it) the install should present the ability to set all of the options right up front. Anything that isn't a gimme (e.g. ANSI_NULLS) should be required to be set.

Obviously, that doesn't work for desktop software. Desktop software should be defaulted to be usable right off the bat without any tweaking until you find something you really want to change.

As for the multiple ways to do things. Generally, it's good. But, I have seen a lot of people (and have myself been guilty of) get caught up in trying to pick the best option when any of several good enough options would have been fine.
--
JimFive
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36087 Visits: 18738
I hope there's a committee, but my guess is that whichever developer works on it gets to decide. He/she may ask for advice or have guidance, but I would bet tons of features have defaults determined by an "executive decision" at the lowest levels.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
majorbloodnock
majorbloodnock
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1113 Visits: 3062
Agreed with the "executive decision".

I'd also agree with James that that's the way it should be, but if you make something only available to experienced professionals, a lot of potential buyers will simply not buy it. Microsoft simply couldn't afford to make a decision like that, so the result is a commercially necessary compromise.

Semper in excretia, sumus solum profundum variat
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search