common sql server dba tasks
just for remind me about dba tasks. as an sql server dba (not yet for me), a dba can expect to be involved in the following tasks:
■ installing sql server software
■ creating sql server databases
■ performing upgrades of the database and software to new release levels
■ starting up and shutting down the database
■ managing the database’s storage structures
■ managing users and security
■ managing schema objects, such as tables, indexes, and views
■ making database backups and performing recovery when necessary
■ proactively monitoring the database’s health and taking preventive or corrective action as required
■ monitoring and tuning performance
in a small to midsize database environment, it might be the sole person performing these tasks. in large, enterprise environments, the job is often divided among several DBAs, each with their own specialty, such as database security or database tuning. so, what about my specialty? :lol: