SQL Live!
Session Outlines

Integrated Innovation: Data Access in SQL Server ‘05
Jennifer Perret, Microsoft
SQL Server 2005 has been in the works for some time now and it brings lots of innovation with it. The data-access interfaces, ADO.NET 2.0 and SQL Native Client (ODBC/OLEDB), have evolved to work together with SQL Server to provide the best platform for integrated database application development. In this session we discuss the key features that make SQL Server 2005 and its data access technologies a winning combination. We touch on topics such as using ADO.NET inside SQL⁄CLR, System.Transactions integration, asynchronous command execution, new data type support, and more.

Introduction to Data Mining
Jamie MacLennan, Microsoft
Microsoft SQL Server 2005 provides dramatically expanded data mining capabilities. This session introduces you to the possibilities of data mining and predictive analytics. Learn about the data mining process, what you need to know to mine your data, and the specific mining capabilities offered in SQL Server 2005.

What’s New in ADO.NET 2.0
Jennifer Perret, Microsoft
ADO.NET is the data access framework for .NET applications. The original version included in .NET 1.0/1.1 introduced the core elements for simple, efficient data access in both connected and disconnected scenarios. In this talk we’ll go through the new cool extensions that we have added to ADO.NET in the .NET 2.0 release. Better performance, a provider-independent programming model and great integration with new innovations in the .NET 2.0 CLR and .NET Framework are some of the new features that we’ll discuss in this session.

Intelligent Applications with Data Mining
Jamie MacLennan, Microsoft
Data Mining has long been a tool for extracting information from data for business analysts. This session shows how as a developer you can incorporate the predictive analytic power of Microsoft SQL Server 2005 directly into your Microsoft .NET Framework applications to create a new breed of “intelligent applications.” Learn how to use simple interfaces such as AMO and ADOMD.NET to programmatically create, browse, and predict from Mining Models on your Analytical Server.

TSQL Enhancements
Stephen Forte, Corzen, Inc.
By now you have heard that you can write stored procedures in C# and VB .NET for SQL Server 2005. Does that mean TSQL is dead? NO! A lot has changed in the world of TSQL with the next version of SQL Server. See how efficient you can become with the new TSQL enhancements. You can cross tab in seconds with the PIVOT statement, perform recursive queries much easier with Common Table Expressions, manipulate XML data easier with the XML datatype and aggregate with ease using the new TOP functions. Report with ease with ranking functions. We’ll take a look at the new TSQL enhancements, data types, and the like. We’ll also look at how to choose between CLR Stored Procedures and TSQL.

Introduction to OLAP
Matt Carroll, Microsoft
You’re data is only as good as your ability to understand it. This talk explores how OLAP can help you analyze your data. Basics of OLAP methodology and design will be covered and SQL Server Analysis Services will be introduced. We’ll try out some key features of Analysis Services 2005 to see how OLAP can really work.

Application Development Using XML in SQL Server ‘05
Shankar Pal, Microsoft
Interesting applications can be built using the native XML support in SQL Server 2005. This presentation gives an overview of the XML feature set, discusses how the new XML data type simplifies data management while XML indexing speeds up XQuery expressions on XML data type columns. We’ll illustrate some of the key ideas for application development using this support and shows how the CLR Integration can be used in conjunction with the XML support.

OLAP Application Development with ADO MD.NET
Andrew Brust, Citigate Hudson
ADO MD.NET lets developers create great BI front-ends and middle tier services by combining the best of ADO.NET and classic ADO MD. With the release of SQL Server 2005, ADO MD.NET has been extended to handle new features like KPIs and dimension attributes. ADO MD.NET also supports true CLR integration allowing you to create MDX-callable functions in your Analysis Services databases using .NET. We’ll cover all this and more and you’ll leave ready to take full advantage of the SQL Server release that will truly deliver on the promise of BI.

CacheSync (Formerly “Query Notifications”): What It Is and How It Works
Torsten Grabs, Microsoft
Data caching just got easier with CacheSync in SQL Server 2005. We’ll explain how you can benefit from the data change notification functionality, how does it work under the covers and what are the best practices and recommendations for its use.

