congratulations, you’re a dba... now what?
TRANSCRIPT
EMBARCADERO TECHNOLOGIESEMBARCADERO TECHNOLOGIES
Congratulations, You’re A DBA…Now What?
Presented by:
SQL Server MVP, Mike Walsh and John Sterrett
EMBARCADERO TECHNOLOGIES
About Mike Walsh
2
• SQL Server MVP Since 2011• Working with SQL Server for 16 years• Partner and Managing Director of the WellDBA™ Practice at Linchpin People• Blog at www.linchpinpeople.com and www.straightpathsql.com• Runs the Seacoast SQL Server User Group alongside Jack Corbett• Speaks at various SQL events• I’ve been a new DBA, a few times. • @Mike_Walsh on twitter
About Linchpin PeopleLinchpin People is a company made up of many SQL Server experts. We have a trade guild mentality –working with the craftsmen in our field on various SQL server challenges. One of our service offerings, the WellDBA Exam™ highlights a lot of the misses of the areas of focus we’re talking about here. We often see the same patterns exist in many environments.
EMBARCADERO TECHNOLOGIES
About John Sterrett
3
• Working with SQL Server for 10 years• Group Principal of the WellDBA™ Practice at Linchpin People • Blogs at www.johnsterrett.com and www.linchpinpeople.com• Tweets at @JohnSterrett• Speaks at a lot of SQL Server conferences• Runs a SQL Server User Group in Austin, TX • Runs the High Availability PASS Virtual Chapter• PASS Regional Mentor for South Central US Region• Co-Author of a book SQL Server 2014 Backup and Recovery• He’s been a new DBA a few times, too.
EMBARCADERO TECHNOLOGIES
Let’s start with a story…
EMBARCADERO TECHNOLOGIES
“Where Do I Start?”
Flickr: www.flickr.com/photos/uxud/3396427350/in/set-72157618745751536/
EMBARCADERO TECHNOLOGIES
Flickr: http://www.flickr.com/photos/brykmantra/76765412/
“How’s the Sr. DBA?”
EMBARCADERO TECHNOLOGIES
Goal #1
Leave As
Advocates
7
EMBARCADERO TECHNOLOGIES
Goal #2
Leave With
Questions
8
EMBARCADERO TECHNOLOGIES
Goal #3
Beat Up a MYTH
9
EMBARCADERO TECHNOLOGIES
EMBARCADERO TECHNOLOGIES
EMBARCADERO TECHNOLOGIES
“Set It And Forget It”
12
EMBARCADERO TECHNOLOGIES
“Set It And Forget It”“Set It And Forget It”
EMBARCADERO TECHNOLOGIES
Alright… Enough History
Leave As ADVOCATESLeave With QUESTIONS
EMBARCADERO TECHNOLOGIES
15
database administrator(abbreviated as DBA)(computing) a person
who is responsible for the logical and
physical design of databases, and normally for all aspects of their recoverability,
integrity, security, availability and performance
Source: Wiktionary.Com
EMBARCADERO TECHNOLOGIES
16
So…Let’s Prioritize
EMBARCADERO TECHNOLOGIES
17
RecoverabilitySecurity & AuditabilityAvailabilityReliability“Performability”
EMBARCADERO TECHNOLOGIES
EMBARCADERO TECHNOLOGIES
EMBARCADERO TECHNOLOGIES
EMBARCADERO TECHNOLOGIES
21
“You’re Fired”
EMBARCADERO TECHNOLOGIES
22
Recoverability
EMBARCADERO TECHNOLOGIES
23
70% Small Firms done w/in 1yr (DT/PriceWaterHouse)
100% Of Drives Fail
50% Of Tape backups fail to restore(Gartner)
EMBARCADERO TECHNOLOGIES
Thinking of Backups
24
“How fast will backups be?”“Can I backup to this tape?”“Do We offsite the backups?”“What Kind of Backup?
EMBARCADERO TECHNOLOGIES
Thinking of Restores
25
“Restore Test Plan?”“Will that tape work in 6 yrs?”“How do we backup?”“What about x or y scenarios?”
EMBARCADERO TECHNOLOGIES
26
Who’s In Charge??
EMBARCADERO TECHNOLOGIES
27
Working To Set & Meet
Expectations
EMBARCADERO TECHNOLOGIES
Backing Up?
28
Agent Alerts Monitoring Tools SQL Scripts Just Do it!
EMBARCADERO TECHNOLOGIES
Homework
29
Verify you have backups!
Do a test restore (not in production)
Make sure you are on same page with
business around recovery goals.
EMBARCADERO TECHNOLOGIES
30
Security&
Auditability
EMBARCADERO TECHNOLOGIES
Get Auditable
31
Secure Your Environment Least Privilege Optimists Need Not Apply Write The Policies FOLLOW The Policies It’s Common Sense
EMBARCADERO TECHNOLOGIES
Security
32
Identify Threats
Make A Plan
Implement
EMBARCADERO TECHNOLOGIES
http://www.flickr.com/photos/andryone/120278573
EMBARCADERO TECHNOLOGIES
Wikimedia.org
EMBARCADERO TECHNOLOGIES
35
Least PrivilegeGroup BasedRole Based
EMBARCADERO TECHNOLOGIES
36
Least Privilege
EMBARCADERO TECHNOLOGIES
37
What is NECESSARY?
EMBARCADERO TECHNOLOGIES
38
What is NOT NECESSARY?
EMBARCADERO TECHNOLOGIES
39
Groups & Roles
EMBARCADERO TECHNOLOGIES
Homework
40
Figure out who is in the SA fixed server role and make sure it makes sense!
EMBARCADERO TECHNOLOGIES
41
Availability
EMBARCADERO TECHNOLOGIES
42
“Low” Availability
EMBARCADERO TECHNOLOGIES
Homework
Setup SQL Agent alerts.
Look at your error logs!
43
EMBARCADERO TECHNOLOGIES
44
High Availability
EMBARCADERO TECHNOLOGIES
Homework
Watch John’s intro video
45
EMBARCADERO TECHNOLOGIES
46
Reliability
EMBARCADERO TECHNOLOGIES
47
“HELP! We implemented this
project and….”
EMBARCADERO TECHNOLOGIES
48
UPDATE ProjectSET NeedDBA =1
WHERE Date < GETDATE()
EMBARCADERO TECHNOLOGIES
49
Vendor Interview
EMBARCADERO TECHNOLOGIES
Homework
Communicate!
Check out the vendor interview
Questionnaire
50
EMBARCADERO TECHNOLOGIES
51
“Performability”
EMBARCADERO TECHNOLOGIES
52
http://www.flickr.com/photos/wwworks/1384954600
EMBARCADERO TECHNOLOGIES
53 http://www.flickr.com/photos/hikingartist/3515471358/
EMBARCADERO TECHNOLOGIES
54
http://www.flickr.com/photos/rsgranne/179319967
EMBARCADERO TECHNOLOGIES
Homework
Take a baseline of your performance
55
EMBARCADERO TECHNOLOGIES
56
Recoverability
Reliability
Security & Auditability
Availability
Performability
EMBARCADERO TECHNOLOGIES
57
LinchpinPeople.com/where
EMBARCADERO TECHNOLOGIES
Coming This Spring…
• This generation will bring you 24x7 database monitoring and alerting that enables DBAs to analyze DBMS instances while staying abreast of customizable metrics and scripts.
58
EMBARCADERO TECHNOLOGIES
Thank you for attending!
Connect with us
59
Read Mike’s Blog
Community.embarcadero.com
Take our word for
it & try it out!
http://www.embarcadero.com/products/rapid-sql
Take our surveyLocated in the chat window
http://forms.embarcadero.com/OvercomingTopMistakesInField
Check out Mike’s recent webinar