Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.
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 72  | [PREVIOUS]  [NEXT]
Sessions Found: 720
Advanced Use of Constraints in Query Tuning [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Alex Kuznetsov
When we need to deliver better query performance, and our usual tuning approaches are not good enough, it is time to think outside of the box.

In some cases it is much easier and faster to select pre-calculated summary data, than to squeeze every last bit of performance by complex tuning. However, ensuring the integrity of pre-calculated data may be challenging.

In this talk we shall walk through several real life cases where we can gain huge performance improvements by using pre-calculated data. The examples will include some well known difficult problems, such as running totals, gaps and islands, and rolling window totals.

We shall learn how to enforce the integrity of pre-calculated data with constraints, so that we can use it with full confidence. As a result, we shall benefit from lightning fast performance of selects without compromising the correctness of results. As usual in such cases, our modifications will become slower and more complex - that is the price for the improved performance of selects.



All Demo, Performance Tips and Tricks with SQL Server 2008 R2 [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Nabeel Derhem
This session focuses on real case scenarios where you are supposed to handle performance issues with some existing scripts, and evaluating different ways of solving them including enhanced scripting techniques, indexing, and even dynamic queries. Other tips will be presented in the term of "Did you know" that was gathered through actual cases. The key to performance is to understand how the optimizer works.

Analyze GPS Data with XQuery and Spatial Functions [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Allen White
Many third-party devices capture location data using GPS features and store the results in an XML format. With XQuery and the spatial functions new to SQL Server 2008 it's easy to extract and use this data to analyze the data to improve your business. This session will introduce XQuery and the basic spatial functions to show you how to get better information from the devices you're using in your business already.

API-Cursors for mere mortals [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Eladio Rincon
It’s easy to identify cursors in SQL Profiler traces; however it’s difficult to diagnose what they're doing. In this session you'll learn different types of cursors that SQL Server supports and how they use SQL server resources. You'll learn how implicit cursor conversion works, and how it may be affecting the nature of your queries and your data physical structure. Finally, you'll learn to identify API cursors usage by re-learning to read SQL Profiler traces for API cursors.

Application Project & Database Project Integration using SQL Server Developer Tools Code Named "Juneau" [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Robert Cain
For decades there has been a deep divide between application development and database development. Keeping changes in sync has been a laborious, manual process. The new version of Visual Studio Database Projects known as "Juneau" aims to fix that. Developers will be able to generate an ADO.Net Entity Model directly from their Database Project. The new Juneau tools will keep the application and database projects in sync, such that changes to the entity model are reflected to the database, and changes to the database are automatically rolled into the entity model. In this session attendees will get a deep dive into this tool, seeing how to leverage it in their projects.


Auditing and Tracking Your Data [100]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Doug Bernhardt
This session will cover the capabilities of Change Tracking and Change Data Capture in SQL Server 2008/2008R2 and demonstrate some common applications of these to save time and effort auditing and tracking changes to data.

Avoid Common Mistakes in T-SQL Programming [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Alex Kuznetsov
We shall consider several typical real life examples of poorly written T-SQL, examine how and why they break, and fix them. The examples will demonstrate errors caused by improperly handling NULLs, concurrency, type mismatches, database schema changes, and more. You will learn how to detect and fix potential vulnerabilities in your code before it hits production and how to write better, more robust T-SQL the first time.

This talk involves lots of demos that you can take away with you, play with later, and continue your learning.






Avoiding Cursors, While Loops, and other forms of RBAR [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Jeff Moden
If you’re new to T-SQL, don’t let the “400” rating of this session scare you away. This heavily code-based "Developer-to-Developer" session starts at the ground floor of "Set-Based" programming and quickly ramps up through a wide array of lightning fast code examples to please your “need for speed”.

Here are some of the highlights that will be taught and demonstrated in this extended T-SQL "Black Arts" session:

1. What is "RBAR" and "Hidden RBAR"?
2. Make the Paradigm Shift to Set-Based Programming using “Pseudo Cursors”.
3. Introduction to the “Tally Table” and the Incredible Power of the Cross Join.
4. The “No Reads” Tally CTE Explained.
5. Generating Random Numbers, Dates, and Data.
6. Building the “Million Row Test Table” in less than a minute.
7. Some uses of the “Tally Table” including a new CSV splitter that almost keeps up with CLR’s.
8. Concatenation and “Impossible” Comparisons.
9. Converting Rows to Columns: The “back-bone” of high performance reporting.
10. Converting Columns to Rows: Normalization of unknown numbers of columns and tabular data.
11. Grouping the Un-Groupable.
12. Solving the “Running Total” and other “Previous Row” problems.
13. A High Performance Method for Converting Adjacency Lists to Nested Sets.
14. Pre-aggregating the “Million Row Hierarchy” in About a Minute.

To support the highlights being taught above, a large number of various "Tip'n'Tricks" will be explained throughout this session, as well.


Bad SQL [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Geoff Hiten
“But Nothing Changed!!”; the signature statement of Bad Code. Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. “But Nothing Changed!!”. This session focuses on certain common SQL constructs that can and will blow up your server along with alternate structures that are more efficient and stable.

Banish RBAR! [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Wayne Sheffield
SQL Server is primarily designed for set-based operations, so writing code that performs Row-By-Agonizing-Row (RBAR) operations is going against the design, rather than working with it. In this code filled “Developer–to–Developer” session, we will examine several recent additions to SQL Server, and learn how the vast majority of RBAR code can be replaced with efficient, set-based code. Learn how the APPLY operator works with table-valued functions; iterate through incoming data just once with the MERGE statement instead of once per DML operation; see how the Windowing (ranking) functions allow you to “slice and dice” your data, and then perform operations on those groupings; discover how re-writing your multi-statement table-valued functions to be inline functions can help the optimizer and speed up your queries; and learn how to create a grouped delimited list – without loops! Come to this demo-packed session and learn how the vast majority of loop-based operations can be replaced with very efficient set-based operations!


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