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.