FEB 2022 - How I Cut My Maintenance Plans by 80% by Paresh Motiwala (@pareshmotiwala)
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
-
LIVE
LumpyPotatoX2
2 hours agoFortnite Friday on Rumble - #RumbleTakeover
477 watching -
LIVE
Mostly Sports With Mark Titus and Brandon Walker
11 hours agoMostly Sports With Mark Titus and Brandon Walker Presented by Jägermeister | EP 154 | 4.25.24
950 watching -
LIVE
Wendy Bell Radio
6 hours agoDonald Trump Is Winning Over America
11,266 watching -
2:43:04
Matt Kohrs
10 hours agoThe MK Show (April 26th)
13.1K4 -
2:05:06
AP4Liberty
3 hours agoAmericans Aren't Replacing Themselves
16.6K15 -
1:39:06
The Podcast of the Lotus Eaters
6 hours agoThe Podcast of the Lotus Eaters #902
28.5K15 -
1:05:27
TENET Media
16 hours ago🚨 Supreme Court Ready To NUKE Trump Criminal Cases! LIVE With Judge Matt Walsh Dropping The HAMMER
3.82K9 -
1:52
Memology 101
10 hours agoAustralian Senator's OBSESSION to see Elon Musk JAILED for standing up against censorship CONTINUES
2.07K35 -
10:12
America Uncovered
13 hours agoThe Real Reason NPR Crushed Uri Berliner
3.38K3 -
54:24
Thrivetime Show: The ReAwakening versus The Great Reset
21 hours agoEntrepreneur | Part 2 - Start Here - The 19 Step Guide To Becoming Wealthy With Tim Redmond
5.2K