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
Database Index and Performance Tuning for Developers [100]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Ronald Yenko
Even if you're a developer or "Accidental DBA", you may be called upon to perform database design and implementation because you either don't have a DBA on staff or because that person isn't available to work on your project. Index design is one of the most important areas for you to pay attention to during development of any relational database. Even when your system enters operation, you'll sometimes hear incredibly "helpful" insights from your users - "the system used to be fast, but now is really slow - could you fix that for us?" One of the first places you can look is at your database indexes. In this session, we'll look at index fundamentals and some techniques you can use to build and/or tune your database system as it operates.

Database Structures for Programmers [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Louis Davidson
All too often a person will complain that SQL Server isn’t up to the task of enterprise databases, and usually there are two things wrong with this statement. First, the person has a set of data that is hardly up to what SQL Server can deal with at “enterprise” level. Second they have no knowledge of how data is stored or how to manipulate the physical structures to their benefit. In this session, I will, at a reasonably high level cover most of the physical aspects of the SQL Server architecture page structures, table and index structures, files, and more, including some tips on how you can use these aspects to your advantage rather than struggling against the fundamentals of the SQL Server storage architecture (with a taste of the next version of SQL Server thrown in...depending on what is out in CTP form at the time.)

DBA As Protector of the Data: Notes from the Field [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Denise McInerney
The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA.

Death by UDF [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Kevin Boles
User Defined Functions provide several benefits that developers strive for: code encapsulation and code reuse. But they come with the likelyhood of many huge downsides: severe performance impact, concurrency issues and even incorrect results. The "cursor-under-the-covers" that improperly coded scalar UDFs can cause also don't get represented in query plans and statistics IO output either, so even developers that might use those tools would be misled. We will review the badness that comes from common UDF designs, including how to properly see what is going on (hint - SSMS is NOT the way). Then we will cover a few tricks that can help mitigate the issues.

Demystifying Database Metadata [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Mark S. Rasmussen
You know how to query sys.tables, sys.columns and perhaps even sys.system_internals_allocation_units to discover the metadata contents of a database. But where are these views getting their data from, and how do the core system tables relate?

Based on my work with OrcaMDF, an open source C# parser for MDF files, I will demonstrate how to parse the internal system tables. Using just the boot page as origin, we'll discover how to traverse the chain of references that ultimately end up in references to the actual system table data, from where we can parse the data records.

Once we’ve got the system table data, I’ll demonstrate how to correlate the different tables to end up with the data we see in common system views.


Developing Always-On Applications with Microsoft SQL Server Code-Named "Denali" [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Sean Kelley
This session focuses on the enhancements made to ADO.NET and ODBC to take advantage of the AlwaysOn capabilities shipping in SQL Server “Denali”. With AlwaysOn, SQL Server now provides the ability to support the needs of the largest tier 1 applications and includes mission-critical features such as multiple secondaries, faster failover and readable secondaries. Most of these capabilities are available to developers and this session provides an overview of each of these improvements, code demonstrations and best practices to get the most out of SQL Server “Denali”. This session includes the use of Virtual Network Names to shield applications from planned and unplanned failovers, connection strings hints to scale-out read-only workloads, enhancements to command line tools such as BCP and underlying optimizations to speed up failovers across multiple sub-nets.

Developing Microsoft SQL Server Code-Named "Denali" Applications with C/C++ and ODBC [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Oleg Ignat, Sean Kelley
This session focuses on the enhancements made to ODBC to take advantage of the AlwaysOn capabilities shipping in SQL Server “Denali”. With AlwaysOn, SQL Server now provides the ability to support the needs of the largest tier 1 applications and includes mission-critical features such as multiple secondaries, faster failover and readable secondaries. Most of these capabilities are available to native developers through ODBC and this session provides an overview of each of these improvements, code demonstrations and best practices to get the most out of SQL Server “Denali”. This session includes the use of Virtual Network Names to shield applications from planned and unplanned failovers, connection strings hints to scale-out read-only workloads, enhancements to command line tools such as BCP and underlying optimizations to speed up failovers across multiple sub-nets.

Developing Multi-Platform Applications for Microsoft SQL Server and Azure [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Amina Saify, Jonathan Guerin
If you are interested in or currently developing non-Windows application for SQL Server and Azure, then find out how the Microsoft multi-platform strategy on SQL Server can help you utilize the features of SQL Server. During this session, hear about the enterprise-readiness and multi-platform connectivity components that will enable you to harness the power of SQL Server and Azure. We dive deep into features planned for our Java, native and PHP developers for future release of SQL Server and SQL Azure. This session is a great opportunity for you to provide feedback on our long-term roadmap.

Developing T-SQL to Survive Concurrency [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Alex Kuznetsov
Individual T-SQL modules might work perfectly in isolation or on the test database. However, in real life, there are other users accessing the same data, which can cause concurrency issues. Such failures are typically difficult to reproduce in a test environment, so how are you going to prepare your T-SQL code to withstand concurrency?



We shall walk through several typical real life examples when concurrency causes issues, including lost updates, incorrect results in selects, deadlocks, and other errors. In each case we shall see how concurrency can cause problems in our queries, and how to develop better, more robust T-SQL that holds up well under concurrency.

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


DIY Diagnostic Trace Tools for SQL Server Extended Events [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Mike Wachal
The new Extended Events user interface in SQL Server Codenamed "Denali" is built on top of a set of public APIs. This means, if we can do it, so can you.

In this session you will be shown the APIs we used to build the Extended Events user interface. We'll explore how to configure event sessions and read data from both files and running sessions. The focus of the demo will be an application that monitors a database for various conditions and then takes a defined action when the specified conditions occur.



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