Docstoc

_Session Title_

Document Sample
_Session Title_ Powered By Docstoc
					        Helpdesk to DBA in 60
       Tips & Tricks for the new DBA

            Meredith Ryan-Smith




# 66
Meredith Ryan-Smith
•   12 years in IT, 5 years as DBA at The Bell Group
•   Chapter Leader of the PASS WIT VC
•   http://meredithryansmith.wordpress.com/
•   http://twitter.com/#!/coffegrl
•   coffegrl@gmail.com




     # 66
First Things First: Don’t Panic!




# 66   http://www.flickr.com/photos/paperpariah/2417220138/in/photostream
• Learn what your scope is
 –Hardware forward

 –OS forward

 –SQL forward




  # 66
   Get to know your instances




# 66
             Other methods
• Where is SQL installed?
  – Ted Krueger’s blog using SQL Ping 2:
    http://blogs.lessthandot.com/index.php/DataMg
    mt/DBAdmin/scan-network-for-sql-server-
    instances
  – Buck Woody’s blog uses Power Shell and WMI:
    http://blogs.msdn.com/b/buckwoody/archive/20
    09/03/11/find-those-rogue-sql-servers-in-your-
    enterprise-with-powershell.aspx
  – SQL Discovery, Discovery Wizard

   # 66
• Who uses it?
 –Talk to your customers to get the real
  story.
 –What applications depend on your
  instances?
 –What are the Service Level
  Agreements?
 –How is it performing now?


  # 66
             Learn the basics
• Management Studio is a beginners best friend

• Wizards get the job done and sometimes they
  can be quicker than scripting.

• Focus on the features that you use today



   # 66
• SQL University
  – http://sqlchicken.com/sql-university/


• Mike Walsh on where to start
  – http://www.straightpathsql.com/archives/2009/0
    3/where-do-i-start/


• Brent Ozar on where to start
  – http://www.brentozar.com/sql/becoming-a-dba/



   # 66
          Community to the rescue!
• The SQL community lives to help you learn.




   # 66
• SQL Server Central
  http://www.sqlservercentral.com/

• SQLServerPedia
  http://www.sqlserverpedia.com/

• LessThanDot
   http://lessthandot.com/



   # 66
 Learn to love Documentation




       http://www.flickr.com/photos/ahnmyrrh/3634153932/
# 66
• Should be complete and concise
  –Level of detail depends on the
   complexity of your systems


• Keep a physical copy – electronic
  won’t cut it in a disaster



  # 66
• Needs to be considered a ‘living
  document’ and updated
  frequently

• One set of documentation for
  each server
  –Database details live inside the server’s
   documentation

  # 66
• Jorge Segarra’s Runbook template
  http://sqlchicken.com/2010/04/creative-
  writing-week-documentation/

• SQL Doc from Redgate http://www.red-
  gate.com/products/SQL_Doc/index.htm

• Use Visio to map out your integration points –
  translate that whiteboard map into something
  less volatile

   # 66
# 66
       Turn this…




# 66
       Into this.
# 66
     Automate yourself out of a job
•   Backup jobs
•   Index maintenance
•   Integrity checks
•   Event/error notifications
•   Any other repetitive tasks
•   Gathering baselines


     # 66
• Ola Hallengren’s Backup, Integrity Check and
  Index Optimization solution
  – http://ola.hallengren.com/



• Michelle Ufford’s index maintenance script
  – http://sqlfool.com/2010/04/index-defrag-script-
    v4-0/




   # 66
• Ted Krueger’s blog on setting up email
  notifications
  – http://blogs.lessthandot.com/index.php/DataMg
    mt/DBAdmin/lazy-dba-email-this-stuff


• Grant Fritchey’s blog on automating Server
  Side Traces
  – http://www.scarydba.com/2011/02/08/tsql-
    tuesday-15automation-in-sql-server/




   # 66
                 Next steps:
• Act on the info you collected from user base
  – Remediate any issues
  – Performance tuning
  – Plan for future growth
• Look at ways to simplify and standardize your
  environment




   # 66
          Thank you and Feedback
• Thank you for attending Helpdesk to DBA in 60
  Minutes at SQL Saturday #66
• Please make sure to fill out the session
  evaluation and place it in the box in the back
  of the room




   # 66

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:8/28/2011
language:English
pages:23