Training – SQL Server Online

Technet Webcasts:

• SQL Svr 2005 (1/10): Administration Tools
• SQL Svr 2005 (2/10): Monitoring Tools
• SQL Svr 2005 (3/10): Achieving Greater Concurrency
• SQL Svr 2005 (4/10): Securing Your SQL Server
• SQL Svr 2005 (5/10): Protecting Sensitive Data
• SQL Svr 2005 (6/10): Managing Large Databases Using Partitioning
• SQL Svr 2005 (7/10): Indexing Enhancements
• SQL Svr 2005 (8/10): Backup and Restore: Minimizing Downtime
• SQL Svr 2005 (9/10): High Availability
• SQL Svr 2005 (10/10): Moving Data Between Data Sources
• SQL Svr 2005 for IT Prof (1/11): A Fast-Paced Feature Overview and Series Introduction
• SQL Svr 2005 for IT Prof (2/11): Security
• SQL Svr 2005 for IT Prof (3/11): Understanding Installation Options and Initial Configuration
• SQL Svr 2005 for IT Prof (4/11): Upgrade Considerations and Migration Paths
• SQL Svr 2005 for IT Prof (5/11): Effective Use of the New Management Tools
• SQL Svr 2005 for IT Prof (6/11): New Application Design Patterns for Scalability and Availability and the Operational Implications of Service Broker
• SQL Svr 2005 for IT Prof (7/11): Technologies and Features to Improve Availability
• SQL Svr 2005 for IT Prof (8/11): Implementing Database Mirroring in SQL Svr 2005 (1/2)
• SQL Svr 2005 for IT Prof (9/11): Implementing Database Mirroring in SQL Svr 2005 (2/2)
• SQL Svr 2005 for IT Prof (10/11): Recovering from Human Error
• SQL Svr 2005 for IT Prof (11/11): Best Practices in Building Robust, Recoverable, and Reliable Systems
• A Technical Overview of High Availability Features in SQL Svr 2005
• Building Highly Available Database Systems that Scale with Peer-to-Peer Replication
• Clustering Windows Server 2003 and SQL Server 2000 and 2005
• Data Recovery in SQL Svr 2005
• How to Increase Availability Using Database Mirroring in SQL Svr 2005
• Managing Concurrency in SQL Svr 2005 (2/2): Planning for and Troubleshooting Snapshot Isolation and Row Level Versioning
• Data Quality and Compliance with SQL Svr 2005 Integration Services
• Heterogeneous Data Integration Using SQL Svr 2005 Integration Services
• Integrating Non-Standard Data Sources and Adding Value to Data with SQL Svr 2005 Integration Services
• New Setting Up and Deploying SQL Svr 2005 Reporting Services for SAP BW
• Accessing Operational Data in Mainframe VSAM Using SQL Server 2005 and Host Integration Server
• Get More from Your Oracle Data with SQL Svr 2005
• How Microsoft IT Runs SAP on SQL Svr 2005
• Integrating Existing Information in IBM DB2 using SQL Server 2005 and Host Integration Server
• Replicating Data Between Oracle and SQL Svr 2005
• Setting Up and Configuring SQL Svr 2005 for SAP Applications
• Advanced SQL Svr 2005 Integration Services
• New Implementation and Deployment Enhancements with Microsoft Dynamics GP 9.0 on SQL Svr 2005
• New Introduction to SQL Svr 2005 Reporting Services
• Advanced SQL Svr 2005 Reporting Services
• Be More Productive: An Overview of DBA Tools in SQL Server 2005
• Database Mail in SQL Svr 2005
• Developing and Working with SQL Svr 2005 Maintenance Plans
• Improve Your Productivity by Using SQL Agent to Automate Monitoring and Administration Tasks
• Introduction to Data Mining with SQL Svr 2005
• Introduction to SQL Svr 2005 Analysis Services
• Introduction to SQL Svr 2005 Integration Services
• Introduction to SQL Svr 2005 Report Builder
• Introduction to SQL Svr 2005 Reporting Services
• Manage SQL Svr 2005 Using Command Line Tools and the SQLCMD Utility
• Managing and Administering SQL Svr 2005
• Monitoring Replication in SQL Svr 2005
• Real-Time Business Intelligence with SQL Svr 2005 Analysis Services
• Scripting in Microsoft SQL Svr 2005
• SQL Agent in SQL Svr 2005
• SQL Svr 2005 Integration Services: Performance and Scale (Level 400)
• SQL Svr 2005 Makes Extensive Use of Tempdb
• SQL Svr 2005 Manageability Using Management Pack for MOM
• SQL Svr 2005 Reporting Services Management and Security
• Understanding Maintenance and Monitoring Enhancements to SQL Svr 2005
• What’s New in the Database Storage Engine in SQL Server 2005
• New SQL Svr 2005 Security
• Efficiently Using the SQL Server Execution Context in Applications
• Encryption and Key Management Using SQL Svr 2005
• How Microsoft IT Implements Encryption Using SQL Server 2005
• Introduction to Security in SQL Svr 2005
• Securing Business Solutions Based on SQL Svr 2005
• SQL Svr 2005 Security Enhancements
• SQL Svr 2005 Security Overview
• SQL Svr 2005 Surface Area Configuration
• Best Practices for Deploying SQL Svr 2005 on Storage Area Networks
• Optimize Your SQL Server Environment for Availability with Storage Foundation for Windows
• A SQL Server DBA’s Guide to CLR Integration
• Performance Diagnosis in SQL Svr 2005
• SQL Svr 2005 Database Tuning Advisor
• SQL Svr 2005 Troubleshooting: Supportability Features for SQL 2005
• Troubleshooting Performance Problems in Microsoft SQL Server 2005
• Troubleshooting SQL Svr 2005 Integration Services
• An Overview of the SQL Svr 2005 Upgrade Process
• From DTS to SSIS: Making the Move to SQL Server Integration Services
• How to Migrate Your Oracle Database to SQL Server
• Reap the Immediate Benefits of Upgrading to SQL Server 2005
• SQL Svr 2005 Analysis Services: Preparing to Migrate
• Strategies and Tools for Upgrading to SQL Svr 2005
• Transparent Benefits of Upgrading to SQL Svr 2005
• Upgrade Considerations for Query Optimizer Statistics
• Upgrading to SQL Svr 2005
• Upgrading to SQL Server Agent in SQL Svr 2005: User Experience
• Data Warehousing Enhancements in SQL Svr 2005
• Deploying, Managing and Securing Analysis Services
• Deploying, Managing and Securing Integration Services
• Design Reports in Microsoft Office and Deliver Using SQL Server Reporting Services
• Designing a Scalable Data Warehouse / Business Intelligence (DW/BI) System
• Extending BI with SQL Svr 2005: Emerging Best Practices for Large Scale Enterprise BI Applications
• Microsoft Office Excel 2007 and SQL Svr 2005 Analysis Services Integration Explained
• Overview of SQL Svr 2005 Analysis Services
• Overview of SQL Svr 2005 Data Mining
• Overview of SQL Svr 2005 Integration Services
• Overview of SQL Svr 2005 Reporting Services
• Practical Tips for Seamless Migration from Analysis Services 2000 to 2005
• Real-Time BI with SQL Svr 2005 Analysis Services
• Real-World Experience with a Business Intelligence System on SQL Svr 2005 (1/3): Overview and Design
• Real-World Experience with a Business Intelligence System on SQL Svr 2005 (2/3): Data Engines
• Real-World Experience with a Business Intelligence System on SQL Svr 2005 (3/3): Presentation
• REAL-World Experience with SQL Svr 2005 Table Partitioning
• Scalability, Performance and Optimization in SSIS

