I'll be giving my popular pre-con workshop and a couple of data access sessions. Be sure to register early as the workshop has sold out in the past.
Pragmatic Application Design With William R. Vaughn
This series of sessions is designed to take a developer, architect or database administrator through the fundamentals and many of the more technical details of designing and implementing applications using the .NET Framework, Visual Studio and SQL Server. This workshop is not so much about future or expected versions of Visual Studio or the unreleased tools and platforms you hear so much about--it's about how to use the current, stable and trusted versions of the .NET Framework, Visual Studio and SQL Server. The sessions discuss real-world and practical solutions to the problems most companies face--especially smaller companies or smaller departments in larger companies that have to interface with existing data stores of all shapes and sizes.
Reporting (ReportViewer and related technology)
Reporting (ReportViewer and related technology)
SQL344
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 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
SQL Server 2005 CLR Executables
SQL321
Using a series of demos drawn from his latest book, this session walks developers through the process of creating each of the CLR executables including Stored Procedures, Functions, UserDefined Types, Aggregates and Triggers. We'll talk about what kind of executables make sense and which don't. I'll show examples that have never been shown by anyone else that really push the CLR executable technology to the limits.
