SQL 2005 Webcasts and Virtual Labs

S

QL Server 2005 is Microsoft's next-generation data management and analysis software that will deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. In these labs, you will get to experience many of the new features in SQL Server 2005 including CLR integration, XML support and deep business intelligence integration.

While I understand there are numerous resources on the Microsoft site, the following resources should provide you with enough information so that your folks can watch informative Webcasts and then go through some virtual labs that are available on MSDN.

The following are some of the Technet Webcasts that are available:

TechNet Webcast: SQL Server 2005 Series (Part 1 of 10): Administration ToolsTechNet Webcast: SQL Server 2005 Series (Part 2 of 10): Monitoring ToolsTechNet Webcast: SQL Server 2005 Series (Part 3 of 10): Achieving Greater (Level 200) TechNet Webcast: SQL Server 2005 Series (Part 4 of 10): Securing Your SQL Server (Level 200) TechNet Webcast: SQL Server 2005 Series (Part 5 of 10): Protecting Sensitive Data (Level 200) TechNet Webcast: SQL Server 2005 Series (Part 6 of 10): Managing Large Databases using Partitioning (Level 200) TechNet Webcast: SQL Server 2005 Series (Part 7 of 10): Indexing enhancements (Level 200) ****

TechNet Webcast: SQL Server 2005 Series (Part 8 of 10): Backup and Restore: Minimizing Downtime (Level 200)

TechNet Webcast: SQL Server 2005 Series (Part 9 of 10): High Availability (Level 200) May 16, 9:00 A.M.TechNet Webcast: SQL Server 2005 Series (Part 10 of 10): Moving Data Between Data Sources (Level 200)   May 18, 9:00 A.M.TechNet Webcast: A Technical Overview of SQL 2005 High Availability Features (Part 1 of 2) (Level 200) TechNet Webcast: A Technical Overview of SQL 2005 High Availability Features (Part 2 of 2) (Level 200) TechNet Webcast: Clustering Windows Server 2003 and SQL Server 2000 / 2005 (Level 200) TechNet Webcast: Overview of SQL Server 2005 Analysis Services (Level 200) Tue, 24 May 2005TechNet Webcast: Overview of SQL Server 2005 Reporting Services (Level 200) Tue, 24 May 2005TechNet Webcast: Overview of SQL Server 2005 Data Mining (Level 200) Wed, 25 May 2005TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 1 of 3): Overview and Design (Level 200) Thu, 26 May 2005TechNet Webcast: Real-Time BI with SQL Server 2005 Analysis Services (Level 300) Tue, 31 May 2005TechNet Webcast: Data Warehousing Enhancements in SQL Server 2005 (Level 200) Thu, 02 Jun 2005

Below are the MSDN Webcasts:

Overview of the new Developer features in SQL Server 2005—Level 200 Q&A from this webcast

MSDN Webcast: Working with SQL Server 2005 from Visual Studio 2005 (Level 300) Mon, 06 Jun 2005MSDN Webcast: Native Data Access Technologies for SQL Server 2005 (Level 300) MSDN Webcast: End-to-End Data Access: How to Use Web Services with SQL Server 2005 (Level 300) Wed, 08 Jun 2005

Introducing the New SQL Server Management Studio—Level 100 Q&A from this webcast

SQL Server 2005 as a .NET Runtime Host—Level 100 Q&A from this webcast
Introducing XML in SQL Server 2005—Level 200 Q&A from this webcast

MSDN Webcast: Managing XML Data on the Database with SQL Server 2005 and Visual Studio 2005 (Level 300) MSDN Webcast: Developing Smart Client Applications Using SQL Server 2005 Native XML Support (Level 200) MSDN Webcast: Deploying SQL Server 2005 with Your Smart Client Applications (Level 400) Fri, 06 May 2005

Introducing ADO.NET 2.0 for SQL Server 2005—Level 200 Q&A from this webcast

T-SQL Enhancements in SQL Server 2005—Level 200 Q&A from this webcast

MSDN Webcast: T-SQL Exception Handling in SQL Server 2005 (Level 200)

The New Security Model in SQL Server 2005—Level 200 Q&A from this webcast

Introducing Web Services in SQL Server 2005—Level 200 Q&A from this webcast

Introducing Service Broker in SQL Server 2005—Level 200 Q&A from this webcast

Introducing Reporting Services for SQL Server 2005—Level 200 Q&A from this webcast

MSDN Webcast: Advanced Reporting with SQL Server 2005 Reporting Services (Level 200)

Introducing SQL Server Integration Services for SQL Server 2005—Level 200 Q&A from this webcast

MSDN Webcast: SQL 2005: Integration Services (Level 300)

Introducing SQL Server 2005 Analysis Services for Developers—Level 200 Q&A from this webcast

MSDN Webcast: SQL 2005: Analysis Services (Level 200) May 05, 2005 9:00 AM(GMT-08:00) Pacific Time

Introducing Full-Text Search in SQL Server 2005—Level 200 Q&A from this webcast

Introducing Replication in SQL Server 2005—Level 200 Q&A from this webcast

MSDN Webcast: SQL 2005: Data Replication (Level 300) MSDN Webcast: Improving Smart Client Performance Using MARS (Multiple Active Result Sets) in SQL Server 2005 (Level 300) MSDN Webcast: Using Web Services To Connect to SQL Server 2005 from Your Smart Client Applications (Level 200)

Introducing Notification Services in SQL Server 2005—Level 200 Q&A from this webcast

In addition, you may wish to visit the Virtual Hands-on Labs which has numerous SQL Server 2005 Hands-On Labs that you test drive and learn about SQL Server 2005.You get a downloadable manual and a 90-minute block of time for each module. The following modules are available:

· SQL Server 2005 Integration Services 

· SQL Server 2005 Introduction to SQL Server Management Studio 

· SQL Server 2005 Reporting Services 

· SQL Server 2005 Server Management Objects 

· SQL Server 2005 SQL CLR Integration 

· SQL Server 2005 SQL Query Tuning 

· SQL Server 2005 SQL Server and ADO.NET (Lab A) 

· SQL Server 2005 SQL Server and ADO.NET (Lab B) 

· SQL Server 2005 T-SQL Enhancements 

· SQL Server 2005 Web Services 

· SQL Server 2005 XML Capabilites