The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Fine Tuning Your Maintenance Plans

Wed, Jan 24 2018 17:00 UTC

Fine Tuning Your Maintenance Plans

As DBAs, we are in charge of the safety and security of our databases. Backup and ability to restore in a timely fashion is one of the most important responsibility. There are many tools available in the market in addition to Microsoft's own Maintenance Plan builder and Ola Hallengren's awesome scripts. But is this where it should end for a mortal DBA? Possibly yes: if you are new to the whole DBA game, or if you think you are a DBA this is far from the truth. In this session, we will cover some of my own experiments, with supporting data, to minimize your downtime for backups and restores. The other major responsibility for us is to maintain performance of the databases and their integrity. We'll also show some of the best practices to help you cut down the maintenance window and give min downtime for your discerning customer.

Paresh Motiwala

Paresh Motiwala, PMP; an Azure enthusiast and a DBA Manager at Nuance Corp (Boston). He has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He loves learning and talking about Big Data. He has also been a DBA manager and a Solutions Architect in Fortune 100 companies. He also helps organizing / and speaks at many SQL Saturdays, Azure Bootcamp and User Groups. He is a certified in Big Data Analytics and FinTech(MIT) Project manager, public speaker, an avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills. He also mentors DBAs in Boston area; and children around the globe via

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top