July 28, 2015
SQL server DBA most popular guidelines for self-learner:
1. Database may be set up simple transaction log, so the database
can be fixed size; never worry about disk space;
2. Back up database every day; no pressure to work on live database
update; certainly, reduce risk to manual update record one by one instead of
update statement.
Also, the website to find the SQL performance script to do daily
monitor using database mail setup, so database disk space, backup log, auto
growth log, and all other activity can be helpful for every morning.
Here is her favorite site to get the SQL script:
Never too later to share her thoughts and great ideas with
outside world, also her first blog about SQL server DBA experience.
Valuable post useful for everyone.Keep on sharing.
ReplyDeleteFull Stack Online Training
Full Stack Training