SQL 2005 Webcasts and Virtual Labs

SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage.  Choose from a wide range of live and on-demand webcasts.  Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.

SQL Server 2005 Webcasts

Momentum Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200) – Monday, June 25, 2007.  11:00 AM Pacific Time (US & Canada)

Microsoft SQL Server 2005 is available in a variety of editions to best match the demands of your business applications.  Attend this session to learn about the differences between editions of SQL Server, especially Microsoft SQL Server 2005 Enterprise Edition and Standard Edition, so you can avoid the common mistake of choosing the wrong edition to run your mission-critical applications. In this webcast, we present the value of SQL Server 2005 Enterprise Edition by describing its exclusive features and benefits, and by demonstrating practical usage scenarios. Join this presentation as we compare the capabilities of SQL Server 2005 Enterprise Edition with those available in SQL Server 2005 Standard Edition.

Momentum Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200)

Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services

This Support WebCast describes how you can use custom code in a Microsoft SQL Server 2005 Reporting Services report. We will cover a typical scenario where you would want to use a custom assembly in a report. The presentation simplifies and outlines all the steps to create, deploy, and troubleshoot custom assemblies that are used with Reporting Services. This presentation discusses how to use embedded code instead of a custom assembly and also discusses the pros and cons of using embedded code compared to using a custom assembly.

Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services

MSDN Webcast: Building Smart Client Applications Using Synchronization Services for ADO.NET (Level 200) – Monday, June 11, 2007. 11:00 AM Pacific Time (US & Canada)

Even in an increasingly connected world, offline applications are still a necessity. Attend this webcast to learn how you can build an offline smart client application that synchronizes a backend database with a local Microsoft SQL Server 2000 Windows CE Edition store using the Microsoft Synchronization Services for ADO.NET.

MSDN Webcast: Building Smart Client Applications Using Synchronization Services for ADO.NET (Level 200)

TechNet Webcast: Introduction to SQL Server 2005 Analysis Services (Level 200) – Monday, June 18, 2007. 9:30 AM Pacific Time (US & Canada)

Microsoft SQL Server 2005 Analysis Services includes new capabilities that enable you to deliver rich and powerful analytics to your organization.  In this session, we demonstrate how you can use SQL Server Analysis Services to build a highly scalable business intelligence (BI) infrastructure that supports the analytics your business needs to improve overall performance. During the discussion, we cover the Unified Dimensional Model (UDM), proactive caching, multidimensional expressions (MDX), and new manageability enhancements.

TechNet Webcast: Introduction to SQL Server 2005 Analysis Services (Level 200)

TechNet Webcast: How Microsoft IT Uses SQL Server 2005 to Power a Global Forensic Data Security Tool (Level 300) – Tuesday, June 19, 2007. 9:30 AM Pacific Time (US & Canada)

The Microsoft Information Security team uses an internal tool called Information Security Consolidated Event Management (ICE) version 3.0 to gather forensic data from more than 85 proxy servers around the world.  Powered by Microsoft SQL Server 2005, this 27-terabyte data management system collects different types of global evidence, such as inbound and outbound e-mail traffic, log-on events, and Web browsing, into a single database.  Join this session to learn how ICE 3.0 provides rapid security analysis and queries, robust proxy performance analysis, and extensive troubleshooting functionality.  We discuss how table-level partitions allow event processing and database loading without affecting the ongoing query activities and analysis work of security forensics engineers.  Storage area networks (SAN) manage enterprise storage for ICE 3.0, and the service maintains an uptime of nearly 99.9%.  A controller application dynamically launches multiple instances of Microsoft SQL Server Integration Services (SSIS), which seamlessly responds to changes in the volume of incoming evidence.  This tool was redesigned in 2006 using SQL Server 2005.  Join us for a closer look at how this SQL Server upgrade enhanced the data feed process and query response time, expanded the data retention period, and reduced manual data loading and data validations.

TechNet Webcast: How Microsoft IT Uses SQL Server 2005 to Power a Global Forensic Data Security Tool (Level 300)

TechNet Webcast: Real-Time Business Intelligence with SQL Server 2005 Analysis Services (Level 300) – Wednesday, June 20, 2007.  9:30 AM Pacific Time (US & Canada)

There is an increasing demand to make business intelligence (BI) real time; however, making this happen can be difficult.  Join this webcast as we discuss the challenges of real-time BI and show how some obstacles can be overcome with help from new features in Microsoft SQL Server 2005 Analysis Services, along with other components of Microsoft SQL Server 2005.  Although some barriers that prevent complete real-time BI still exist, SQL Server 2005 can make your information close enough to real time to support better and faster business decisions.

TechNet Webcast: Real-Time Business Intelligence with SQL Server 2005 Analysis Services (Level 300)

TechNet Webcast: Introduction to Data Mining with SQL Server 2005 (Level 200) – Monday, June 25, 2007.  9:30 AM Pacific Time (US & Canada)

Join this webcast to find out how Microsoft SQL Server 2005 can help you dramatically expand your data mining capabilities.  In this session, we introduce you to the possibilities of data mining and predictive analytics.  Learn about the data mining process and the specific mining capabilities present in SQL Server 2005.

TechNet Webcast: Introduction to Data Mining with SQL Server 2005 (Level 200)

Further on-demand webcasts are available here: http://www.microsoft.com/events/series/technetsqlserver2005.mspx