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
Code-First Development with the Entity Framework [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Don Kiely
Entity Framework 4 and before used a database-first style of development, wherein the database had to exist before you built the entity data model. But Microsoft has made available an update to EF 4 that supports code-first development, in which you create the model first using tools in Visual Studio 2010. With code-first development, you don't have to create entities in a designer or do any kind of XML mapping. Instead, you define model objects by writing regular .NET classes, including validation rules and a context class that handles retrieving and persisting data, and then create a database from your model. But how good is the resulting database? Are there any pitfalls to this style of development? Can a developer do real database development with code-first? During this session you'll learn about this powerful feature in Entity Framework and see how to put it to use, as well as explore the issues involved with its development.

Concurrency [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Sebastian Meine
This session will introduce the concepts of Concurrency Control and its implementation in SQL Server. Using ACID properties, Transaction isolation Levels and Lock Types as a starting point, we will examine the different behaviors SQL Server exhibits based on the Transaction isolation Level selected. The famous Uncommitted Read will be covered together with lesser-known Phantoms, Lost Updates and their companions. By the end of the session, you will recognize the behaviors that each Transaction Isolation Level exhibits so that you can make an informed decision the next time you have to decide which level to use.

Consuming Cloud Data from Multiple Platforms: The Benefits of OData [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Eric D. Boyd
The amount of data stored today is growing at a rapid rate. However, data is only valuable if it is accessible and can be consumed by people and systems. OData is an open protocol for sharing data that is positioned to solve this problem. OData uses the standard HTTP protocol using REST principles to make data accessible and has huge industry momentum with rapid adoption growth. In this session, we will explore what OData is all about and how to expose relational and non-relational data as OData using WCF Data Services. We will then walkthrough developing apps to consume the OData feeds from multiple clients including mobile devices. Finally, we will take a look at how you can benefit from using Azure to publish your data and OData services.

Data Dude - Making a database developer happier and more productive [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Robert Cain
Whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka "Data Dude" can be a boon to you. In this session we'll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we'll look at the powerful data generation capabilities built into "Data Dude".

Data Loading with SQL Server PDW [400]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Richard Waymire, Brian Walker
This session will examine data loading options and optimization with SQL Server Parallel Data Warehouse. We will examine the internals of data loading, discuss extract/transform/loading strategies and tool choices, and internal operations that occur and how to optimize those operations. We will also examine CTAS vs. Insert/Update/Delete for large data manipulation operations in PDW.

Database Antipatterns: Bridging the Gap Between Development Objectives and Database Realities [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Steve Moss
Are you a Developer who doesn’t understand why DBAs always reject or take issue with your design, when it clearly solves a design problem? Are you a DBA who can’t seem to get your Development Team to understand why certain design patterns are not a good long-term solution? This session will attempt to bridge some of these gaps, by reviewing some common database design scenarios and patterns, what the potential flaws are in them and what the alternatives are. Among the patterns to be discussed will be handling multiple attributes using Entity Attribute Value (EAV) design, Hierarchies, Referential integrity, multiple optional parameters for a stored procedure, overly complex SQL and RBAR (row by agonizing row) methods.

Database Design Contentious Issues - The Debate [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Karen Lopez
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as:

* Natural vs. Surrogate keys,
* Varchar(1) and other Varying datatypes,
* Identity Properties,
* Naming Standards: Useful or Crazy?,
* NULL vs. NOT NULL,
...and others.

This is a physical interactive, irreverent and funny approach to topics we data professionals work with every day.

Bring your votes, your contentions, and your opinions. They will be rewarded.


Database design for mere developers [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Steve Simon
Efficient and effective database design is so important that leaving it solely to the DBAs is simply not a solution. We as developers will more than likely have to create applications to access the data stores and as such must ensure that all application related considerations are taken into account within the database design.
In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development "patterns and anti-patterns", final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.


Database Design Fundamentals [300]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Louis Davidson
In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).

Database Development with SQL Server Data Tools Code-Named “Project Juneau” [200]
Session Category: Regular Session (75 minutes)
Session Track: Application and Database Development
Speaker(s): Gert Drapers, Patrick Sirr
In the SQL Server code-named “Denali” release, the SQL Server Developer Tools, code-named "Juneau", provide a brand-new developer experience for database developers by bringing a familiar Microsoft Visual Studio development paradigms to bear; debug, refactor and maintain your database declaratively.
This session introduces you to the new tools and how you can leverage them to build and maintain you SQL Server and SQL Azure database, standalone and inside a team environment.



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