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]  [NEXT]
Sessions Found: 28
Designing Your SharePoint Infrastructure [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Victor Isakov
SharePoint 2010 is massive! Both in its architecture, complexity and importance in your organisation! Have you been "lumped" with ensuring that it will perform, scale, be available and recoverable? Then this is the session for you!
In this session Victor Isakov (MCT, MCM, MCA) will present the SharePoint 2010 architecture and how it both scales out and up. Victor will then cover what every DBA should know, including capacity planning, performance management, configuration, disaster recovery and high availability to maximise your organization's investment in SharePoint and you!



So How Does the BI Workload Impact the Database Engine? [300]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Denny Cherry, Stacia Misner
In this session, two SQL Server MVPs, one specializing in business intelligence and one specializing in core engine, will explain how normal day to day BI workloads impact the database engine, from ETL and cube processing to queries and report server management. During this session, we'll discuss what happens to the OLTP database during ETL as well as what happens to the data warehouse as data is being loaded. We'll talk about what you can do to speed up data warehouse loads and, most importantly, why these changes speed up the data warehouse loads. Then we'll review how cube processing affects the data warehouse database and describe how you can tune the data warehouse database for optimal cube processing. Also during this session, we'll compare performance differences between queries running against the OLTP application, the data warehouse, and the OLAP cube. We'll also assess the impact on the database engine when the reporting services databases are housed on servers which are hosting other databases.



So how does the BI workload impact the database engine? [100]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Denny Cherry, Stacia Misner
In this session, two SQL Server MVPs, one specializing in business intelligence and one specializing in core engine, will explain how normal day to day BI workloads impact the database engine, from ETL and cube processing to queries and report server management. During this session, we'll discuss what happens to the OLTP database during ETL as well as what happens to the data warehouse as data is being loaded. We'll talk about what you can do to speed up data warehouse loads and, most importantly, why these changes speed up the data warehouse loads. Then we'll review how cube processing affects the data warehouse database and describe how you can tune the data warehouse database for optimal cube processing. Also during this session, we'll compare performance differences between queries running against the OLTP application, the data warehouse, and the OLAP cube. We'll also assess the impact on the database engine when the reporting services databases are housed on servers which are hosting other databases.

SSIS Solution Framework [200]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Mark Stacey
In this session, Mark will go through 5 techniques for creating reusable components in SSIS, allowing for more productive work in SSIS, and smoothing deployment processes.

The Data Mining Lifecyle [100]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: BI Architecture, Development and Administration Topics
Speaker(s): Carlos Bossy
Multi-core computing power along with SQL Server make it possible to embed sophisticated data mining models into your applications to assist users in making better quantitative and analytic decisions. Through forecasts and predictions, object clustering, anomaly detection, and data classification, this presentation will demonstrate how to use Analysis Services to solve the most difficult but highest ROI problems in your organization. You’ll see how to create a problem statement and set a target that improves your business efficiency and effectiveness. The session will show you how to prepare data for modeling and step through the process of developing a predictive algorithm that meets the target requirement. To complete the process you will see how to embed theses complex models seamlessly into your applications for maximum results.

Real-world solutions shown by Carlos Bossy will include the development of a decision tree model that forecasts the expected success of placements for children in foster care. This will be followed by a demonstration of a neural network being used to predict a customer’s income at a bank and will compare the results to other algorithms. In addition, examples will be shown on how to turn SQL Server into a recommendation engine and an unsupervised learning machine. To finish up with a little fun, the session will work through a few stock market predictions.

Live demos of the full data mining lifecycle will include much of the SQL Server product line. This session will provide you with expertise in some of the most advanced areas of Analysis Services showing you how to create, train, test and deploy a data mining model using SSAS. Also, you will learn how to use SSIS to query and load mining forecasts, display mining results using Reporting Services, and web applications that take advantage of the models you create. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications and come as close as you can get to Artificial Intelligence as a DBA!


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.


Inside Tempdb [500]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Bob Ward
Perhaps one of the most frustrating, least understood, and contentious areas (no pun intended) of the SQL Server Engine is tempdb. In this half-day session, we will drive into the internals of the tempdb database. I will warn you up front. This is a 500 level session and will be a very deep internal discussion. It will be very fast-paced with much information to consume. As with past presentations I’ve done I will be using tools like the Windows Debugger, DMVs, DBCC commands, and possibly even hex editors. I will use as aid in presentation details of memory structures, classes, and bitmaps, Even with the depth of this presentation, I believe anyone will walk away with many practical pieces of knowledge and advice that can help you avoid problems and maximize your usage of tempdb.

This presentation will cover (but not limited to) the following topics:

• Differences between tempdb and other databases
• Internals of tempdb allocation
• Internals of temporary objects (temp tables, table variables, worktables, ….)
• Caching of temporary objects
• Internals of tempdb logging
• Tempdb latch and lock contention
• Pushing the limits of tempdb
• Monitoring usage and behavior of tempdb
• Troubleshooting the common and advanced tempdb problems

While this presentation include slides and information about tempdb it will also be mixed with a rich set of demonstrations to see the behavior (or misbehavior) of tempdb with SQL Server applications.


Inside Tempdb (cont) [500]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Bob Ward
Perhaps one of the most frustrating, least understood, and contentious areas (no pun intended) of the SQL Server Engine is tempdb. In this half-day session, we will drive into the internals of the tempdb database. I will warn you up front. This is a 500 level session and will be a very deep internal discussion. It will be very fast-paced with much information to consume. As with past presentations I’ve done I will be using tools like the Windows Debugger, DMVs, DBCC commands, and possibly even hex editors. I will use as aid in presentation details of memory structures, classes, and bitmaps, Even with the depth of this presentation, I believe anyone will walk away with many practical pieces of knowledge and advice that can help you avoid problems and maximize your usage of tempdb.

This presentation will cover (but not limited to) the following topics:

• Differences between tempdb and other databases
• Internals of tempdb allocation
• Internals of temporary objects (temp tables, table variables, worktables, ….)
• Caching of temporary objects
• Internals of tempdb logging
• Tempdb latch and lock contention
• Pushing the limits of tempdb
• Monitoring usage and behavior of tempdb
• Troubleshooting the common and advanced tempdb problems

While this presentation include slides and information about tempdb it will also be mixed with a rich set of demonstrations to see the behavior (or misbehavior) of tempdb with SQL Server applications.


Master SQL Server N-Way Clusters [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Ryan Lence
This session will provide a deep dive into building, supporting, and maintaining SQL Server N-Way clusters. From SQL Server 2005, 2008, 2008 R2 and now 2011, Microsoft has made several improvements to N-Way clustering technologies. Here we will go over the differences between these versions, and go under the covers to look at cluster logging, mount points, MSDTC, cluster groups, patching, getting the right balance, and other needed topics. Mission critical topics like how to I add new cluster instances without affecting uptime, and what is the right way to expand the cluster will be covered. We will also go over how to create your own Virtual N-Way cluster for testing using iSCSI between one or more laptops. This half day session will be filled with real world examples, and demo’s to help the participants gain a deeper understanding of using N-Way clusters to solve real world issues, while reducing the total cost of their SQL Server environment.

Maximize SQL Performance – understanding SQLOS & Hardware Configurations [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Enterprise Database Administration and Deployment
Speaker(s): Neil Hambly
For maximum SQL Server performance, it is essential to understand this 'Framework' that underpins SQL Server known as "SQLOS"

Learn how it interacts & performs synchronization of requests to and from the Hardware layer. Get answers to questions like
• How does SQLOS interact with Windows OS and the hardware layers?
• How can we maximize our system resources for efficiency?
• What common configuration pitfalls may be lurking in your environment?

This in-depth session will start with a high level overview and then explore the complexities of the SQLOS layer

Throughout, there will be demos using hands-on practical techniques to underline the key principles of the session, in order to help delegates to apply what they have learnt to their own environments.



Page:  of 3  | [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