SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Where Do You Go for Authoritative SQL Server Best Practices?


Where Do You Go for Authoritative SQL Server Best Practices?

Author
Message
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
SSChasing Mays
SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)SSChasing Mays (628 reputation)

Group: General Forum Members
Points: 628 Visits: 730
MHilsher, I love your parable.

Brad M. McGehee
DBA
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86498 Visits: 41098
Jason Selburg (6/27/2011)
I just ask Jeff. :-D

:-PBlush
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
paul s-306273
paul s-306273
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2425 Visits: 1113
Jeff Moden suggested I might be in the wrong job..... I know I am.

Paul.
SAP ABAP developer.

(and that's on Oracle).
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32493 Visits: 18556
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Claude V Lewis
Claude V Lewis
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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 Wink. Start that list with......take a backup even when you dont think you need one.
David.Poole
David.Poole
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7637 Visits: 3286
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
John Neville
John Neville
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 47
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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)SSC Guru (86K reputation)

Group: General Forum Members
Points: 86498 Visits: 41098
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
eccentricDBA
eccentricDBA
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1724 Visits: 1339
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.
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32493 Visits: 18556
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

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