Erfahrene SQL Server Administratoren, die auf SQL Server 2012 umsteigen oder es vorhaben. Praktische DBA-Erfahrung mit früheren SQL Version ist Voraussetzung für diesen Kurs.

Introduction to SQL Server 2012

Installation/Upgrade SQL Server 2012

• Distributed Replay

Manageability Enhancements

• SSMS
• Data Tools
• PowerShell
• DataTier Applications
• DTA
• New DMV's, DMF's

High Availability and Disaster Recovery Enhancements

• AlwasOn (AlwaysOn Availability Groups, Active Secondaries, AlwaysOn Failover Cluster Instances)
• Deploying SQL Server 2012 on Windows Server Core
• Database Recovery Advisor
• Online Operations (LOB Online Index Rebuilds, Adding Online Non-NULL Values)
• Rolling Upgrade and Patch Management

Scalability and Performance Enhancements

• Columnstore Index
• Online Index Creation, Rebuild, and Drop of varchar (max), nvarchar(max) and varbinary(max)
• Partition Support Increased

Security Enhancements

• User defined Server-Roles
• Audit Enhancements (Audit Supported on all SKUs, Improved Resilience, User-Defined Audit Event, Record Filtering, T-SQL Stack Information)
• Database Authentication Enhancements (Enabling Contained Databases, Creating Users, Contained Database Authentication Security Concerns, Default Schema for groups)
• Additional Security Enhancements (.Cryptography Changes, SharePoint Active Directory, Provisioning Enhancements, New Permissions)

Programmability Enhancements

• FileTables
• Semantic Search
• OFFSET & FETCH
• Sequence Numbers
• SQL Express-LocalDB
• OVER CLAUSE
• Extended Events enhancements

Data Quality Services

Master Data Services

Neuerungen Integration Services