Overtaxed IT departments and increased collaboration between IT departments are bringing the heat onto DBAs and Developers, forcing them to find ways to be ever more productive and efficient. Tools that simplify and automate once-manual, laborious tasks can have a profound impact on a DBA’s effectiveness. This paper examines how some key tools within the Embarcadero All-Access suite, including Rapid SQL, DB Change Manager and DB Optimizer, help DBAs and database developers to handle expanding workloads and increase their value to busy IT organizations.

This paper takes a look at a day in the life of a typical multi-tasking DBA working for an organization, and examines some of the tools and best practices he can use to be more productive and efficient in completing essential tasks.