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 18  | [PREVIOUS]  [NEXT]
Sessions Found: 177
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!

Become a PowerShell Rockstar While Still Hating the SMO [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Aaron Nelson
Checking database space, last backup date, table sizes and server/database configuration settings is great. But how do you not run out of memory when you have 400 instances to check? We will explore deploying new users, groups, tables and columns. We’ll build on these multi-server tasks and automate with SQL Agent, some with SQLPSX, some with PowerShell 2.0. We’ll then turn these into nice looking reports to monitor your environment.

We’ll dive into advanced topics like gathering Performance Counters from multiple servers, detecting worst performing queries, scripting out and comparing databases, importing data from websites, atom feeds, and spreadsheets. We’ll also cover parameter binding, splatting, remote jobs, remote installs, and SQLPSX in depth to maximize functionality and keep you productive. We’ll wrap things up with some language nuances that will help you avoid getting bogged down.
This is a hands-on workshop, bring a laptop if you can.


Best Practices and Performance Tuning of XML Queries in SQL Server [500]
Session Category: Regular Session (90 minutes)
Session Track: Application and Database Development
Speaker(s): Michael Rys
Have you ever written an XQuery against the XML data type and were having performance issues? Have you ever wondered how to improve your performance of your XML-based application? In this presentation, I analyse commonly encountered query patterns and performance issues and provide best practices and improved queries that can improve performance up to an order of magnitude. I will provide guidance on how to best store XML inside the database (relational vs as XML datatype, with or without a schema, which XML Index should I use?) and provides performance tips when using XQueries and FOR XML queries.

Best Practices for working with Databases using SQL Server Developer Tools, Code-named "Juneau" [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Mark Wilson-Thomas
In this session we'll discuss what we believe are likely to be common/good working practices for getting the most out of SQL Server Developer Tools, Codename "Juneau" when doing real-world database development activity on large/complex projects.


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