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 61  | [PREVIOUS]  [NEXT]
Sessions Found: 603
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.






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!

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.

Building A Database Project With Team Foundation Server [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Scott Schommer
In this session we will cover the ins and outs of how to plan, design and implement building a database project with Visual Studio 2010 and Team Foundation Server. For too many years the source control of a database has been only as good as the backups you could pull from tape. Now that the development community and Microsoft have worked together, we have the first "workable" source control and project building framework. We will also cover multi part names, putting the server logins under source control and how to build and deploy a project to different environments. You will be walked through, step by step with a live demo of how this entire process works!

Come join us and see what software developers have taken for granted for so many years - Source Control and deployment of a database project!


Building compelling PHP applications for SQL Server and SQL Azure. [100]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Jonathan Guerin
In this session, you will learn about the next release of the PHP Driver for SQL Server provides greater flexibility for PHP developers when building against SQL Server. See how LocalDB provides an effortless pathway for hosting a database in a development environment, and how LocalDB can be used to host PHP applications for small web deployments quickly and easily. Finally, see the ease of transition from development environment to a production environment on SQL Azure.

Cardinality Estimation: Understanding and Troubleshooting Number One Query Processing Robustness Problem [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Alexey Eksarevskiy
Come to this talk to learn about the most frequent root cause for inefficient query plan and/or poor query performance – cardinality estimation (CE) inaccuracy - and ways to troubleshoot it. Answers to what CE is, why it is so important, and how SQL Server does it will be provided. Special focus will be on detecting CE inaccuracies (also introducing some small supportability improvements in SQL Server Denali), considering different common cases and workarounds, all based on live examples.

Characteristics of a Great Relational Database [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Louis Davidson
When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered. Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design. In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be discussed.


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