The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Re-Indexing – The quest of ultimate automation – sponsored by Dell Software

Wed, Oct 22 2014 16:00 UTC

Re-Indexing – The quest of ultimate automation – sponsored by Dell Software

How many times you have been called on weekends to handle a nightmare caused by Re-Indexing job? One of the most common aspects of performance tuning is a well-design dynamic index optimization process. In this session, Prakash will walk you through what it takes to re-design existing re-indexing process which takes it to the next level, created based on his real-life experience from managing high performing database systems. You will learn a dynamic index optimization process which… 1. Do selective re-indexing 2. Handles blocking efficiently 3. Avoid system downtime due to log disk full 4. Automatically stops itself beyond a threshold 5. Can be implemented across all SQL servers regardless of application type or data size


Prakash Heda

Prakash Heda works as Manager (Data-IT) at SS&C Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, dbavolunteer@sqlpass.org.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, dbavolunteer@sqlpass.org if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley, dbavolunteer@sqlpass.org.

 

Meeting Recordings

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Chapter holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids