Tuesday, July 28, 2015

SQL Server DBA, database design, and development

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.

1 comment: