Home   Schulung > EDV > Backoffice > SQL Server

Delegates will learn how to smoothly migrate to the this version, what’s new in SQL Server 2008/R2, and how these innovations will help them to do their daily work better, faster and more reliably. They will also learn new ways of scaling performance of SQL Server and its components. Upon successful completion of this course, students will be able to: - Use new tools for managing SQL Server - Upgrade and migrate to SQL Server 2008/R2 - Use new index features and optimizations - Use new data types and other data management enhancements - Transfer data efficiently - Implement new security features - Manage multiple servers effectively - Troubleshoot SQL Server using the new tools - Describe new features in other SQL Server components - Upgrading to SQL Server 2008/R2

Microsoft - Upgrading to Microsoft SQL Server 2008/R2

Ziel
Delegates will learn how to smoothly migrate to the this version, what’s new in SQL Server 2008/R2, and how these innovations will help them to do their daily work better, faster and more reliably. They will also learn new ways of scaling performance of SQL Server and its components. Upon successful completion of this course, students will be able to:- Use new tools for managing SQL Server - Upgrade and migrate to SQL Server 2008/R2 - Use new index features and optimizations - Use new data types and other data management enhancements - Transfer data efficiently - Implement new security features - Manage multiple servers effectively - Troubleshoot SQL Server using the new tools - Describe new features in other SQL Server components- Upgrading to SQL Server 2008/R2
Schulungsinhalte


· New Tools in SQL Server 2008/R2
SQL Server Management Studio and Intellisense . PowerShell provider . Configuration through the facets

· Upgrading to SQL Server 2008/R2
Upgrade from older versions . Side-by-side migration . Upgrading high availability solutions (optional)

· New Index Features
Filtered indexes and statistics . Indexed (materialized) views . Full-text indexes, XML indexes, spatial indexes . Hidden new optimizations in SQL Server that are using indexes

· New Features in Data Management
New data types - rowversion, hierarchyid, geography, geometry, date/time/offset, xml . FILESTREAM . Sparse columns .Data compression in tables, compressing backups . Partitioning and partition switching, express data archiving .Change Tracking and Change Data Capture (CDC)

· New Features in Security
Changes in security from previous versions . Extensible Key Management .     Transparent Database Encryption – TDE . Common Criteria compliance . SQL Server C2 Audit

· SQL Server Multi-Server Management
Managing SQL Servers using policies .Central Management Servers

· Troubleshooting
Activity Monitor . Dynamic Management Views - what is happening with SQL Server . Plan Guides, Resource Governor and Data Collector . SQL Server Extended Events

· New Features in Analysis Services, Integration Services and Reporting Services
New features in OLAP cubes and data mining . Upgrading from DTS to Integration Services . Importing and exporting data, data profiling . Major changes in the architecture of Reporting Services . New features in Reporting Services 2008/R2

· Other New Features (optional)
New features in SQL Server 2005 . Database Mail . New features in replication, peer-to-peer replication . New features in high availability . New features in Transact-SQL . New features in full-text search . Utility Control Points . StreamInsight . Master Data Services .
Zielgruppe
The course is intended for SQL Server administrators and developers, who have experience with any of its previous versions, and plan to upgrade to the 2008/R2 versions.
Voraussetzungen
Good knowledge of SQL Server 2000, 2005 or 2008 administration.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrupsql08e
Dauer3 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Mo, 29.01.2018 - Fr, 02.02.2018, Aachen
Microsoft WPF - Windows Presentation Foundation (Intensivkurs)
Garantierte Durchführung Garantierte Durchführung!