Re-Indexing – The quest of ultimate automation

In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

on 27th sep 03.15 pm est, i will be speaking on “re-indexing – the quest of ultimate automation”@ sqlsaturday, orlando, if you are in the area i hope to see you…

pass sqlsaturday’s are free 1-day training events for sql server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. whether you’re attending a sqlsaturday or thinking about hosting your own, i think you’ll find it’s a great way to spend a saturday – or any day.

event schedule

session details

register here

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 stop itself beyond a threshold
5. can be implemented across all sql servers regardless of application type or data size

in this session, prakash will walk you through design considerations, accompanied with a script demo using powershell to generate a dynamic re-indexing script , created based on his real-life experience from managing high performing database systems.

Standardize SQL Server Implementations (Dev to Prod)

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

on 20th sep 10.00 am, i will be speaking on “standardize sql server implementations (dev to prod)”@ sqlsaturday, san diego, if you are in the area i hope to see you…

pass sqlsaturday’s are free 1-day training events for sql server professionals that focus on local speakers, providing a variety of high-quality technical sessions, and making it all happen through the efforts of volunteers. whether you’re attending a sqlsaturday or thinking about hosting your own, i think you’ll find it’s a great way to spend a saturday – or any day.

event schedule

session details

register here

you will learn…

• a process which help configure sql servers with optimal performance considerations

• consistent sql support env’s help improve dba productivity and reduce production issues

• configuration changes to be requested from windows admin/ network admin/ storage admin to be planned in advance

• flexibility to easily add new sql configurations to support new applications