What's new in SQL Server 2012电子书

What's New in SQL Server 2012

Table of Contents

What's New in SQL Server 2012

Credits

About the Authors

Acknowledgment

Acknowledgment

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Installing SQL Server 2012

SQL Server 2012 Editions

Enterprise Edition

Standard Edition

Business Intelligence Edition

Licensing in the Cloud

Developer Edition

Express Edition

Obtaining SQL Server 2012

Evaluation

Retail

Navigating the Installation Process

Summary

2. SQL Server Administration

Management Studio keyboard shortcuts

New Dynamic Management Views (DMVs)

The new OS Volume Stats DMV

Spatial indexes

Columnstore indexes

Creating a columnstore index

Restrictions

Contained databases

Making an existing database partially contained

Migrating your logins to a contained database

Contained database security

Security management

Default schemas for groups

User defined server roles

SQL Server Audit enhancements

Master Data Services (MDS)

Summary

3. Transact SQL

String functions

CONCAT

FORMAT

Datetime functions

EOMONTH

DATEFROMPARTS

TIMEFROMPARTS

DATETIMEFROMPARTS

DATETIMEOFFSETFROMPARTS

Conversion functions

TRY_PARSE

PARSE

IIF

OFFSET and FETCH

SEQUENCE

WITH RESULT SETS

Error handling with THROW

FileTable table type

New T-SQL analytical functions

FIRST_VALUE

LAST_VALUE

LAG

LEAD

SQL Server Data Tools

Database Projects

Support for SQL Server 2005, 2008 and SQL Azure

IntelliSense and debugging

Installing SQL Server Data Tools

Installing without Visual Studio 2010 pre-installed

Installing with Visual Studio 2010 pre-installed

Creating a new project

Creating database projects

Summary

4. Analysis Services

Business Intelligence Semantic Model

The three models

Multidimensional and data mining model

Creating a multidimensional model database

Tabular model

Tabular model database

The xVelocity tabular engine mode

Creating a tabular model database

PowerPivot for the SharePoint model

Installing a model

Multidimensional and Tabular models

PowerPivot for SharePoint

Determining a previously installed model

Resource usage reporting

Extended Events for Analysis Services

String store constraint

Using scalable string storage

Summary

5. Reporting Services

Deprecated features

Power View and SharePoint modes

Minority Reporting Services

Data Alerts

Report Builder 2012

Excel Renderer for Excel 2007-2010

Word Renderer for Word 2007-2010

Summary

6. Integration Services

SSISDB – the SSIS Catalog database

Introducing the ssis_admin role

Giving users access to integration services

Fixed database-level roles

Upgrading from SQL Server 2005 and 2008

New functions

Shared connection managers

Adding a connection manager at the package level

Changing the scope of a connection manager

Enhancements to the Flat File Connection Manager

Undo and redo

Deployment models

Validating a project or package

Querying the SSISDB

Comparing and merging packages

Color coded and indicator status codes

Package execution logs

How to set up basic SSIS logging

View the results of logging

Package execution reports

Expression indicators

Change Data Capture support

Data taps

Setting up a Data Tap

Deprecated feares

Resources

Summary

7. Data Quality Services

Reasons for using Data Quality Services

Installing Data Quality Services

Enabling TCP/IP for remote access to the DQS server

Making data accessible for DQS operations

Granting a DQS role on DQS_Main for DQS users

Using Data Quality Services

Understanding domains

Coupling rules to data: the Data Quality Project

Identifying invalid records and columns

DQS versus T-SQL

Resources

Summary

8. AlwaysOn

Mirroring, clustering and availability groups

Availability groups

Availability group restrictions

Availability group advantages

Using availability groups

Summary

9. Distributed Replay

Terminology

Distributed Replay

Trace file

Intermediate file

Controller

Client

Target

DReplay

Architecture

Distributed Replay – a hands on example

Installation

Usage

Capture

Preprocess

Replay

Configuration

Monitoring

Canceling

Additional resources

Summary

10. Big Data and the Cloud

Measure twice, cut once

SQL Azure: SQL Server in the cloud

Reasons for migrating to the cloud

SQL Azure suitability

How SQL Azure differs from hosted web and database services

Differences between a public and private cloud

Migrating a database to SQL Azure

Public cloud costs

Differences between SQL Azure and SQL Server Standard/Enterprise editions

Using SQL Azure

New skills

SQL Azure and the future of databases

Big data and Hadoop: horses for courses

What is big data?

The need for big data platforms

Is SQL Server redundant?

About Hadoop

About Hive

Differences in the Microsoft environment

Hadoop and OLTP

Getting started with Hadoop

The Microsoft Hadoop/Sqoop connector

Notes on the Microsoft Hadoop/Sqoop connector

Summary

A final word from the authors

Index