Monday, September 17

The Need for Speed, Intermediate
Robert Patton
10:30 a.m.
No query can run fast enough. In this session you'll learn tips and tricks to make your everyday jobs and everyday code run more effectively. Often developers place all of their focus in the execution plan to tune specific queries. Instead of relying on tuning specific queries, write better queries! Come and learn when and how you should limit rows, use output parameters, how to build a better Where clause, and how to avoid many of the more common pitfalls; such as: optimizer hints, string concatenation and cursors. From this session you are more likely to achieve better execution plans and more.

Transact-SQL Enhancements in SQL Server 2005, Introductory
John Papa
11:45 a.m.
Transact-SQL got an overhaul in SQL Server 2005. Some of the features that benefited from this include the TOP feature, which now has a broader feature set. Even the tried and true triggers got some added functionality with the introduction of DDL triggers. In this session I will explore these features as well as many others including the new Exception Handling techniques and the new support for large datatypes.

Advanced SQL Client 2.0, Advanced
Brian Randell
2:00 p.m.
The latest version of SQL Client for managed code developers offers a plethora of new features that help you build richer and more robust applications, especially when using SQL Server 2005 as the back end. In this session you'll learn about new features like MARS and Cache Sync, as well as how to take advantage of changes to connection pooling and other connection management features. You'll learn how to use these features from both Windows Forms and ASP.NET applications, including the areas that require the most attention.

SQL Server Express Edition for the .NET Developer, Intermediate
Leonard Lobel
3:15 p.m.
This talk is all about SQL Server 2005 Express Edition (SQL Express). We start off by comparing Express with the other editions of SQL Server. Special treatment is given to the Express vs. Everywhere (formerly known as Mobile Edition) question that developers inevitably face when building applications that require a local database.
 
Then we dive into a series of demos that showcase SQL Server Management Studio Express (SSMS Express), dynamic database attachment and integration with Visual Studio. We give a detailed explanation of exactly what User Instances are (a feature available only in SQL Express), and provide demos that show how to manage User Instances in the context of other new features in SQL Server, such as SQL CLR integration. Additional demos include how to deploy your SQL Express based .NET application using ClickOnce technology, and building front end reporting applications using RDLC and the Report Viewer redistributable control. Sample code is provided as well, and is based on the Microsoft Starter Kits and Sample Applications for SQL Express.

Unleashing SQL Server Reporting Services 2005, Introductory
John Papa
4:30 p.m.
This session will demonstrate how to design reporting solutions using SQL Server Reporting Services (SSRS) 2005. SSRS 2005 has improved in many areas over its previous version SSRS 2000 including new features such as multi valued parameters, a fully functional report builder and vastly improved expression builders. I will explore a number of the SSRS 2005 features as I demonstrate how to build and deploy reports for an enterprise application.

Tuesday, September 18

Manageability in SQL Server code name "Katmai"
Dan Jones
10:35 a.m.
In today’s data-driven world, data and the systems that manage that data must always be secure and available. SQL Server 2008 enables IT to be more productive by providing a more secure, scalable, and manageable enterprise data platform with reduced application downtime. This session will focus on the new manageability features that enhance the productivity and efficiency of DBAs. A few of the new features that will be covered include policy-based administration, fine-grained resource allocation by workload, auditing, and robust performance data collection. These and other manageability features will be presented in the context of trends impacting the manageability of data environments.

Next Generation Data Warehousing in SQL Server code name "Katmai"
Torsten Grabs
11:45 a.m.

SQL Server code name "Katmai": Going Beyond Relational
Rob Reinaur
2:00 p.m.

Reporting Services Enhancements in SQL Server code name "Katmai"
Carolyn Chau
3:15 p.m.
SQL Server 2008 Reporting Services will deliver a set of major enhancements beyond SQL Server 2005.  In this session, we will explore the enhanced layout capabilities of RDL (Report Definition Language), which enable Reporting Services to support a new range of reporting scenarios.  We will take a look at the changes to the Reporting Services report design tools as well as chart enhancements enabled by our newly integrated chart component from Dundas Data Visualization. Finally, we will discuss the manageability improvements for the Report Server and configuration and management tool enhancements.

SSIS Patterns and Practices, Intermediate
Trey Johnson
4:30 p.m.
Integration Services fulfills the core needs of ETL within the Enterprise. It’s not you're old DTS; but you can learn the techniques that will make it successful for you today. Curious now and want to know just how the technology is being applied to this paradigm as well as alternatives? Join us for this in-depth session of exploring querying of federated data sources; learning integration of Data Mining in the pipeline; and coming to know the blend of out-of-the-box and custom extensions to making Integration Services work well in your organization. We'll explore this through a multitude of demonstrations that can be applied in your own business.