Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

More Than One Way to Skin a Cat Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2008 10:47 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
Comments posted to this topic are about the item More Than One Way to Skin a Cat






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #454864
Posted Wednesday, February 13, 2008 1:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:58 AM
Points: 5,077, Visits: 8,918
Alt-X? Ctrl-E? I wasn't aware of either - I use F5!

John
Post #454894
Posted Wednesday, February 13, 2008 1:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, January 13, 2014 4:35 AM
Points: 1,046, Visits: 2,997
Interesting topic, Steve

In general, I agree. The best way is the way that gets the job done effectively, and the best of two equally effective ways is the one you're most comfortable with.

The more I work with SQL Server, the less I feel any kind of affilliation with it. That sounds harsh, but my DBA career started with Oracle, and it's simply a reflection that I'm finding SQL Server as just as effective within the remits I've given it. In effect, I started off biased towards Oracle, and the more I use SQL Server, the more I'm comfortable with the idea that different RDBMS's are just different tools to achieve much the same effect. Certainly, each has its strengths and weaknesses, but they're tools - no more, no less.

And that goes for areas within it, right down to minor syntactical detail (I usually use convert instead of cast).

However, I'm a little more twitchy regarding what you were saying about defaults. Back in the day (to use a fairly simple analogy), the biggest difference in security and stability between Windows NT and UNIX wasn't bad code; it was defaults. "This is a whizzy new feature, let's enable it by default." It was perfectly possible to securely lock down an NT server, just as it was perfectly possible to open up a UNIX server, but the main difference was the vendors' choices regarding defaults.

Right now, Microsoft is older and wiser, as is the UNIX/Linux community. MS products are more secure than they used to be, and UNIX/Linux products are more user-friendly. However, I'm still not sure that any particular default setting is set by the manufacturer for a good, random or expedient reason, and that goes for ANY software, not just OS's, RDBMS's, whatever. Unfortunately, nor do I have any good suggestion as to how to improve things.


Semper in excretia, sumus solum profundum variat
Post #454897
Posted Wednesday, February 13, 2008 5:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 10:18 AM
Points: 294, Visits: 1,008
I agree. I've been partly a DBA amongst with several other tasks and I like to know what I can do and what is best and it takes a lot of time to read throu everything and get a good understanding about it all since I compleated my studies 1 year ago and have been in the bussines in 2 days for exactly 1 year. Better best practices and more info would be sweet where experiences are listed etc on when to use what etc. Good topic to talk about from my point of view!
Post #454987
Posted Wednesday, February 13, 2008 6:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 32,781, Visits: 14,942
Major,

I tend to agree with you on defaults. I think that most of the time they're just set to something without a lot of thought about what makes the most sense.

That's where I think MS should improve. Make a conscious decision that makes sense most of the time. Not all the time, but for the inexperienced or non-DBAs, set things in the way that is more secure and provides a good general setting.

Then give guidance on which way things ought to be. Presumably there are people talking to DBAs, customers, etc. about issues, what works, what doesn't , and they can make some good guesses about what works 80% of the time.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #454998
Posted Wednesday, February 13, 2008 6:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, January 13, 2014 4:35 AM
Points: 1,046, Visits: 2,997
Steve Jones - Editor (2/13/2008)
Major,

I tend to agree with you on defaults. I think that most of the time they're just set to something without a lot of thought about what makes the most sense.

That's where I think MS should improve. Make a conscious decision that makes sense most of the time. Not all the time, but for the inexperienced or non-DBAs, set things in the way that is more secure and provides a good general setting.

Then give guidance on which way things ought to be. Presumably there are people talking to DBAs, customers, etc. about issues, what works, what doesn't , and they can make some good guesses about what works 80% of the time.


True. Unfortunately, there also hangs the problem. Should MS use a default that is potentially insecure but is what 80% of experienced DBAs use (good marketing), or a default that is secure, but will probably be altered (good administration)? Damned if they do, damned if they don't, hence why I admit to not having a silver bullet answer.


Semper in excretia, sumus solum profundum variat
Post #455001
Posted Wednesday, February 13, 2008 7:58 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:57 AM
Points: 561, Visits: 2,416
I used all the nice keyboard shortcuts in Query analyser, and then they went and changed them for SSMS.

The father of a friend of mine was a taxidermist, (hobby- there aren't many professionals left in Britain) and so my first question to him was 'How many ways actually are there of skinning a cat?' He said that there was only one sensible way of doing it. Not a lot of people know this. Actually, although I'm a great cat enthusiast, there is a worrying plague of feral cats in Australia. It has caused the extinction of some species on islands and is thought to have contributed to the disappearance of many ground-dwelling birds and mammals on the mainland. There is quite a trade in Cat-Hats, I'm told, so maybe one of our Aussie friends can elucidate. (the phrase '... skin a cat' goes back to the 17th century)

It is surprising how much duplication there is in SQL Server in the whole area of WMI, Performance monitoring, DDL Triggers, DMV, alerts notifications and so on. This huge 'richness' in tokens, counters, variables and so on must add immensely to the task of testing. I dream of being invited to be a member of a sort of assassination squad within Microsoft that is dedicated to removing all the old discarded and under-used lumber from SQL Server, to slim the product to the minimum necessary. I'd nominate TEXT variables for the Death Squad. As I'm having quite a struggle with WMI Alerts at the moment, I might just give that the last cigarette and line it up against the wall.

Get rid of all the overhead that sucks in all the test effort and we might have more releases on time.



Best wishes,

Phil Factor
Simple Talk
Post #455090
Posted Wednesday, February 13, 2008 9:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 10, 2014 5:44 PM
Points: 2,225, Visits: 1,258
Having more then a few ways to do something allows folks to do it the way they are most comfortable, using a button, mouse or key combinations fit some minds better then other ways. Hey! Someday we will just say it. How cool is that.

Haveing many ways to do the same thing also allows many to argue which was is the best. So there is something for everyone here.

Have a great day...

Miles...


Not all gray hairs are Dinosaurs!
Post #455163
Posted Wednesday, February 13, 2008 10:00 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 21, 2014 2:03 AM
Points: 179, Visits: 158
I think that one area of improvement that could really help with many of the possible choices for completing a task is to have some strong guidance from Microsoft (based on customer pilot testing and the reasons for implementing a feature) that would explain what the defaults should be. And would have those defaults set up as the default choices or actions for the product.


I couldn't agree more...having all those solutions to solve a problem (but mostly you can't even know if it helps solving exactly the kind of problem you're facing) is very nice. Should we get some "why" added to the "how" would make our lives a lot easier :)

Luc


Luc Magnée
MCTS BI
Antwerp - Belgium
Post #455198
Posted Wednesday, February 13, 2008 11:51 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, October 21, 2013 10:48 AM
Points: 966, Visits: 933
I agree, the variety of solutions to any particular problem is nice.

A downside with choices is when you have to explain all of those choices. For Example:

Dev - How can I accomplish X?
DBA - You can use solution A, B, or C.
Dev - How does A work?
.....
DEV - But what about D?
....
DBA - Get out of my cube, I have work to do! :)



Post #455268
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse