Next Meeting: Wed, Jul 13 2016
JSSUG Monthly Meeting - July 13, 2016
Event Type: In-Person
Online Meeting URL: None
Regular Monthly Meeting
UTC : Wed, Jul 13 2016 22:00 - 00:00
Event Time : Wed, Jul 13 2016 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Wed, Jul 13 2016 22:00 - 00:00
6430 Southpoint Pkwy
Designing Amazingly Robust Maintenance Plans with Ola Hallengren’s Free Scripts
Troy Gallant, SQL Server DBA
Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.
In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.
Troy has been a SQL Server professional for over 15 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQL Saturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.