<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Where Do You Go for Authoritative SQL Server...
23 posts, Page 2 of 3
««
1
2
3
»»
Where Do You Go for Authoritative SQL Server Best Practices?
Rate Topic
Display Mode
Topic Options
Author
Message
bradmcgehee@hotmail.com
bradmcgehee@hotmail.com
Posted Monday, June 27, 2011 1:30 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
MHilsher, I love your parable.
Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1132412
Jeff Moden
Jeff Moden
Posted Monday, June 27, 2011 6:55 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 32,931,
Visits: 26,820
Jason Selburg (6/27/2011)
I just ask Jeff.
Thanks, Jason.
--Jeff Moden
"
RBAR
is pronounced "ree-bar" and is a "Modenism" for "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1132579
paul s-306273
paul s-306273
Posted Tuesday, June 28, 2011 2:29 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,161,
Visits: 642
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
SQLRNNR
SQLRNNR
Posted Tuesday, June 28, 2011 10:57 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 10:25 AM
Points: 18,754,
Visits: 12,337
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 2008
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
Claude V Lewis
Claude V Lewis
Posted Tuesday, June 28, 2011 11:02 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, January 08, 2013 12:48 PM
Points: 6,
Visits: 47
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
David.Poole
David.Poole
Posted Tuesday, June 28, 2011 3:16 PM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 2,750,
Visits: 1,410
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
Post #1133288
John Neville
John Neville
Posted Friday, July 08, 2011 4:28 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, March 13, 2013 4:21 AM
Points: 3,
Visits: 14
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
Jeff Moden
Jeff Moden
Posted Friday, July 08, 2011 7:54 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 32,931,
Visits: 26,820
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 "
R
ow-
B
y-
A
gonizing-
R
ow".
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."
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1138918
eccentricDBA
eccentricDBA
Posted Friday, July 08, 2011 8:22 AM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 2:58 PM
Points: 888,
Visits: 543
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
SQLRNNR
SQLRNNR
Posted Friday, July 08, 2011 9:48 AM
SSCoach
Group: General Forum Members
Last Login: 2 days ago @ 10:25 AM
Points: 18,754,
Visits: 12,337
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 2008
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 »
23 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
