location:
washington state university vancouver
14204 ne salmon creek ave
vancouver, washington, 98686, united states

sqlsaturday-portland 2016

register here

download scripts from github

session evaluation

session detail:
a performance health check is the key in responding quickly to production issues. it can cut the initial evaluation phase significantly, whether someone has requested a health check or you run one due to an alert. these essential checks can be the first major checkpoint for a dba, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. this will cut down on time and effort while responding to production issues.

prakash will share some key observations about sql server performance which can be the key to quick resolution of issues. rest of the email shows different set of stats regarding cpu/disk io/disk space/memory/network/blocking and database performance which could lead to the slowness observed in the application. this consolidated email can be shared with technical stakeholders to give a snapshot of dba efforts and it adds transparency to the health check process. prakash will walk you through a centralized process using powershell where the key information collected, organized and sent via html formatted email, provides consolidated view of sql server along with key observations which dba should verify and share with it stakeholders for increasing transparency and improved efficiency.

this session is good for dbas and technical folks who without having dba knowledge would like to take a quick look at the sql server’s performance matrix.

you’ll learn:

• an essential matrix to evaluate sql server performance quickly which can rule out or confirm if any further action is required

• consolidated and standardized view of essential performance stats of sql server is helpful for dba to quickly analyze a sql server and other technical stake holders like server/storage team/client support/ application team

• about a customizable powershell script which can be run from central sql server or desktop which has sysadmin access to sql server and supports sql 2008 to 2016 sql servers

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

sqlsaturday-sacramento 2016

register here

download scripts from github

session evaluation

session detail:
a performance health check is the key in responding quickly to production issues. it can cut the initial evaluation phase significantly, whether someone has requested a health check or you run one due to an alert. these essential checks can be the first major checkpoint for a dba, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. this will cut down on time and effort while responding to production issues.

prakash will share some key observations about sql server performance which can be the key to quick resolution of issues. rest of the email shows different set of stats regarding cpu/disk io/disk space/memory/network/blocking and database performance which could lead to the slowness observed in the application. this consolidated email can be shared with technical stakeholders to give a snapshot of dba efforts and it adds transparency to the health check process. prakash will walk you through a centralized process using powershell where the key information collected, organized and sent via html formatted email, provides consolidated view of sql server along with key observations which dba should verify and share with it stakeholders for increasing transparency and improved efficiency.

this session is good for dbas and technical folks who without having dba knowledge would like to take a quick look at the sql server’s performance matrix.

you’ll learn:

• an essential matrix to evaluate sql server performance quickly which can rule out or confirm if any further action is required

• consolidated and standardized view of essential performance stats of sql server is helpful for dba to quickly analyze a sql server and other technical stake holders like server/storage team/client support/ application team

• about a customizable powershell script which can be run from central sql server or desktop which has sysadmin access to sql server and supports sql 2008 to 2016 sql servers

location: microsoft reactor, 680 folsom street , san francisco, ca

san francisco data platform user group – june 08 2015

register here

download scripts from github

session evaluation

session detail:
a performance health check is the key in responding quickly to production issues. it can cut the initial evaluation phase significantly, whether someone has requested a health check or you run one due to an alert. these essential checks can be the first major checkpoint for a dba, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. this will cut down on time and effort while responding to production issues.

prakash will share some key observations about sql server performance which can be the key to quick resolution of issues. rest of the email shows different set of stats regarding cpu/disk io/disk space/memory/network/blocking and database performance which could lead to the slowness observed in the application. this consolidated email can be shared with technical stakeholders to give a snapshot of dba efforts and it adds transparency to the health check process. prakash will walk you through a centralized process using powershell where the key information collected, organized and sent via html formatted email, provides consolidated view of sql server along with key observations which dba should verify and share with it stakeholders for increasing transparency and improved efficiency.

this session is good for dbas and technical folks who without having dba knowledge would like to take a quick look at the sql server’s matrix.

you’ll learn:

• an essential matrix to evaluate sql server performance quickly which can rule out or confirm if any further action is required

• consolidated and standardized view of essential performance stats of sql server is helpful for dba to quickly analyze a sql server and other technical stake holders like server/storage team/client support/ application team

• about a customizable powershell script which can be run from central sql server or desktop which has sysadmin access to sql server and supports sql 2008 to 2016 sql servers

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.

sqlsaturday – silicon valley – 09 apr 2016

event schedule

session: detect worst performing sql queries during peak hour

register here

session feedback

scripts repository – github

session detail:

how many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? where do you start tuning? when do you stop tuning? each application is different. with the ever increasing number of systems one production dba has to manage today, it’s very important to use top to bottom approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

while you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour in current situation without using profiler or causing any additional load on system? now you can focus on those specific queries!

in these 60 minutes, prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on cpu/disk/memory/network. they are all based on his own real-life experience from managing demanding database systems.

you’ll learn how to:

• detect worst performing sql queries which slows down microsoft sql server performance without using profiler

• key dmvs used to detect worst performing queries, along with various type of information available for those queries

• investigation workflow with which you will be able to pin point a specific stored procedure/query that is the cause of the performance problem faced.

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.

sqlsaturday – portland – 24 oct 2015

event schedule

