Description
Introduction
This modular 12-hour clinic allows you to skip to the tracks
which are most relevant to you. This clinic will help you
understand how to exploit the enhancements to SQL Server 2008 with
little or no changes to existing applications, how to test SQL
Server 2000 or SQL Server 2005 applications for compatibility with
SQL Server 2008, and how to plan upgrades to SQL Server 2008.
This clinic covers the following topics.
- SQL Server 2008 Upgrade Technical Value Proposition
- Anatomy of an Upgrade
- Upgrade Advisor
- Application Compatibility Testing
- Planning Your Upgrade
The prerequisites for this clinic are as follows:
- Participants must have real-world SQL Server 2000 or SQL Server
200…
Read the complete description
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Introduction This modular 12-hour clinic allows you to skip to the
tracks which are most relevant to you. This clinic will help you
understand how to exploit the enhancements to SQL Server 2008 with
little or no changes to existing applications, how to test SQL
Server 2000 or SQL Server 2005 applications for compatibility with
SQL Server 2008, and how to plan upgrades to SQL Server 2008.
This clinic covers the following topics.
- SQL Server 2008 Upgrade Technical Value Proposition
- Anatomy of an Upgrade
- Upgrade Advisor
- Application Compatibility Testing
- Planning Your Upgrade
The prerequisites for this clinic are as follows:
- Participants must have real-world SQL Server 2000 or SQL Server
2005 administration experience
- Participants must have basic operational familiarity with SQL
Server Management Studio
- Participants are encouraged to have real-world experience
installing and supporting SQL Server applications
Objectives At the end of the course, students will be able to:
- Learn all the essential elements of SQL Server 2008 upgrades
and application compatibility testing in an interactive
instructor-led format
- Learn how to leverage important new features of SQL Server 2008
with little or no application changes
- Deep and intensive 200-300 level technical training
custom-designed for quality assurance professionals, service
professionals, application developers, database administrators and
IT Pros
- Courseware developed by Joe Yong and his team from Scalability
Experts (scalabilityexperts.com), pre-eminent experts in enterprise
SQL Server upgrades and performance
- Get hands-on experience with SQL Server 2008 upgrades and
application compatibility testing (not available in all
locations)
Modules & Lessons SQL Server 2008: Upgrade and Application
Compatibility Overview Module Overview SQL Server 2008: Upgrade and
Application Compatibility Overview SQL Server 2008 Upgrade and
Application Compatibility - Introduction SQL Server Upgrade
Technical Value Proposition Introduction and Module Overview
Performance, Scalability, Availability, Secruity, and Managability
Improvements Demo: SQL Server 2008 auditing improvements Demo: SQL
Server 2008 backup compression Demo: SQL Server 2008 Transparent
data encryption vs. column level encryption Demo: SQL Server 2008
Resource Governor Reducing support costs with SQL Server 2008 Demo:
Using Policy Based Management to reduce support costs Improving
Solutions with new SQL Server 2008 features Demo: Using Change Data
Capture with SQL Server Integration Services Targeting new
solutions and markets with SQL Server 2008 improvements Important
trends affecting SQL Server usage and deployments - Module review
Planning An Upgrade Module introduction, upgrade methodology
overview, pre-upgrade considerations Sizing your upgrade testing
effort Deciding on an upgrade strategy Pre-upgrade tasks, backward
compatibility Pre-upgrade tasks, preparing for an upgrade
Pre-upgrade tasks, analyzing external factors Immediate
post-upgrade tasks Short-term post-upgrade tasks Long-term
post-upgrade tasks Performing your upgrade Module summary Anatomy
of an Upgrade Module overview, review of upgrade options, upgrade
resources Upgrade path considerations Upgrade options and
considerations for in-place upgrades Upgrade options and
considerations for side-by-side upgrades Upgrading failover cluster
databases Upgrading mirrored databases Upgrading replicated
databases Upgrading analysis services Upgrading log shipped
databases Upgrading Integration Services and DTS Upgrade Advisor,
Upgrade Assistant Known compatibility issues Upgrading Reporting
Services Module summary Upgrade Advisor Upgrade Advisor overview
Demo: Using Upgrade Advisor Upgrade Advisor system requirements,
running upgrade advisor Understanding the Upgrade Advisor analysis
wizard Module summary Application Compatibility Testing Overview of
application compatibiliy testing process AppCompat Testing Process:
Preparing environment for testing, restoring playback Demo: SQL
Server Upgrade Assistant Running Upgrade Advisor, upgrading to SQL
Server 2008 in-place, preparing 64-bit Demo: Performing a
side-by-side upgrade using backup/restore AppCompat Testing
Process: Replaying your trace Demo: Replaying your Trace using SQL
Server Upgrade Assistant Comparing trace results, understanding
common failures Demo: Comparing trace output results with SQL
Server Upgrade Assistant AppCompat Testing Process: additional
notes and issues Module summary System Requirements To view this
course, you need:
- A Pentium II, 256 MB RAM with a processor speed greater than or
equal to 400 MHZ
- Microsoft® Windows® 2000 or higher
- Microsoft Internet Explorer 6.0 or higher
- Adobe Flash 7.0 or higher (1MB disk space needed to
install)
- Microsoft Silverlight 4.0 or higher
- Microsoft Windows Media Player 7.0 or higher
- Microsoft XML Core Services 3.0 or higher
- A Super VGA monitor with minimum screen resolution 1024x768,
with 16-bit color.
- A sound card, and either speakers or headphones (for
multi-media audio).
- Internet bandwidth of 56K or faster. Broadband internet access
is recommended.
For courses containing Virtual Server-based labs (courses in the IT
Professional and Developer Catalog), you will need:
- Microsoft Virtual Server ActiveX control (1MB disk space needed
to install)
Test your computer's capabilities to see if it supports this
course. Accessibility Requirements The following software must be
running on your computer in order to access this course with Screen
Reader Software:
- Microsoft Internet Explorer 6.0 or higher
- Window-Eyes from GW Micro
- JAWS from Freedom Scientific
- MSAA enabled
There are no reviews yet. Share your review
Do you have experience with this course?
Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.