| Begin | End | DBA (Bells 1) | Development (Bells 2) | BI (Training Room) |
| 8:00 | 8:30 | Breakfast / Registration | ||
| 8:30 | 8:45 | Mike White - Welcome Address | ||
| 8:45 | 9:20 | Keynote - Paul Nielsen - Performance Decisions | ||
| 9:30 | 9:30 | Clustering and VPC | What's new in T-SQL | RS Coolest Reports |
| 10:15 | 10:15 | 64 bit SQL | Mixing XQuery and Select | The Object/Relational Hybrid Database |
| 11:00 | 12:00 | Direct from Redmond | ||
| 12:00 | 1:00 | Lunch | ||
| 1:00 | 1:10 | Chris Shaw - Get Involved! | ||
| 1:10 | 2:00 | Problem/Solution - Xbox 360 - Contest | ||
| 2:10 | 2:10 | DBA Checklists | Native Web Services | MDX Scripting Calculations within Cubes |
| 2:55 | 2:55 |
Windowing Functions in T-SQL |
Message Queuing at its Best | Data Mining with Analysis Services |
| 3:40 | 3:40 | SQL Server Community at Large Discussion | High Performance CLR functions | Slowly Changing Dimensions and SSIS |
| 4:30 | 6:00 | Speaker's Panel Q&A - IPod Raffle | ||
| Presentation | Speaker | Abstract |
| Development | ||
| What's new in T-SQL | Jerry Nixon | T-SQL has several exciting new capabilities. In this session, Jerry shows you his favorites. |
| Mixing XQuery and Select | Wolfgang Baeck | XML is more than just an updated comma-delimited file. Xquery can search XML data and the values can be joined with T-SQL Queries. |
| Native Web Services | Ted Malone | This session will cover the new http endpoints available with SQL 2005 and how they can be combined with SQLCLR procedures to build fully functional, SOA - themed web service interfaces. This session will also demonstrate how easily these web services can |
| Message Queuing at its Best | Tom Norman | Do you have multiple databases processing data between them. Can they process in parallel? Service Broker can help! Let’s setup message queuing to process our data. |
| High Performance CLR Functions | Kevin Lloyd | SQL Server 2005's managed code opens a world of possibilities and questions. In this targeted session, Kevin will focus on implementing CLR functions, passing, and returning data. |
| Database Administration | ||
| Clustering and VPC | Patrick Gallucci | Attendees to this session will learn how to create a multi-node SQL Server 2005, Analysis Services 2005 Windows 2003 Cluster using Microsoft Virtual PC 2004, Stringbean Software's WinTarget and Microsoft iSCSI. The purpose of this session/HOL is to walk t |
| 64 bit SQL | Josh Jones | 64 bit CPUs offer more than just more performance. In this session, Josh will walk through lessons learned from his upgrade ot 64 bit SQL Server. |
| DBA Checklists | Chris Shaw | You think you've covered everything, but are you sure? In this session Chris Shaw explains his winning system of DBA Checklists. |
| Windowing Functions in T-SQL | Pat Wright | Pat will demo using the new Row_number() for getting sequence numbers in invoices, as well as the changes to Top Function for 2005. |
| SQL Server Community at Large Discussion | Steve Jones | In this conversation with Steve, he'll address your questions about the SQL Server community and it's direction. If you want to get the inside scoop, here’s the source. |
| Business Intelligence | ||
| RS Coolest Reports | Monte Holyfield | Reporting Services is very cool. In this session, Monte will demo some of his favorite tricks and tips for authoring reports that Wow! |
| The Object/Relational Hybrid Database | Paul Nielsen | Objects and Relational database just don't play well together. This session will demonstrate the Kauai solution - transforming SQL Server into an object database. |
| MDX Scripting Calulations within Cubes | Mike White | Use MDX Script to define non-trivial calculations in Analysis Services. Case study includes complications introduced by distinct counts, multiple level calculations, and restructuring underlying datasets to speed calculations. |
| Data Mining with Analysis Services | David Gollob | Data Mining is significantly enhanced with SQL Server 2005. In this session David will demo some of the most coolest data techniques so you can get up to speed with data mning. |
| Slowly Changing Dimensions and SSIS | Brad Young | This discussion and demonstration of SQL Server 2005 Integration Services (SSIS) will touch on this new DTS technology. We will cover an end-to-end implementation of an ETL process using features such as workflow, fuzzy lookup, slowly changing dimension, |