solving the accidental dba problem

16
Seven Tips For Solving the Accidental DBA Problem Thomas LaRock Head Geek © 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Upload: thomas-larock

Post on 12-Jul-2015

148 views

Category:

Technology


1 download

TRANSCRIPT

Page 1: Solving The Accidental DBA Problem

Seven Tips For Solving the Accidental DBA Problem

Thomas LaRock

Head Geek

© 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Page 2: Solving The Accidental DBA Problem

CONGRATS!

YOU ARE (ACCIDENTALLY) THE NEW DBA!

Page 3: Solving The Accidental DBA Problem

But where some people only see problems…

…we see solutions.

Page 4: Solving The Accidental DBA Problem

SOLUTION YOU MUST THINK LIKE A DBA!

Need To Have The Right Mindest

Must Be Able To Solve Problems

Ability To Prioritize Tasks

Page 5: Solving The Accidental DBA Problem

Performance

Page 6: Solving The Accidental DBA Problem

Seven Tips

The first step is to admit you have a problem

1

Page 7: Solving The Accidental DBA Problem

Seven Tips

Spend time

in discovery

2

Page 8: Solving The Accidental DBA Problem

Seven Tips

Test your ability to recover

3

Page 9: Solving The Accidental DBA Problem

Seven Tips

Review your data security

4

Page 10: Solving The Accidental DBA Problem

Seven Tips

Improve your performance tuning skills

5

Page 11: Solving The Accidental DBA Problem

Seven Tips

Learn to manage expectations

6

Page 12: Solving The Accidental DBA Problem

Seven Tips

Develop a communication plan

7

Page 13: Solving The Accidental DBA Problem

How to Have Happy Data, Databases and Users

Do the right things

At the right times

For the right cost

And don’t forget to be grateful

for this opportunity

Page 14: Solving The Accidental DBA Problem

© 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Solving the Accidental DBA Problem

For more information on the seven steps check out my post at: http://thomaslarock.com/2014/12/seven-tips-for-solving-the-accidental-dba-problem

Also, you can view the webinar Karen López (blog | @datachick)and I did for the PASS DBA Fundamentals Virtual Chapter at: https://www.youtube.com/watch?v=Tzgel_oAem0

Page 15: Solving The Accidental DBA Problem

For More Information

http://tinyurl.com/minimalist-dba

http://tinyurl.com/waits-and-queues

http://tinyurl.com/verify-backups

http://tinyurl.com/database-sampling

https://sqlpowerdoc.codeplex.com/

https://ola.hallengren.com/

http://tinyurl.com/securing-sql-server

http://www.dataversity.net/fly-the-dang-plane/

Space Shuttle Discovery photo courtesy of NASA

Page 16: Solving The Accidental DBA Problem

© 2014 SOLARWINDS WORLDWIDE, LLC. ALL RIGHTS RESERVED.

Thank You!

The SOLARWINDS and SOLARWINDS & Design marks are the exclusive property of SolarWinds Worldwide, LLC, are registered with the U.S.

Patent and Trademark Office, and may be registered or pending registration in other countries. All other SolarWinds trademarks, service

marks, and logos may be common law marks, registered or pending registration in the United States or in other countries. All other

trademarks mentioned herein are used for identification purposes only and may be or are trademarks or registered trademarks of their respective

companies.