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  |   [NEXT]
Sessions Found: 720
Common Sense [100]
Session Category: Lightning Talks (75 min, 5 min/speaker)
Session Track:
Speaker(s): Niko Neugebauer
Our society has made one of the most impressive developments in the last 40 years, allowing everyone to become anyone they dream to be, changing the rules of our society and opening the opportunities that we have never dreamed of. At the same time it seems that our society has lost something very important for every human: common sense. This session has a goal of reminding everyone of importance to stay in touch with a common sense.

Placeholder session for upcoming manageability work [100]
Session Category:
Session Track:
Speaker(s): Dipti Sangani


Placeholder session-2 for upcoming manageability work [100]
Session Category:
Session Track:
Speaker(s): Dipti Sangani


Architectural Growing Pains [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Chris Shaw
Most of us have faced situations where we have been tracking down problems and we find the source of the issues to be in the design of the database. The motives of the designer often come into question at moments like this. In this session we will review some of the common issues people see when a database starts to grow. We will look at scalability, data types, and design decisions, along with other issues. Each issue that we review we will discuss how to make adjustments in an attempt to assist those working with the pains today.

.NET scripting for SQL Server BI and T-SQL scripts [400]
Session Category: 1/2 Day Sessions (3 hours)
Session Track: Application and Database Development
Speaker(s): Alex Grinberg
SQL Server 2005 has brought the new era for SQL Server DBAs. Today's activities require additional knowledge in different areas, which were secondary before SS 2005, such as .NET, XML, classes, dll libraries, name of few. In this session I will demonstrate how to utilize .NET code with SSIS, SSRS and T-SQL script (include CLR integration). Explain how important it is for DBA to know at least basic .NET development techniques, describe what is Namespaces in .NET. Real code examples give a starting point to beginners in .NET (or DBAs who never use .NET before) and additional way to utilize .NET for those who have experience in this technology. Also I'll include T-SQL techniques, how to create small "consol application" entirely from within T-SQL.

: Scaling in the Middle Tier with the new asynchronous support in ADO.NET [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Luiz Santos
.NET 4.5 introduces a new Asynchronous model to make it easier for developers of all skill levels to write asynchronous code. This will promote a better and easier programming model to write applications that do not block the UI thread. It will also enable middle tier applications to scale better, especially in Azure scenarios where business objects connect to SQL Azure in order to retrieve and manipulate data.
The purpose of this session is to describe the new ADO.NET support for Async.NET features and show how to write scalable applications .



“BEGIN…COMMIT” is Not Enough: Understanding Transactions [100]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Denise McInerney
Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance.

100 Years of Transaction solitude [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Ami Levin
In this session we will revisit ANSI/ISO definitions of transaction isolation levels and their potential effects on your application's data consistency. We will learn how SQL Server complies (or not?) with these definitions and peek under the SQL Server hood to see how they are implemented, with some historical review of the changes since SQL 2000 up to SQL Denali. We will understand how and when to use each isolation level to meet application needs and performance requirements.

3rd Normal Form: That's crazy talk!!! [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Thomas LeBlanc
How did the development world conclude that an integer is the best primary key? What has been added to SQL Server in 2005 and 2008 to help change the way database design has evolved over the years? Can we still use a VarChar(xx) for a primary key? What is the difference between a lookup and Parent/Child relationship? What is an example of a Many-to-Many relationship? What is 4th and 5th normal form?
This session will go through the history of 22 years of experience with various database designs – normalized and denormalized. The discussion will include the benefits and forward looking that should be required for using various design techniques. The flow will be a discussion with attendee participation to share success and pains in database development, leading to standards for all of us to take advantage of while designing databases.


Advanced columnstore query performance tuning [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Eric Hanson
This talk will describe advanced techniques for you to get the best performance possible using the new columnstore index feature in SQL Server Denali. A major part of the performance boost associated with columnstores comes from the new vector-based query execution technique, which reduces CPU instruction count to run a query. Certain operations, including outer joins, anti-semijoins, and UNION ALL, can prevent vector-based processing from working in the Denali RTM release. In this talk, we show you how to work around these and other difficulties using query rewrites. In addition, we’ll cover the benefits of segment elimination, whereby million-row chunks of data can be skipped entirely during query processing, and how you can take advantage of this by loading data in a clustered fashion to get query performance boosts. If you are an advanced data warehouse/BI developer, DBA, or consultant who anticipates using columnstores in demanding applications, this talk will help you get the most out of SQL Server Denali.


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