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 ««123»»

Where Do You Go for Authoritative SQL Server Best Practices? Expand / Collapse
Author
Message
Posted Monday, June 27, 2011 1:30 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
MHilsher, I love your parable.

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1132412
Posted Monday, June 27, 2011 6:55 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 35,952, Visits: 30,240
Jason Selburg (6/27/2011)
I just ask Jeff.


Thanks, Jason.


--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." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1132579
Posted Tuesday, June 28, 2011 2:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
Jeff Moden suggested I might be in the wrong job..... I know I am.

Paul.
SAP ABAP developer.

(and that's on Oracle).
Post #1132687
Posted Tuesday, June 28, 2011 10:57 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:22 PM
Points: 20,458, Visits: 14,079
Jeff Moden (6/26/2011)
I pretty much use the same resources and in the order that you did when you wrote your book, Brad.

For your final question, I NEVER take anything at face value for SQL Server.


I tend to take the same path. Finding the information and then testing it is the best way to find the best practice and best implementation for your environment.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1133085
Posted Tuesday, June 28, 2011 11:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 28, 2014 8:52 AM
Points: 8, Visits: 71
I believe each topic needs its own authorative source. There is no one size fits all when it comes to SQL practice and/or development. Everywhere you look you find good arguments for doing things one way or another...........the best source is the one that allows a DBA to find the best practices for performance, stability and usability given his own setup. To ignore those conditions specific to that DBA's own business/data environment is asking for headaches and do overs.

Any DBA will attest to this: the best list for anyone in our world is more about what NOT to do than best practices ;). Start that list with......take a backup even when you dont think you need one.
Post #1133089
Posted Tuesday, June 28, 2011 3:16 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 2,865, Visits: 1,705
I tend to evaluate sites over time. Some authors I learn to trust, others I use to provoke thought.

In general I look for articles that give examples. In effect they document the experiment and the results therefore both are up for peer review.

An article may give a good write-up of results but without the experiment you have no idea of the circumstances that gave the result.

There are one or two MVP blogs that are really good but not all MVPs are created equally. Some MVPs seem to have gained their status through general competence but mainly wide ranging services to the M$ community. Others seem to have gained it through a more specialised focus. Both have their value, it just depends on what you want to achieve.

I sometimes find value in less experienced DBAs asking questions. You can learn as much from a good question as you will from a good answer.


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1133288
Posted Friday, July 08, 2011 4:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 4:42 AM
Points: 4, Visits: 23
I find the last part of the question the most interesting: "Do you ever take this advice at face value, or do you always test it to ensure that it works well in your environment?"

Of course, in an ideal world, nobody would ever take anybody else's word for it and would *thoroughly* test all code/patterns/workaround etc before using them... but just suppose the sugar has already hit the fan and thorough testing is impractical - how much testing is 'enough' before deploying?

And does the source of the advice make a difference to the amount of testing you deem necessary?

Suppose the bosses are screaming and jobs are on the line (or your reputation as a miracle-worker is being questioned) - do you test less thoroughly if you get a suggestion from a more reliable source than from an un-trusted source? Would a quick once-over on Developer edition on your laptop provide enough comfort to convice you to deploy to a live production server *IF* the advice came from BoL or an MVP?

And what if a heretofore reliable source suddenly gives a duff bit of advice (even monkeys fall out of trees)? Do you stick by them because of their historical reliability, or feel cheated and shun them in future?

I'm genuinely curious what people think (and what they do in the real world

My own $0.02 worth is that I tend to turn to Google when I hit an immediate problem, use blogs and forums to keep up to speed with what's going on in the rest of the world, and use books when i need to deep-dive into a topic. I'm in agreement with the posters above who say that past performance is generally the most important factor when deciding which blogs and books to choose: considering both the author and the publisher.
Post #1138774
Posted Friday, July 08, 2011 7:54 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 3:45 PM
Points: 35,952, Visits: 30,240
John Neville (7/8/2011)
Suppose the bosses are screaming and jobs are on the line (or your reputation as a miracle-worker is being questioned) - do you test less thoroughly if you get a suggestion from a more reliable source than from an un-trusted source? Would a quick once-over on Developer edition on your laptop provide enough comfort to convice you to deploy to a live production server *IF* the advice came from BoL or an MVP?


BOL has its flaws and so does MVP code. Not all MVP's are created equal.

Let's turn the question around... are you willing to stake your reputation as a miracle-worker on code that you haven't tested or have only done cursory checks on? I'm not.

A major key to success is to be able to quickly build enough of the right kind of test data to test just about everything in a very quick manner.

As a side bar, if the bosses are screaming, then they're probably the ones that came up with an over-aggresive schedule and they need to be reigned in. They need to understand that it's THEIR jobs that are "on the line", as well.


--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." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1138918
Posted Friday, July 08, 2011 8:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 6:12 AM
Points: 1,275, Visits: 661
Personally I use the following:
SQL Server Customer Avisory Team (SQLCAT)
http://sqlcat.com/
The Professional Association For SQL Server (PASS) (24 Hours of Pass, SQL Rally, SQL Saturdays and Local SQL User Groups)http://www.sqlpass.org/
SQL Server Central
sqlservercentral.com
Business Inteligence Developer Network
BIDN.com

MVP Blogs
Paul S Randal
Kimberly L. Tripp
Glen Berry
Brent Ozar
Buck Woody
Allen White
Kendra Little
Jeremiah Peschka
Thomas LaRock
Johathan Kehayias
Matt Hester
(and others)

Then I search to see if the information is consistant from multiple sources.
Post #1138932
Posted Friday, July 08, 2011 9:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 2:22 PM
Points: 20,458, Visits: 14,079
eccentricDBA (7/8/2011)
Personally I use the following:
SQL Server Customer Avisory Team (SQLCAT)
http://sqlcat.com/
The Professional Association For SQL Server (PASS) (24 Hours of Pass, SQL Rally, SQL Saturdays and Local SQL User Groups)http://www.sqlpass.org/
SQL Server Central
sqlservercentral.com
Business Inteligence Developer Network
BIDN.com

MVP Blogs
Paul S Randal
Kimberly L. Tripp
Glen Berry
Brent Ozar
Buck Woody
Allen White
Kendra Little
Jeremiah Peschka
Thomas LaRock
Johathan Kehayias
Matt Hester
(and others)

Then I search to see if the information is consistant from multiple sources.


That's a good list




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1139014
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse