Tampa SQL User Groups

Michael Keleher presents: Finally, A script that predicts the future... . . . Estimating Filegrowths resulting from index operations Have you ever come into the office after the index rebuild jobs only to find that your data drives have been run out of space? You can build scripts to simulate the file growth that will occur as a result of the index rebuilds for all databases on an instance and cross apply it to the drives and mount points on your systems to predict which servers are at risk of running out of disk space on the drives. The purpose of this presentation is to share all of the information you will need to build a script that will allow you to avoid data drive issues. Even if you are not a Database Administrator, you will learn more about the internals of indexing in SQL Server to help identify and resolve performance issues. About Michael: Michael Keleher is a Microsoft Certified Professional and is currently the Database Administrator at Bisk Education, Inc in Tampa, Florida. He has over twenty years of experience working in all areas of the Software Development Life Cycle plus another three as a Database Administrator. He enjoys getting involved in security and performance tuning projects. • What to bring Food will be provided, bring your appetite for food, and knowledge! • Important to know Plan on joining us for the meeting after the meeting at Kona Grill for more casual networking.