Home   Schulung > EDV > Backoffice > SQL Server

Delegates will learn what the new features of SQL Server 2012 are, 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 the new performance features like columnstore indexes - Use semantic full-text search capabilities - Use sequences the same way as in Oracle - Implement analytical functions and their windowing extensions - Use the new administration tools - Implement the new security features such as contained databases - Implement improved AlwaysOn high-availability features - Describe the new features in SQL Server Business Intelligence components - Describe the new tools and services of SQL Server

Microsoft New Features in Microsoft SQL Server 2012

Ziel
Delegates will learn what the new features of SQL Server 2012 are, 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 the new performance features like columnstore indexes- Use semantic full-text search capabilities- Use sequences the same way as in Oracle- Implement analytical functions and their windowing extensions- Use the new administration tools- Implement the new security features such as contained databases- Implement improved AlwaysOn high-availability features- Describe the new features in SQL Server Business Intelligence components- Describe the new tools and services of SQL Server
Schulungsinhalte


· New Performance Features
Columnstore indexes . Batch processing mode . Indirect checkpoint . FileTable tables . Semantic full-text search . Other changes in the full-text . Improvements to partitioning . Improvements in SQLOS

· New T-SQL Features
Sequences . Paging records - OFFSET AND FETCH . FORMAT function and TRY_CONVERT . New analytical features and enhancements in OVER clause () . WITH RESULT SETS . THROW statement in error handling . Integration with .NET 4.0 . Otherimprovements

· New Administration Features
New editions of SQL Server . Improvements in Management Studio . Distributed Replay Utility . New and modified DMVs . Changes in the installation of SQL Server . Changes in other SQL Server tools

· New Security Features
Contained databases . User-defined server roles . Audit for all editions and its customization . New hash algorithms . Removed support for HTTP / SOAP endpoints . Other changes in security

· New High-Availability Features
AlwaysOn and Availability Groups . Mirroring to four replicas/mirrors . Coordinated failover . Geo-clustering . Quick application failover through AG listeners . Other improvements

· New Features in Business Intelligence
New features in Analysis Services (tabular model, PowerPivot, DAX, ...) . New features in Reporting Services (Power View, Data Alerts, ...) . New features in Integration Services (new transformations, analyses, usability ...) . Data Quality Services .
Zielgruppe
Experienced database administrators and developers who plan to upgrade to SQL Server 2012, or are just interested into the new features and need to evaluate first the benefits of upgrading to the newest version.
Voraussetzungen
Good knowledge of SQL Server 2008 or 2005 administration or development.
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-Nrnfsqls12
Dauer2 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, 07.11.2016 - Fr, 11.11.2016, Münster
Webentwicklung mit HTML, CSS, JavaScript, jQuery und PHP
Garantierte Durchführung Garantierte Durchführung!