MSDN Webcasts:

• SQL Svr 2005 Essentials (13/14): Enhancements to the SqlClient Data Provider
• Architecture: Using SQL Svr 2005 Integration Services to Populate a Kimball Method Data Warehouse
• What I Wish Developers Knew About Writing Queries in SQL Server 2005
• Incorporating Business Intelligence (BI) in Applications Using SQL Server Reporting Services and Visual Studio Getting Started with Data Mining
• SQL Svr 2005 Essentials (14/14): ADO.NET 2.0
• What I Wish Developers Knew About Writing Applications for SQL Svr 2005
• Data Driven Performance Management Solution Web Seminar
• Advanced Report Authoring with Report Designer
• Applying SQL Svr 2005 Data Mining to Enterprise Business Problems
• Building Business Intelligence Applications with ADOMD.NET
• Creating a Custom Security Solution for SQL Svr 2005 Reporting Services
• End-User Ad Hoc Reporting with SSRS
• Extending SQL Server Integration Services with Custom Components
• Incorporating Data Mining into the Integration, Analysis and Reporting Components of Business Intelligence
• Integrating Hand-coded ETL with SQL Server Integration Services
• Integrating Windows SharePoint Services with SQL Server Reporting Services
• Intelligent Applications: Embedding Data Mining in Your Application
• Introduction to SQL Svr 2005 Reporting Services (1/6)
• Introduction to SQL Svr 2005 Reporting Services (2/6)
• Introduction to SQL Svr 2005 Reporting Services (3/6)
• Introduction to SQL Svr 2005 Reporting Services (4/6)
• Introduction to SQL Svr 2005 Reporting Services (5/6)
• Introduction to SQL Svr 2005 Reporting Services (6/6)
• SQL Master Class: Using Report Builder
• Using the Business Activity Monitoring Tracking Profile Editor (TPE) Tool and APIs in BizTalk Server 2006