From the course: CompTIA Data Systems (DS0-001) Cert Prep

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Scripting

Scripting

From the course: CompTIA Data Systems (DS0-001) Cert Prep

Start my 1-month free trial Buy for my team

Scripting

“

- Database administrators can create time for higher value projects and tasks by using scripts to automate routine work. In addition to making time for other activities, automating maintenance improves consistency because scripts ensure that the tasks they perform happen the same way every time. When you're developing scripts for database operations, it's vital to consider where those scripts reside. Server-side scripts exist on the database server, but client-side scripts run from a computer other than the database server. Server-side and client-side scripts use resources differently. Server-side scripts consume resources on the database server, including CPU memory, and disc space. Scripts also generate database transactions that can impact database performance, mainly if the scripts are resource intensive or execute frequently. Since server-side scripts can compete with the database for resources on the server, minimizing their impact on the database is very important…

Contents