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
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

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

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

Group: General Forum Members
Points: 209349 Visits: 41973
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
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: General Forum Members
Points: 3466 Visits: 1169
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 Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: General Forum Members
Points: 65043 Visits: 18570
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
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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.
Dave Poole
Dave Poole
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16442 Visits: 3403
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
www.simple-talk.com
John Neville
John Neville
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 50
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 (209K reputation)SSC Guru (209K reputation)SSC Guru (209K reputation)SSC Guru (209K reputation)SSC Guru (209K reputation)SSC Guru (209K reputation)SSC Guru (209K reputation)SSC Guru (209K reputation)

Group: General Forum Members
Points: 209349 Visits: 41973
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
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2205 Visits: 1354
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 Guru
SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)SSC Guru (65K reputation)

Group: General Forum Members
Points: 65043 Visits: 18570
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