SQ8K3NEW SQL 2008 New Features for SQL Server 2005 Administrators and Developers, Quanta Training Ltd

Prices shown are excluding VAT. If you are booking any course with an exam and you are using a prepaid account (training days) or passports, you will be invoiced for the exams separately to ensure that you pay only the required amount.


Quanta Training Ltd	Call Quanta free on: 0800 018 9131 or e-mail: sales@quanta.co.uk


SQL Server 2008 New Features for SQL Server 2005 Administrators and Developers

SQ8K3NEW 3 Days	COURSE TOPICS INTRODUCTION, INSTALLATION & UPGRADING Introduction to Microsoft SQL Server 2008 SQL Server 2008 Editions SQL Server 2008 Hardware and Software Requirement Installing SQL Server 2008 Installation Based on a Configuration File SQL Server Configuration Manager Upgrading From Previous Versions of SQL Server MANAGEMENT Management Studio Enhancements Policy Based Management Central management Servers Registering Servers Multi Server Queries PowerShell SECURITY ENHANCEMENTS Transparent Data Encryption Auditing PERFORMANCE Introduction Resource Governor Performance Data Collection Data Compression RECOVERY & AVAILABILITY Introduction Backup Compression Rebuilding the Master and Resource Databases Database Mirroring Mirroring Data Page Recovery Peer to Peer Replication	NEW DATA TYPES Introduction Date and Time Enhancements Filestream Data Sparse Columns HierarchyID Data Type Spatial Data Types User Defined Tables TRANSACT SQL TSQL New Features New Statement Overview of LINQ to SQL Change Data Capture Filtered Indexes SQL SERVER INTEGRATION SERVICES What's New in Integration Services Import/Export Wizard Improvements Performance Improvements Upgrading SQL Server 2005 SSIS Packages Data Profiler Task and Viewer SQL SERVER REPORTING SERVICES SQL 2008 Reporting Services Working with BIDS Gauges and Improved Charts Adding a Gauge to a Report Tablix Upgrading SQL 2005 Reports The Report Builder Report Builder Using Models Course Outline v1.2
THE COURSE The course will introduce delegates to the new feature of Microsoft SQL Server 2008 for existing SQL Server 2005 administrators and Transact SQL developers. The topics covered will include installation, using policies, new data types and apply joins. The course will include lectures, demonstrations and exercises to consolidate the topics covered. WHO SHOULD ATTEND Database administrators, support staff and Transact SQL developers who need to know the new features of Microsoft SQL Server 2008. PRE-REQUISITES Delegates must have extensive experience of Microsoft SQL Server 2005. This can be gained from our SQL Server 2005 Administration and SQL Server 2005 SQL Server 2005 Querying and Programming courses.