PacktLib: What's New in SQL Server 2012

What's New in SQL Server 2012

Credits

About the Authors

Acknowledgment

Acknowledgment

About the Reviewers

www.PacktPub.com

Preface

Installing SQL Server 2012

SQL Server 2012 Editions

Summary

SQL Server Administration

Management Studio keyboard shortcuts

Security management

Master Data Services (MDS)

Summary

Transact SQL

String functions

Datetime functions

Conversion functions

OFFSET and FETCH

SEQUENCE

WITH RESULT SETS

Error handling with THROW

FileTable table type

New T-SQL analytical functions

SQL Server Data Tools

Creating database projects

Summary

Analysis Services

Business Intelligence Semantic Model

The three models

Resource usage reporting

Extended Events for Analysis Services

String store constraint

Summary

Reporting Services

Deprecated features

Power View and SharePoint modes

Data Alerts

Report Builder 2012

Excel Renderer for Excel 2007-2010

Word Renderer for Word 2007-2010

Summary

Integration Services

SSISDB – the SSIS Catalog database

Introducing the ssis_admin role

Fixed database-level roles

New functions

Shared connection managers

Enhancements to the Flat File Connection Manager

Undo and redo

Deployment models

Comparing and merging packages

Color coded and indicator status codes

Package execution logs

Package execution reports

Expression indicators

Change Data Capture support

Data taps

Deprecated feares

Resources

Summary

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

Resources

Summary

AlwaysOn

Mirroring, clustering and availability groups

Summary

Distributed Replay

Terminology

Architecture

Distributed Replay – a hands on example

Installation

Usage

Additional resources

Summary

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

Summary

A final word from the authors

Index