Working with OLAP Data from Reporting Services, Report Builder, Excel 12, Maestro and More
Matt Carroll, Microsoft
How do you bring the power of business data to the people that need it?  This talk answers this question by introducing some of the exciting new tools for accessing and understanding OLAP data.  We’ll look at using Reporting Services, Report Builder, Excel 12, Maestro and others for getting business insight out of Analysis Services cubes.

SQL Server 2005 Upgrade Advisor
Jennifer Perret, Microsoft
The new features of SQL Server 2005 are well worth the upgrade effort, but how do you upgrade your existing systems painlessly?  This session drills into the necessary upgrade planning: preparing to upgrade, choosing the best upgrade strategy, and identifying incompatibility issues.  You will learn tips and techniques on how to reduce your upgrade down time and how to best utilize the upgrade tools. The session has live demos of Upgrade Advisor and in-place upgrade features of SQL Server 2005.

Using the Microsoft Report Controls in VS ‘05
Bill Vaughn, BetaV Corporation
Based on Bill¹s latest book, this session walks you through a series of live code examples that illustrate how to leverage the new Visual Studio and SQL Server 2005 RDL-based reporting features. We¹ll see how to create a new report from scratch and how to import a report created with SQL Server Reporting Services. We¹ll setup a report-specific data source, capture user parameters to focus the report data, capture multiple-select parameters, pass parameters to the queries and execute stored procedures to return data for the report. We¹ll build table, matrix and chart reports and applications used to launch the reports. We¹ll show how to deploy the reports and implement (fake) some of the features you¹ll only find on Reporting Services. We¹ll also look at the new SQL Server 2005 Reporting Services features that can leverage this same technology as implemented in SQL Server Express and other editions. When you¹re done you¹ll have a better understanding of the differences between the Visual Studio 2005 and SQL Server 2005 Reporting Services implementations.

Using SQL Server 2005 Technologies to Develop a Real-World Application
John Mollman, Microsoft
SQL Server 2005 brings several exciting new technologies to application developers. CLR integration allows developers to implement database application logic using familiar CLR languages and the power of the Framework Class Library. Service Broker provides a reliable messaging infrastructure using familiar SQL Server syntax and concepts. Enhanced XML support makes working with XML as a data type easier than ever before. Learn how MSDN has leveraged these technologies to develop a system for aggregating content from across our web properties and across the Web.

Advanced Report Authoring and Design in SQL Server ‘05 Reporting Services
Trey Johnson, Encore Development
Learn about advanced techniques for building reports with SQL Server 2005 Reporting Services and the Visual Studio-based Report Designer. Topics include how to use the built-in expression language, report parameterization (data driven, multi-valued, and hierarchical), supporting multiple data sources (including relational, multi-dimensional, and XML), and making reports interactive. You’ll see the new features available to report designers in SQL Server 2005 along with walk-throughs of sample reports and tips and tricks for using the Report Definition Language (RDL).

SQL Server Execution Environment
Ketan Duvedi, Microsoft
Do you want to know what goes inside SQL Server when a request is executed? Do you want to understand the compilation and execution phases, the plan cache and recompilation? Come learn from one of the Microsoft developers in the SQL Execution Engine team about this and get best practices and recommendation on how to better use SQL Server.

Using SQL Service Broker for Reliable SOA
Roger Wolter, Microsoft
Many Service Oriented Architecture implementations use synchronous, connection oriented communications between services. This talk introduces the SQL Service Broker and how it can be used to build reliable, asynchronous Service Orientated Architecture applications.

Monitoring SQL Server ‘05
Dan Winn, Microsoft
SQL Server 2005 exposes a wealth of information through Dynamic Management Views (DMVs), SQL trace events and performance monitor counters. Come and learn how and what to monitor in your SQL Server 2005 environment.

SQL Server 2005 Express Edition
Roger Wolter, Microsoft
The SQL Server 2005 product line includes the Express edition which is meant both as a replacement for MSDE and as a part of the Visual Studio database development platform. We’ll cover the features of Express, user scenarios, and Express unique features designed to improve usability and security of Visual Studio database applications.