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  | [PREVIOUS]  [NEXT]
Sessions Found: 278
Absolutely, It Depends [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Cindy Gross
Everyone wants the one right answer, the true “best practice” they can enforce on every instance. But we also know it doesn’t exist. Everything in the IT world has an “it depends” as the true answer. We’ll explore how to determine the “right” settings for MAXDOP and memory, how many VLFs is too many, how to determine your autogrow settings, when to shrink, and much, much more!

Advanced Backup & Restoring Techniques [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Andreas Wolter
While the wizards help to get started, they fail to be sufficient if the data volumes become larger, and the restore objectives shorter.
In This session we will go further and see how we can save valuable restore time when the right backup technique has been used and how the physical database design influences your possibilities. You will take out best practices as well insights on how backup & restore works under the cover, all for just one goal: to not lose data by all means possible, and to get the system back running.


Advanced SQL Server 2008 Troubleshooting [400]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Klaus Aschenbrenner
It's Friday, 05:00pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast? Which tools provides you SQL Server for this task? In this session you will see a lot of different tools with which you can do effective SQL Server troubleshooting. You will learn how to identify performance bottlenecks with those tools, and how to resolve the identified bottlenecks.

Alerting with WMI in under 10 minutes [100]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Neil Hambly
Discover how with only 10 minutes, we can equip a SQL Server with critical alert capability using WMI events & SQL Agent

We will demostrate this with a quick demo, capturing Deadlock Graphs for further analysis and 2nd demo showing the different notification options and take a peek @ severity levels


All about Execution Plans Operators [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Fabiano Neves Amorim
Understand how to analyze Execution Plans is the key of every query tuning. To be able to understand it in a level of know if the created execution plan is really the best option to read the data, you have to understand what the execution plan is doing.
How this operator works? Are these operators really necessary? Can I improve it?
Using as reference the epic Simple-Talk articles “Operator of the Week”, these are questions that Fabiano Amorim will answer in this session.
After this, you will understand a bunch of operators and important aspects about them.
Spools (Eager, Lazy, Index, RowCount), Sorts, Key/RID Lookups, “Sort, Split and Collapse”, Assert, Merge Interval, Index Seek and much much more.


All the Magic Knobs [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Cindy Gross
In today’s consolidated environments you may not have time to fine-tune every query. But there are some low-effort, high return things you can do to make those environments more likely to perform “good enough”. The same settings also help fine-tune those tier one instances as well. We’ll discuss tempdb configuration, power saving settings, compression, VLFs, grow/shrink, patching strategies, and configuration settings such as ‘optimize for ad hoc workloads’ and MAXDOP.

AlwaysOn: Boosting performance of your workloads using readable replicas [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Sunil Agarwal
Database Mirroring has been deployed very successfully by many customers to achieve high availability. Since it was released in SQL2005/SP1, DBMirroring functionality allowed customer to run their reporting workload on the mirror by creating a database snapshot. One drawback on database snapshot was the data latency. Customers want to offload their reporting workload to DBMirroring but only if the data latency is low. With SQL Server with codename ‘Denali’, we have re-architected DBMirroring to run on Windows 2008R2 cluster and as part of this re-architecture you can now offload your read workload to the secondary replica (i.e. Mirror) and free up the primary to process the primary workload. In this talk, I will walk you through with the scenarios and discuss key design challenges related to concurrency, query plans and impact of running read workload followed by a demo.

An Awesome Permissions Query [300]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Sharon Dooley
Ever wanted a complete view of the permissions somebody has whether granted explicitly or inherited from somewhere? This is the query for you!

An XQuery Cookbook for DBAs [300]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Trevor Barkhouse
From deadlock graphs to XML statistics profiles, more and more types of SQL Server meta data are being exposed as XML. Many DBAs have been resistant to SQL Server's native inclusion of XML data, somewhat due to its abuse by developers. However, XML is very well suited to certain types of data, which explains its increasing prevalence. The real problem comes with consuming the data, which requires specialized T-SQL extensions (that implement the XQuery standard). After introducing some concepts, the session will consist primarily of demonstrating a collection of ready-to-use scripts for extracting valuable diagnostic information from XML data.

Are You Smarter Than An MCM? [400]
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Lara Rubbelke, Cindy Gross, Jimmy May, Pam Lahoud, Robert Davis
Are you game to take on the Microsoft Certified Masters? Dive deep into SQL Server for some of our MCM panel’s favorite advanced SQL topics. Our distinguished panel of MCM “classmates” will demonstrate the answers to some of the more interesting and puzzling SQL Server subjects to advance your SQL Server expertise! Pit your game against their game in the ultimate challenge of SQL Server intellect!


Page:  of 28  | [PREVIOUS]  [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