SQL Server Service Broker provides the SQL Server Database Engine native support for messaging and queuing applications. This makes it easier for developers to create sophisticated applications that use the Database Engine components to communicate between disparate databases. Developers can use Service Broker to easily build distributed and reliable applications. The following topics will be covered in this one hour session:

·         Service Broker and Application Design Patterns

·         Service Broker Application Construction

o   Queues, Services, Message Types, and Contracts

o   Networking, Routing, and Network Identity

o   Priority

·         Service Broker Programming

o   Conversations and Conversation Groups

o   Internal and External Activation

·         Best Practices

The ability to deploy managed code to SQL server is a very powerful feature. It allows you to utilize the .NET framework library for procedures, triggers, functions, UDF’s, and aggregates within the SQL engine. This one hour seminar will highlight the following topics:

·         SQLCLR Reliability, Scalability, and Security

·         Assemblies

·         Functions, Procedures, and Triggers

·         User-Defined Types and Aggregates

·         T-SQL to SQLCLR Mapping

o   Data Types and Nullability

o   Parameter Types and Direction

·         SQLCLR Best Practices

o   When T-SQL is Preferred

o   When SQLCLR is Preferred

This one hour sessions will discuss how to program against SQL Server using a variety of API’s. The following topics will be covered:

·         Native Client Programming

o   ODBC and OLE DB

·         ADO.NET Programming with SqlClient

·         JDBC Programming

·         LINQ to SQL

When one takes a look at the amount of code that the average application developer must write to address the impedance mismatch across various data representations (for example objects and relational stores) it is clear that there is an opportunity for improvement. Indeed, there are many scenarios where the right framework can empower an application developer to focus on the needs of the application as opposed to the complexities of bridging disparate data representations.

A primary goal of the upcoming version of ADO.NET is to raise the level of abstraction for data programming, thus helping to eliminate the impedance mismatch between data models and between languages that application developers would otherwise have to deal with. Two innovations that make this move possible are Language-Integrated Query and the ADO.NET Entity Framework. The Entity Framework exists as a new part of the ADO.NET family of technologies. ADO.NET will LINQ-enable many data access components: LINQ to SQL, LINQ to DataSet and LINQ to Entities.

This one hour session will cover the following topics:

·         Entity Data Modeling

·         Mapping SQL Server to Objects

·         ADO.NET and EntityClient

·         The Entity SQL Language

·         Object Context

·         LINQ to Entities

This one hour session will discuss a variety of ways that can be used to access SQL server data over http. The following topics will be covered:

·         Web Services

·         ADO.NET Data Services

·         Visual Studio 2008 Integration

·         SQL Server Spatial

Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline access for applications, services and devices. It features technologies and tools that enable roaming, sharing, and taking data offline. Using Microsoft Sync Framework, developers can build sync ecosystems that integrate any application, with any data from any store using any protocol over any network. This one hour session will cover the following topics:

·         Occasionally Connected System Designs

·         SQL Server Compact Edition 3.5

o   Programming - SqlResultSet and DataSet

o   LINQ and future EDM Support

·         Server-Directed Synchronization

·         Sync Services

·         Using Sync Services with SQL Server 2008