The Technet and MSDN teams have teamed up for this tour to bring you a day full of SQL Server 2005 and Visual Studio 2005 presentations and demos.

We will be kicking off the tour in Ottawa on June 2nd and will be heading out to 4 other cities after that.  The day is going to split into two halves.  A morning session (Technet) that is going to focus on SQL Server for the DBA and Business Intelligence audience.  Then the afternoon session (MSDN) is going to focus on Visual Studio 2005. 

I will be presenting the morning session and my colleague Adam Gallant will be presenting the afternoon.

To register for the Technet portion of the tour, head over to http://www.microsoft.com/technet/canada/TechNetSpringTour2005/

SQL Server 2005 Enterprise Data Management for the DBA
Learn about new enhancements including reduced application downtime, increased scalability and performance and tighter security controls.

  • Availability. Building high-availability applications using database mirroring, database snapshots, replication and failover clustering.
  • Scalability. Scalability advancements such as table partitioning, snapshot isolation and 64-bit support will enable you to build and deploy your most demanding applications.
  • Security. Enhancements such as "secure by default" settings, database encryption and an enhanced security model will provide a high level of security for your enterprise data.
  • Manageability. A new management tool suite, expanded self-tuning capabilities and a powerful new programming model will provide database administrators with flexible control for day-to-day database operations.
  • Interoperability. Through deep support for industry standards, Web services and the Microsoft .NET Framework, SQL Server 2005 will support interoperability with multiple platforms, applications, and devices.

Business Intelligence Overview of SQL Server 2005
Learn how SQL Server 2005 can help you get the right information, to the right people at the right time. New analytic features include:

  • Integration Services. Learn how to use the Package Designer in Business Intelligence Development Studio to quickly and easily create an application that can extract data from multiple sources, perform complex transformations and load the data to one or more destinations.
  • Analysis Services. Business Intelligence Development Studio offers new analytic features, including how to quickly build a prototype without a star schema in place, as well as tools to build powerful, customized applications, including MDX scripts, Key Performance Indicators and data-mining algorithms.
  • Reporting Services. Experience the enhanced customization capabilities in the Report Designer, improved integration with Analysis Services and the new interactive features for online reports.