nurture.solarwinds.com Open in urlscan Pro
52.71.166.211  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Thumbnails Document Outline Attachments


Previous

Next
Highlight all Match case
Whole words

Presentation Mode Open Print Download Current View

Go to First Page Go to Last Page

Rotate Clockwise Rotate Counterclockwise

Text Selection Tool Hand Tool

Vertical Scrolling Horizontal Scrolling Wrapped Scrolling

No Spreads Odd Spreads Even Spreads

Document Properties…
Toggle Sidebar

Find
Previous

Next
of 7
Presentation Mode Open Print Download Current View

Tools
Zoom Out

Zoom In
Automatic Zoom Actual Size Page Fit Page Width 50% 75% 100% 125% 150% 200% 300%
400%

page 1WHITEPAPERby Pinal DaveZero to Hero — 12 Essential Tips for the Accidental
DBA

page 2 A DBA’s job can seem thankless, and DBAs can feel underappreciated
because the work they do isn’t always visible. But when application performance
slows, and the database is being blamed, the work they do to keep the business
up and running is quite evident. At the most basic level, a DBA must keep
critical systems up and running 24/7. A DBA needs to make sure there is a proper
strategy to bring up the environments when things go wrong inside your
datacenter. For many organizations, such as independent software vendors (ISVs),
it can be difficult to justify a dedicated DBA. Instead, these organizations
give database administration responsibili-ties to senior developers, making them
part-time DBAs. These part-time or “accidental” DBAs—IT professionals who have
had to take on the responsibilities of database administration—need guidance and
education.This paper is for the accidental DBA and contains 12 essential tips
for working with SQL Server®. These simple, yet powerful tips are filled with
lessons learned on the front lines and from years of database administration
experience. Following these tips can help transform the accidental DBA into an
organized DBA with clear direction for better database performance.KNOW YOUR
BACKUP REQUIREMENTSPerforming backups is a primary activity for DBAs, and all
DBAs should be proficient at it. In my interactions with DBAs over the years, I
always ask, “How easy is it to take a backup inside SQL Server?” Some of the
answers I get are shocking. Once, a DBA answered, “I can take backups inside SQL
Server without touching the keyboard, but using just the mouse.” Thinking
deeper, I can always say there is something about SQL Server that makes even
developers working as a DBA shine—it’s called simplicity in complexity.The point
here is not about how you do backups, but about understanding how critical
backups are to the business. Always start with basic business requirements. What
are the recovery point objective (RPO) and recovery time objective (RTO)
requirements of your teams? Based on your understanding of the business
requirements, you should decide the frequency and type of the backups that need
to be taken. It is important to understand the different types of backups and
how they function before preparing your backup plan.KNOW YOUR SQL SERVER ERROR
LOGSKnow your SQL Server instances and the number of instances that are running
inside a single server box. Whenever you encounter an error or an unexpected
behavior inside SQL Server, the first thing you should do is look into the SQL
Server error logs.Zero to Hero — 12 Essential Tips for the Accidental DBA






More Information Less Information
Close


Enter the password to open this PDF file.


Cancel OK
File name:

-

File size:

-


Title:

-

Author:

-

Subject:

-

Keywords:

-

Creation Date:

-

Modification Date:

-

Creator:

-


PDF Producer:

-

PDF Version:

-

Page Count:

-

Page Size:

-


Fast Web View:

-

Close
Preparing document for printing…
0%
Cancel


This site uses cookies to provide a personalized content experience and track
visitor engagement.

Learn More
AcceptDecline
Next 
Next 

SolarWinds Database Performance Analyzer Workload Optimization
See how DPA can help you find, analyze, and optimize with the new Table Tuning
Advisors feature.
START FREE TRIAL
Zero to Hero: 12 Essential Tips for the Accidental DBApdf
SolarWinds Database Performance Analyzer Workload Optimizationwebpage
Optimizing Your Index Strategypdf
Case Study: Slow is the New Downpdf
Find, Analyze and Optimize SQL Server Performance with DPAwebpage
Find Your Best Database Tuning and Optimizing Opportunities!webpage
Best SQL Query Optimizer Tools & Software for Optimizing DB's in 2018webpage



FREE TRIAL OF DATABASE PERFORMANCE ANALYZER.