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

This Web seminar will cover the basics for how to best administrate SQL Server. Topics such as database and table creation, procedures, functions, and common database properties will be covered.

This Web seminar will cover how to manage SQL Server high-availability features such as mirroring, replication. New features introduced with SQL Server 2008, such as the Resource Governor, will be discussed as well.

This Web seminar will cover how to manage SQL Server scalability. Topics such as data compression, data warehouse engine enhancements, and locking strategies will be covered

This Web seminar will cover how to configure and manage SQL Server security. Topics such as execution context, user and schema separation, encryption, auditing, and backup encryption will be covered.

This Web seminar will cover how to configure and use the Policy Framework that was introduced with SQL Server 2008. The Policy Framework will help administrators better work with often mundane admin tasks.

This Web seminar will give an introduction of how to use T-SQL with SQL Server 2008. It will start with covering the basics and then move on to high-lighting some of the new syntax introduced with SQL Server 2008.

This Web seminar will discuss how to best deal with data that is not fitted to be stored as a traditional relational data type. We will discuss Geospatial, XML, and FileStream data types.

This Web seminar will cover the fundamentals of how to use the SQL Server Service Broker with your applications. It will also highlight new features introduced with SQL Server 2008.

This Web seminar will cover the fundamentals of how to integrate managed .NET code with SQL Server. It will show how to write, deploy, and debug code.

This course will provide an overview of how to work with Visual Studio and SQL Server 2008. It will cover the fundamentals of how to work with Visual Studio 2008 Database Edition and how to create SQLCLR projects and work with debugging.

This Web seminar will cover the fundamentals of how to work with the ADO.NET Entity framework. The following topics will be covered:

• Entity Data Modeling

• Mapping SQL Server to Objects

• ADO.NET and EntityClient

• The Entity SQL Language

• Object Context

• LINQ to Entities

This Web seminar will cover the fundamentals of how to work with SQL Server HTTP programming. It will also highlight new features introduced with SQL Server 2008.

This Web seminar will cover the fundamentals of how to design and work with Occasionally Connected Systems. The following topics will be covered:                  

• Occasionally Connected System Designs • SQL Server Compact Edition 3.5 • Programming - SqlResultSet and DataSet • LINQ and future EDM Support • Server-Directed Synchronization • Sync Services • Using Sync Services with SQL Server 2008