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 1st nov 4.30 pm pst, i will be speaking on “standardize sql server implementations (dev to prod)”@ sqlsaturday, oregon, 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 and sponsors. 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.
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
In this Webinar, 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.
webinar: on 22nd oct 09.00 pm pst, i will be speaking on “re-indexing – the quest of ultimate automation – sponsored by dell software”, if you are interested i hope to see you join…
pass virtual chapter: if you aren’t a member of/or familiar with pass it is the professional association for sql server. pass put’s together great things for us throughout the year like sql saturdays, the pass summit, 24 hours of pass (free 12 spans of great training), and the pass virtual chapters. virtual chapters range 16 different subjects and 3 different languages, soon to be four different languages!
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