PHOTO CREDIT: Pat Wright

 

 

PASS Summit 2011 Sessions

You can browse all sessions or use filters to search for sessions you are interested in. The Keyword filter lets you enter a term to search for in the session title or abstract. The Category drop-down lets you set the session type (such as Regular session), and the Track drop-down lets you specify which topic track you want to search. You can also filter by speaker name and session skill level. To start a new search or return to the list of all sessions, simply click the Clear button.
Keyword:
Category:
Track:
Speaker:
Level:
Page:  of 3  | [PREVIOUS]  
Sessions Found: 28
Performance Tuning Made Easy [200]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Thomas LaRock
Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

Performance Tuning Made Easy [200]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Thomas LaRock
Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

Scaling SQL Server [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Glenn Berry
How can you scale SQL Server? Scaling up is relatively easy (but can be expensive), while scaling out requires significant engineering time and effort. If you suggest hardware upgrades you may be accused of simply "throwing hardware at the problem", and if you try to scale out, you may be thwarted by a lack of development resources or 3rd party software restrictions. As your database server nears its load capacity, what can you do? This session gives you concrete, practical advice on how to deal with this situation. Starting with your present workload, configuration and hardware, we will explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we will
cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.


Scaling SQL Server [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Glenn Berry
How can you scale SQL Server? Scaling up is relatively easy (but can be expensive), while scaling out requires significant engineering time and effort. If you suggest hardware upgrades you may be accused of simply "throwing hardware at the problem", and if you try to scale out, you may be thwarted by a lack of development resources or 3rd party software restrictions. As your database server nears its load capacity, what can you do? This session gives you concrete, practical advice on how to deal with this situation. Starting with your present workload, configuration and hardware, we will explore how to find and alleviate bottlenecks, whether they are workload related, configuration related, or hardware related. Next, we will
cover how you can decide whether you should scale up or scale out your data tier. Once that decision is made, you will learn how to scale up properly, with nearly zero down-time. If you decide to scale out, you will learn about practical, production-ready techniques such as vertical partitioning, horizontal partitioning, and data dependent routing. We will also cover how to use middle-tier caching and other application techniques to increase your overall scalability.


SQL Server Utility Dos and Don'ts [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Julie Koesmarno, Victor Isakov
As a Developers, we often neglect or leave the performance of SQL Server Environment to the DBAs. You may also be new SQL DBAs who are eager to make the best of database servers with out of the box SQL Server Utility that comes out of the box in SQL Server 2008 R2, instead of using third party tools. In this session, you will learn how to best use SQL Server Utility in your day to day life as both pro-active Developers or efficient DBAs. Julie Koesmarno (MCITP) and Victor Isakov (MCA, MCM, MCT, MVP) will provide insights on best practices in using SQL Server Utility and the “Dos and Don’ts” on this feature of SQL Server 2008 R2.

Storage Triage: Why Your Drives Are Slow [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Brent Ozar
Storage pain is like chest pain: maybe it's about to kill you, or maybe you just need antacid. Microsoft Certified Master and storage specialist Brent Ozar will cover the decision tree he uses to diagnose storage pains and show some easy remedies.

Windows Failover Clustering for the DBA [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Allan Hirt
While there are numerous resources to show you how to run through SQL Server Setup to deploy a clustered SQL Server instance, the most important thing DBAs must understand about the clustering process is absent: how to plan, deploy, and administer the underlying Windows failover cluster. It may be some other person's job in your company to do this task, but it can make or break your installations. Starting from the ground up, this session is designed to get DBAs up to speed on all of the underlying components and concepts that will affect the performance, security, availability, and stability of their clustered SQL Server deployments up through SQL Server Denali. In addition to understanding and planning, how to properly administer and troubleshoot a Windows failover cluster from a SQL Server perspective will be covered. Did you ever want to know how to properly use the PowerShell cmdlets in Windows Server 2008 R2? Have a question on how to properly deploy DTC with Windows Server 2008 or Windows Server 2008 R2? Do you want to know how to properly configure Kerberos for clustered instances? Want to learn how to approach troubleshooting? Do you want to know why mount points matter and why things like CNOs and VCOs matter (and how to deal with them in different OUs)? These are just some of the questions that will be answered to help you demystify the Windows portion of clustering. Most things discussed will be demonstrated live.


Storage Strategies: SQL Azure and Azure Storage [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: SQL Azure
Speaker(s): Nuno Godinho
In this session we'll look at how different problems can have different storages associated, and see when and how SQL Azure, and Windows Azure Storage can be used, in order to scale and also scale in terms of costs, since that is very important also.


Page:  of 3  | [PREVIOUS]  

 

 
 

Why Attend?


■ All SQL Server. All the time

■ Over 170 technical sessions

■ Dr. David DeWitt Keynote

■ 2 days of Pre-Con Seminars

■ Networking with MVPs, experts, and peers

■ Face-to-face support with     Microsoft CSS and SQLCAT

■ Ask the Experts Pods
 

 
 
 

 

 

 


Premier Sponsor

 

Platinum Sponsor