My Three Days Schedule at SQL PASS 2010   Leave a comment

I had the opportunity, for the third time out of the last four years, to attend the SQL PASS conference from Nov. 9-11, and it was fantastic, just like previous years. This year’s conference, like last year’s (which I also attended) was held in Seattle.

I will post more later about some of the things I learned, but to get started, below is just a print out of the general schedule as well as the specific sessions I attended. This is more or less copied and pasted from the SQL PASS web site, so please forgive the inconsistent formatting and broken links.

 

Tuesday 

Tue Nov 9 All day: Microsoft Labs – 618, 619 (starting 8 am)
SQL Server Clinic – 611 (starting 10 am)
Community Learning Center – Exhibit Hall A (11 am to 4 pm)

Tue Nov 9 8:15am – 10:00am         Keynote Speaker Day 1 – Ted Kummert – 6ABC                                                                                                                                                                                            

 AD371S Identifying and Fixing Performance Problems using Execution Plans

Tuesday, November 9 10:15 AM – 11:45 AM
Room 2AB (378)

Download(s): clip_image002AD371S_Fritchey.pptx

Session Type: Spotlight

Track: Application and Database Development

Speaker(s): Grant Fritchey

This session will demonstrate how SQL Server execution plans can be used to identify problems with the database design, or the TSQL code, and address those problems. The session takes the user through various common issues such as poor or missing indexes, badly written code and generally bad query performance, demonstrating how to identify the issues involved using execution plans. The session will then demonstrate different methods for addressing the issues and show how the fixed query’s execution plans differ. Multiple methods for accessing execution plans including graphical, DMV’s, and trace events are demonstrated. All this is meant to lay a foundation for a general troubleshooting approach to empower the attendee to make their own queries run faster and more consistently.

11:30 am to 1:30 pm Lunch – Birds of a Feather with MVP’s – Expo Hall 4B

DBA362M Best Practices for Data Warehousing with SQL Server 2008 and 2008 R2
Tuesday, November 9 1:30 PM – 2:45 PM
Room 4C4 (330)
Download(s):
clip_image002[1]DBA362M_HansonSQLSERVER.pptx
Session Type: Regular session
Track: Enterprise Database Administration and Deployment
Speaker(s):
Eric Hanson (SQL SERVER)

SQL Server 2008 and 2008 R2 provide a strong foundation for building data warehouse applications. This talk describes how to use them most effectively for data warehouses and data marts. We describe best practices for choosing a processor, storage, and memory configuration for your DW, including a brief description of Fast Track reference architectures. We cover how to choose file and file group structures, and how to define index structures to reduce and speed up I/O. We describe data modeling with a focus on star schemas. We cover how to use pre-built aggregates to speed up queries, including use of indexed views and user-defined summary tables. We describe how to load data into your data warehouse efficiently during a typical nightly load cycle. In addition, we briefly review new features for DW in SQL Server 2008 and 2008 R2, such as few outer rows parallelism, partitioned table parallelism, MERGE, minimally logged INSERT, and Change Data Capture, with an emphasis on how they can make your life easier for querying, updating, and loading your DW.

 

AD207 An MDM Methodololgy with SQL Server 2008 Master Data Services
Tuesday, November 9 3:00 PM – 4:15 PM
Download(s): clip_image002[2]AD207_Bertucci.pptx
Session Type: Regular session
Track: Application and Database Development
Speaker(s):
Paul Bertucci
Introduce a proven master data management methodology that shows the overall approach of mastering core data categories such as Customer data and outlines the key deliverables and artifacts of an MDM project. Also provides a detailed description of the steps that must be taken to “master” a core data category such as Customer, discusses a solid framework that includes a robust participation model and depiction of business rules and workflow that must be followed. And, provides a working example that utilizes Microsoft SQL Server 2008 Master Data Services. 

DBA492S Tracking Waits with Extended Events in SQL Server 2008

Tuesday, November 9 4:30 PM – 6:00 PM
Room 4C1-2 (520)

 

Session Type: Spotlight

Track: Enterprise Database Administration and Deployment

Speaker(s): Andrew Kelly, Jonathan Kehayias

Starting with SQL 2008, there is a new feature called Extended Events which every DBA and Developer should become familiar with. Extended Events allow us to monitor and troubleshoot in ways not possible with previous methods while incurring less overhead on the server. Come see how we can utilize this new feature to track waits all the way down to the query level with minimal overhead. We will also cover the common waits found in most SQL Server instances and discuss ways to avoid or address them.

 

Wednesday

