PacktLib: What's New in SQL Server 2012

What's New in SQL Server 2012

About the Authors

About the Reviewers

www.PacktPub.com

Installing SQL Server 2012

SQL Server 2012 Editions

SQL Server Administration

Management Studio keyboard shortcuts

Security management

Master Data Services (MDS)

String functions

Datetime functions

Conversion functions

OFFSET and FETCH

WITH RESULT SETS

Error handling with THROW

FileTable table type

New T-SQL analytical functions

SQL Server Data Tools

Creating database projects

Analysis Services

Business Intelligence Semantic Model

The three models

Resource usage reporting

Extended Events for Analysis Services

String store constraint

Reporting Services

Deprecated features

Power View and SharePoint modes

Report Builder 2012

Excel Renderer for Excel 2007-2010

Word Renderer for Word 2007-2010

Integration Services

SSISDB – the SSIS Catalog database

Introducing the ssis_admin role

Fixed database-level roles

Shared connection managers

Enhancements to the Flat File Connection Manager

Deployment models

Comparing and merging packages

Color coded and indicator status codes

Package execution logs

Package execution reports

Expression indicators

Change Data Capture support

Deprecated feares

Data Quality Services

Reasons for using Data Quality Services

Installing Data Quality Services

Using Data Quality Services

Coupling rules to data: the Data Quality Project

Mirroring, clustering and availability groups

Distributed Replay

Distributed Replay – a hands on example

Additional resources

Big Data and the Cloud

Measure twice, cut once

SQL Azure: SQL Server in the cloud

Big data and Hadoop: horses for courses

Notes on the Microsoft Hadoop/Sqoop connector

A final word from the authors