FEB 2022 - How I Cut My Maintenance Plans by 80% by Paresh Motiwala

Abstract:

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 some of the best practices to help you cut down the maintenance window and give max downtime for your discerning customer.

Speaker Bio

Data Platform Manager Paresh Motiwala PMP; an Azure enthusiast, a Data Platform Manager (Boston)has led several large SQL implementations, migrations and upgrades. He was recently selected as a "Speaker Idol" finalist for the PASS Summit 2018. He has managed multi terabyte OLTP databases. He loves learning and talking about Big Data. He has also been a Senior SQL DBA 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 www.circlesofgrowth.com