Wed Nov 10 All day: Microsoft Labs – 618, 619 (starting 8 am)
SQL Server Clinic – 611 (starting 10 am)
Community Learning Center – Exhibit Hall A (11 am to 4 pm)

8:15 am – 10:00 am  Keynote Speaker Day 2 – Quentin Clark – 6ABC

DBA588C CSS Update Queries – Under the Hood (90 min)
Wednesday, November 10 10:15 AM – 11:45 AM

Room 606-607 (320)

Download(s): clip_image002[3]DBA588C_Cunningham.pptx

Session Type: Regular session

Track: Enterprise Database Administration and Deployment

Speaker(s): Conor Cunningham

Ever wonder how an update query actually works? What are all those strange operators in the query tree? How do I tell if an update query is performing well? In this talk, Conor will go into depth about how the Query Optimizer builds plans for Insert/Update/Delete/Merge queries, including understanding operators like common subexpression spools and split/sort/collapse and optimizations like narrow vs. wide plans, non-updating updates, prefetch optimizations, the “with outputs” feature, and how we can maintain indexed views incrementally.


11:30 am to 1:30 pm Lunch

DBA264M Understanding SQL Server High Availability Alternatives
Wednesday, November 10 1:30 PM – 2:45 PM
Room 602-604 (360)
Session Type: Regular session
Track: Enterprise Database Administration and Deployment Speaker(s): Ross Mistry
T
his session will focus on outlining the different SQL Server high availability alternatives in order to achieve site resiliency and disaster recovery. Technologies covered include Failover Clustering, Database Mirroring, Log Shipping, Peer-to-Peer Replication and Live Migration. Moreover, this session will teach you how to combine the different high availability alternatives in order to gain maximum availability with your database infrastructure. Case Studies and Best Practices learned from the Microsoft Technology Center (MTC), SQL Server CAT Team and the SQL Server Product Group will be shared.

 

BID234 Cooking with SSRS: Advanced Report Design Recipes
Wednesday, November 10 3:00 PM – 4:15 PM
Room 3AB (378)

Download(s): clip_image002[4]BID234_Turley.pptx

Session Type: Regular session

Track: BI Client Reporting and Delivery Topics

Speaker(s): Paul Turley

The secret to designing compelling report solutions is in the ingredients and the technique. Learn to apply proven design patterns and best practices to create a reporting solution masterpiece. These techniques employ expressions, parameters, custom programming and years of field experience. This presentation is based in-part from our Wrox Press Book: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports.

 

DBA300M A Dramatic new Data Warehouse Query Performance Enhancement in SQL Server “Denali”
(aka new ColumnStore feature code-named “Apollo” in SQL 2011 “Denali”)
Wednesday, November 10 4:30 PM – 5:45 PM
Download(s): clip_image002[5]DBA300M_Price.pptx
Session Type: Regular session
Track: Enterprise Database Administration and Deployment
Speaker(s):
Susan Price
SQL Server code named “Denali” introduces a new data warehouse query acceleration feature based on a new type of index. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases, and can routinely give a tenfold speedup for a broad range of decision support queries. This can allow end users to get more business value from their data through fast, interactive exploration. IT workers can reduce development costs and ETL times since these indexes limit or eliminate the need to rely on pre-built aggregates, including user-defined summary tables and indexed (materialized) views. Hear about the details here first!

Thursday

 

Thurs Nov 11 All day: Microsoft Labs – 618, 619 (starting 8 am)
SQL Server Clinic – 611 (starting 10 am)

8:15 am 10:00 am Keynote Speaker Day 3 – David Dewitt – 6ABC

AD475S Query Tuning Tips
Thursday, November 11 10:15 AM – 11:45 AM

Room 2AB (378)

Download(s): clip_image004AD475S_Ben-Gan.zip

Session Type: Spotlight

Track: Application and Database Development

Speaker(s): Itzik Ben-Gan

Given a SQL Server querying problem there’s much that you can do to enable a good performing solution. Tuning involves arranging an optimal physical environment,(e.g., by creating supporting indexes), as well as writing the query in a way that it would get an optimal execution plan. Many factors can affect the efficiency of the solution including the availability of indexes, data distribution and density, and others. In different scenarios, a different solution could be the most efficient for the same querying problem. Query tuning could be considered an art. This session will provide various tips to do efficient query tuning and demonstrate those through specific tuning examples.

 

11:45 am to 1:00 pm Lunch and leave for return to Tucson (3:45 pm flight)

Advertisements

Posted November 15, 2010 by Norm Enger in Microsoft SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s