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


An interview with the Exceptional DBA of the Year


An interview with the Exceptional DBA of the Year

Author
Message
Press Release
Press Release
SSC Veteran
SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)SSC Veteran (244 reputation)

Group: General Forum Members
Points: 244 Visits: 0
Comments posted to this topic are about the item An interview with the Exceptional DBA of the Year
Nick Harshbarger
Nick Harshbarger
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 209
Dan, congratulations on being selected Exceptional DBA of the Year. Way to go! Very impressive AND you ride a Harley.
Manie Verster
Manie Verster
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1623 Visits: 1022
Dan, congratulations on this great award!!! Next year you will have me to compete against! May the best DBA win!HeheHeheHeheHeheHeheHeheHehe

:-PManie Verster
Developer
Johannesburg
South Africa

I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
Larry Hawkes
Larry Hawkes
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 53
Dan,

Congratulations on your award... Cool

Here's a followup thought...

Would you consider writing an article on the script you created to automate every database maintenance task and metric collection process for new installs?

I have some things like that, but I'll bet that everyone (including me) could benefit from your experience...

Thanks and Good Scripting!

Larry Hawkes
darickard
darickard
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 47
Congratulations, Dan. I too would love to have a look at the scripts you've developed to automate maintenance. Now that you're the Exceptional DBA of the Year, here's your chance to extend your "continual[ly] learning and teaching" to a wider audience.

Best wishes,
DR



xyzt
xyzt
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 317
Congratulations Dan! Reading the interview was inspiring. Your comments displayed the kind of intentful forward thinking that brought you the award.

I'm interested in the standardization maintenance script and how it handles the different DB requirements. Specifically, how do you address databases where the data does not change often, versus databases where the data changes a lot. Or those that use full text indexes, and those that don't. Or those where the vendor supplied application guidelines indicate YES or NO to rebuilding indexes. Do you perform analysis before building the SQL system and apply one of several preset methodologies? Do you handle all system db's on all systems the same or differently within the script?

With only a few servers and DB's to handle, I keep trying to figure out how best to provide maintenance to what appears to me to be completely different needs. I'm self taught so part of my education is just trying different methods and continuing to read up. I have put off gathering data into some type of a table or report, but want to move this forward.
Kathi Kellenberger
Kathi Kellenberger
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: 1157 Visits: 342
Dan,

This makes me think we need to get you in front of the user group more often! We are really proud of you here in St. Louis. Congratulations!

Kathi

Aunt Kathi
Linchpin People Teammate
SQL Server MVP
Author of Expert T-SQL Window Functions
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)SSC Guru (85K reputation)

Group: General Forum Members
Points: 85555 Visits: 41082
Outstanding accomplishments, Dan. Well deserved award!

--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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62180 Visits: 19102
Congratulations!

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
DanMcClain
DanMcClain
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 578
Thank you all for your comments, and to those that voted for myself and all the finalists. As you can see in the posts I have had a few inquiries regarding the maint. scripts that I utilize and yes I will start putting together an article. It will probably be a multi-part article as my current script file is over 8900 lines of T-SQL. Hope you read my last article in the SSC newsletter on May 21 2008, [url=http://www.sqlservercentral.com/NewsletterArchive/2008/05/21/924952#content63130][/url]. But, I first need to finish one I have started. It's on a little process I just completed that reads an outlook calendar (vbscript) and inserts the data into a SQL database. Look forward to meeting some if not all of you at the SQL PASS Summit-2008 in Seattle.

Dan McClain



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