Daily maintenance,
Back up and restore
Maintenance plan,
Disaster recovery.
Automating back up jobs
TSQL statements
Traits of an Excellent DBA
Consistence practices and figure out the problem, find a
solution and create an awareness that it won’t happen again.
For practice download
SQl server Evaluation edition ; Free
SQL server Development edition ; $45.00
Learn the core DBA stuffs such as:
Setting a database recovery model
Take back ups, full, differential, transaction log and tail log back up
Restore Database such as full restore and point in time restore
Setting up SQL agent
jobs like
Automating the back up
Checking for corruption
Index/ update statistics maintenance
Create a test environment to practice them.
Self trained and tested, (have someone to quiz you on each
area)
Invest time in practicing core DBA skills, when u don’t have
the work experience.
Search for job @ Career.stackoverflow.com
SQlpass.org
SQl Saturday.com
Brent ozar
