Next Meeting: Fri, Mar 13 2015
Event Type: In-Person
Online Meeting URL: None
March UG Meeting
UTC : Fri, Mar 13 2015 17:30 - 19:00
Event Time : Fri, Mar 13 2015 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Mar 13 2015 17:30 - 19:00
5100 Masthead St NE
Albuquerque, New Mexico
Ola Hallengren's Maintence Solution
Glen Schwickerath, DBA .
A crucial function of an operational DBA is to establish and maintain comprehensive maintenance procedures for each SQL Server machine in a company's IT environment. Often, these routines are created and maintained in an ad-hoc, non-standardized approach. Ola Hallengren has developed and maintained a standardized set of routines for backup, integrity checking, and index tuning which are easy to install/configure, yet are highly customizable to fit individual SQL environments. His solution is freely available, is utilized at numerous Fortune 500 companies, and has been awarded recognition as a SQL Server Community Choice Gold winner. The presentation will provide a brief tutorial on installation and configuration.
Glen is a Sr. SQL DBA with over 20 years of experience and a Bachelors in Computer Science. Glen has in-depth experience in database design and management, data warehouse design and development of MS SQL Server databases through 2012. Glen recently relocated here from the Minneapolis area and is currently working at New Mexico Student Loans as a SQL DBA. He has worked in enterprise environments with databases in the terabyte size supporting thousands of applications and processes. He is also well versed in SSIS, SSRS, ETL, and high level SQL development.