session: detect worst performing sql queries during peak hour

register here

session feedback

scripts repository – github

session detail:

how many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? where do you start tuning? when do you stop tuning? each application is different. with the ever increasing number of systems one production dba has to manage today, it’s very important to use top to bottom approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

while you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour in current situation without using profiler or causing any additional load on system? now you can focus on those specific queries!

in these 60 minutes, prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on cpu/disk/memory/network. they are all based on his own real-life experience from managing demanding database systems.

you’ll learn how to:

• detect worst performing sql queries which slows down microsoft sql server performance without using profiler

• key dmvs used to detect worst performing queries, along with various type of information available for those queries

• investigation workflow with which you will be able to pin point a specific stored procedure/query that is the cause of the performance problem faced.

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.

sqlsaturday – orlando – 10 oct 2015

event schedule

session: detect worst performing sql queries during peak hour

register here

session feedback

scripts repository – github

session detail:

how many times you have been thrown in a situation when you have been asked to fix performance issues of a database system which you have never seen before? where do you start tuning? when do you stop tuning? each application is different. with the ever increasing number of systems one production dba has to manage today, it’s very important to use top to bottom approach to troubleshoot performance issues, which will lead to the answers in the right way for the application under consideration.

while you can find top queries, wouldn’t it be awesome if you can find out which ones are the exact queries taking most of the resources in last hour in current situation without using profiler or causing any additional load on system? now you can focus on those specific queries!

in these 60 minutes, prakash walks you through with scenario & demos to find which exact queries are taxing production systems resources based on cpu/disk/memory/network. they are all based on his own real-life experience from managing demanding database systems.

you’ll learn how to:

• detect worst performing sql queries which slows down microsoft sql server performance without using profiler

• key dmvs used to detect worst performing queries, along with various type of information available for those queries

• investigation workflow with which you will be able to pin point a specific stored procedure/query that is the cause of the performance problem faced.

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.

sqlsaturday – san diego – 19 sep 2015

event schedule

universal sql installations – part 1 (10 am to 11 am)
universal sql installations – script review & demo (11:15 am to 12:15 pm)

register here

session feedback

scripts repository – github

session detail:

i will show you how to do multiple versions of sql server installations using single scripts with all best practices baked in, this session will first discuss process framework, prerequisites and then followed up with script review and live demo of installing diff version of sql servers along with diff os using single line command which ensure environment consistency and optimal performance across dev/stage/qa/production.

you’ll take-away script to install different versions of sql server on diff os systems with utmost ease. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined and with a single line command can install any of the below combinations:

• windows 2008r2/2012/2012r2

• sql 2016ctp2.3/2014/2012/2008r2 (enterprise/standard/developer editions)

• any sql service pack/ cumulative updates / hotfix combination

• vmware/hyper-v/azure vm/aws ec2/physical servers

• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:

• install different versions of sql server on supported os systems, and readymade scripts to do so

• install sql server systems following best practices and new default which makes more sense

• ensure consistent sql server support environments help improve dba productivity and reduce production issues

• easily add new sql server configurations to support new applications and new versions of sql servers

• identify support situations where different types of applications need dedicated sql servers

• ensure perfect consistency across dev/qa/stage/production env and assure developers of the same

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.

sqlsaturday – sacramento – july 2015

event schedule

session details

register here

session detail:

this session is mostly demo-focused. i will cover prerequisites for scripts and show how to do multiple sql server installations using scripts and demonstrate how to streamline sql server implementations. check the presentation above for describing process…

you’ll take-away script to install different versions of sql server on supported os systems. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined.

you’ll see powershell scripts where a single line script can install any of these combinations:

• windows 2008r2/2012/2012r2

• sql 2014/2012/2008r2 (enterprise/standard/developer editions)

• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:

• install different versions of sql server on supported os systems, and receive the scripts to do so

• install sql server systems following best practices

• ensure consistent sql server support environments help improve dba productivity and reduce production issues

• easily add new sql server configurations to support new applications and new versions of sql servers

• identify support situations where different types of applications need dedicated sql servers

session evaluation

uploading presentation dac and scripts for today’s session….

scripts:

to save right click on links and choose “save target as”

please update in comments if you see any issue with script…

location: microsoft, 555 california st, san francisco, ca

the san francisco sql server user group – may 13 2015

register here

session detail:
this session is mostly demo-focused. i will cover prerequisites for scripts and show how to do multiple sql server installations using scripts and demonstrate how to streamline sql server implementations. check the presentation above for describing process…

you’ll take-away script to install different versions of sql server on supported os systems. this script allows anyone in it to install sql systems with best practices baked into it which ensure all sql installation can be streamlined.

you’ll see powershell scripts where a single line script can install any of these combinations:
• windows 2008r2/2012/2012r2
• sql 2014/2012/2008r2 (enterprise/standard/developer editions)
• implement best practices and configuration based on available resources for dedicated sql server environments

you’ll learn how to:
• install different versions of sql server on supported os systems, and receive the scripts to do so
• install sql server systems following best practices
• ensure consistent sql server support environments help improve dba productivity and reduce production issues
• easily add new sql server configurations to support new applications and new versions of sql servers
• identify support situations where different types of applications need dedicated sql servers