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 28  |   [NEXT]
Sessions Found: 278
The Road Not Taken—How Software Companies Design Applications for Paying Customers [200]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Henry Treftz
Imagine that you are sitting in front of a newly installed third-party application that uses SQL Server. With great anticipation, you start using the application. Then shortly into your new application adventure, you either smile in amazement or sigh with disgust. You exclaim, “Why does this application do things on the SQL Server this way?” What determines whether a third-party application that uses SQL Server is successful? Many factors determine how applications and data models are designed, coded, and implemented. Some elements are common to most development projects. Other considerations are unique to the application. This presentation has three main objectives: 1) explain why vendors make the design, coding, and implementation decisions that they do; 2) discuss how to make third-party applications run better in your environment; and 3) teach design and decision-making principles that will advance your development projects.

SQLCAT: SQL Server in Hyper-V in Consolidated Environments – Achieving HA/DR and Making the Most of Hardware Resources [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Mike Ruthruff, Ayad Shammout, Prem Mehra, Sanjay Mishra
This session will cover why HA and DR are important to Hyper-V Consolidated environments. What considerations customers use to pick the right HA/DR solution and what unique considerations does this impose on hardware configuration (disk, network, memory, …) for virtualized SQL Server deployments. Techniques include Live Migration, Host Clustering, Guest Clustering, Database Mirroring, and Denali AlwaysOn technologies and how to maintain uptime during planned and unplanned events. In addition, we will discuss how to leverage Hyper-V Dynamic Memory (new to Windows 2008 R2 SP1) to gain more efficient and full use of hardware resources as well as the unique considerations that dynamic memory introduces for planned maintenance and unplanned outages. Actual customer deployment architectures, deployments considerations, lessons learned and best practices will be discussed.

"And Then It Got Even Worse"... Great Mistakes to Learn From [200]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Kendra Little, Brent Ozar, Jeremiah Peschka, Tim Ford
We've been there went things went from bad to worse--- and then things just kept going. Brent Ozar, Jeremiah Peschka, Kendra Little and Tim Ford share stories of human error, machine failure, and how you can stop a bad situation from spinning out of control. There's no teacher like experience; but the best trick is to learn from someone else's (barely contained) disaster.

10 Things I Wish I Knew Then [100]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Chris Shaw
From whitepapers that are a must read to learning from my mistakes. These are the top 10 pieces of information I would pass along to new SQL Server Professionals.

100% Availability without 100% Uptime [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Thomas Grohser
Global operating websites and enterprises all face the same problem: Maintenance windows get smaller and smaller every year and the requirements for availability go up the same time. This session shows how to create a SQL Server infrastructure that will solve both problems at the same time. After a short explanation of the theory behind the concept you will learn how to create the infrastructure and most importantly how to store your data on it in a way that enables 100% availability and gives you 24 hours of maintenance every day.

24 A 5 Minute Horror Story [100]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Bradley Ball
It’s Fathers Day 12 am, within the next 24 hours you will find out you had a server that you didn’t know about, that isn’t being backed up, that has a raid controller go bad, has the wrong disk in a mirroring set pulled loosing half of your transaction logs. Think it can’t get worse toss in some Master Corruption, and we’ll have you screaming for your backups!

A Data Center Migration Story [100]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Dale Hughes
This is a lessons learned tale of how log shipping was used for migration of databases housed in SQL2000, SQL2005, and SQL2008 across the country from one data center to another. The presentation will focus on the hurdles that were encountered during the migration, and the solutions that were implemented to overcome them. At the end of the presentation, attendees will have a better understanding about things to consider when deploying the log shipping methodology in their real world environment.

A DBAs Guide to Administering BI Systems [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Robert Davis
It seems like everyone wants to talk about how to administer OLTP SQL Servers, and all BI discussions are limited to development and architecture topics. As a result, BI Administration experts are hard to find or almost nonexistent.

Did you know that SSAS has DMVs? They do!! Did you know that you can run a SQL Trace on SSAS using an XMLA script? You can!! Did you know that you can backup, detach, restore, and attach SSAS databases and cubes? You can!!!

This session will be an introduction to administrative practices for BI systems. Topics covered include:

1. Diagnosing SSAS problems with dynamic management views
2. Investigating SSAS issues using SQL Trace
3. Maintaining SSAS cubes and databases
4. Best practices for configuring SSAS and SSIS for maximum performance
5. Providing High Availability for SSAS and SSIS


A Medical Approach to Performance Tuning [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Robert Davis
Have you ever had a performance problem that had no evident cause? Have you ever asked for help with a performance issue and been offered a flurry of potential solutions and been left without an understanding of what you are being told to try?

Performance tuning is both a science and an art. SQL Server performance is mission critical and does not lend itself well to trial and error. In this session, you will learn to take a medical approach to performance tuning.

A medical approach to performance tuning is about proper diagnosis of performance problems, identification of true root cause, and surgical implementation of real solutions.

This session will cover the following topics:

1. Baselining - on-going monitoring of SQL Server performance to understand what "normal" looks like and identify hidden problems before the end-user notices.

2. Monitoring - detect changes in the health of your SQL Server that may indicate performance issues that have not yet shown themselves.

3. Troubleshooting - identify root cause for emergent performance problems and implement appropriate change to address the real issues.


A PowerShell Cookbook for DBAs [100]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Trevor Barkhouse
This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008/2008R2. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.


Page:  of 28  |   [NEXT]

 

 
 

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