Tampa SQL User Groups are comprised of two groups that operate in close concert on either side of the bay.
• Pinellas SQL User Group - Meets the 3rd Tuesday of every month near Ulmterton & US-19.
• Hillsborough SQL User Group - Meets the last Thursday of every month near the Tampa airport.
Each group is an individual Chapter of PASS (Professional Association of SQL Server - pass.org (https://www.sqlpass.org)), which is a global community of over 250,000 like-minded data professionals who leverage the Microsoft Data Platform. Becoming a member unlocks incredible year-round learning and professional development opportunities, virtual webinars, in-person networking, and mentorship such as our local meetups.
Membership is free to both the local and the international organization.
Mike Keleher presents:
Title: Finally, A script that predicts the future
Subtitle: Estimating Filegrowths resulting from index operations
Abstract: 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.