Speaking on Streamlining SQL Server Implementations Across Organization – Silicon Valley!!

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

on 28th mar 2.00 pm pst, i will be speaking on “streamlining sql server implementations across organization)” @ sqlsaturday, silicon valley!!, 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.

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

Speaking on 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 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.

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

Webinar: Presenting to the PASS Database Administration Virtual Chapter

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!

event schedule

rsvp 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

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

PASS SQLSaturday – speaking on “Streamlining SQL Server Implementations across organization”

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 12th july 8.30 am, i will be speaking on “streamlining sql server implementations across organization”@ sqlsaturday, sacramento , 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.

location: patrick hays learning center, 2700 gateway oaks drive, suite 2600, sacramento, ca, 95833

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

SQL Server Implementation Frameworks From Dev to Prod

on 11th june 6.30 pm, i will be presenting “sql server implementation frameworks from dev to prod”@ at san francisco sql server user group, if you are in the area i hope to see you…

location:microsoft 835 market street, san francisco, ca

register here

session detail:
you’ll learn about a best practice framework that alleviates many of the pain points for deploying, managing, and supporting multiple sql server deployments from development to production.

there are many variables to consider when supporting sql servers in the real world, including:

• cloud systems (microsoft azure/amazon aws), virtualization (vmware/hyperv), physical servers

• different versions of sql servers, and different editions (standard/enterprise)

• service packs and specific hotfixes

• configuration differences based on os/memory/disk configuration

• different products need specific configurations and features of sql server

• post installation steps and default access

the best practice framework will get us past the complexities and provide us with the following capabilities and benefits:

• a process framework configured to support the above requirements

• flexibility to easily add new configurations

• a consistent experience to all environments, allowing users to do their implementations without having to worry about os, sql server, and access requirements

• every sql server installation can be configured in advance to use the best of os/disk/memory resources

• necessary features can be enabled in advance to provide optimum performance

• standard implementations simplify troubleshooting

• support for predefined os templates with disk configurations

• all necessary tools can be installed and configured for use in advance

Presenting “AlwaysOn Multisite Cluster Implementation In The Cloud”

on 8th jan 6.30 pm, i will be presenting “alwayson multisite cluster implementation in the cloud”@ at san francisco sql server user group, if you are in the area i hope to see you…

location:microsoft 835 market street, san francisco, ca

register here

session detail: your company is looking to move to the cloud and you have been asked to implement sql server alwayson across regions to meet optimum hadr strategy…

in this session i will walk you through the scenario based on my own experience implementing three node multi datacenter alwayson availability group implementations.

* session prerequisites: a basic understanding of sql server 2012 alwayson availability groups.

you’ll learn
1. how the highest availability requirement can be achieved by using sql server 2012 alwayson
2. constraints and criteria to consider during implementation including tde/filestream/backups due to alwayson
3. high level overview of alwayson automation using powershell