Free Sample
+ Collection

What's New in SQL Server 2012

Starting
Rachel Clements, Jon Reade

Unleash the new features of SQL Server 2012 with this book and ebook.
$20.99
$34.99
RRP $20.99
RRP $34.99
eBook
Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849687348
Paperback238 pages

About This Book

  • Upgrade your skills to the latest version of SQL Server
  • Discover the new dimensional model in Analysis Services
  • Utilize data alerts and render reports to the latest versions of Excel and Word
  • Build packages to leverage the new features in the Integration Services environment
  • Plan, load and simulate real-world database activity using Distributed Replay

Who This Book Is For

This concise reference is for database administrators, SQL Server Developers and BI professionals. Anyone who is familiar with SQL Server 2008 R2 and needs to make the jump to the latest version with the shortest learning curve will find this book useful.

Table of Contents

Chapter 1: Installing SQL Server 2012
SQL Server 2012 Editions
Summary
Chapter 2: SQL Server Administration
Management Studio keyboard shortcuts
Security management
Master Data Services (MDS)
Summary
Chapter 3: 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
Chapter 4: Analysis Services
Business Intelligence Semantic Model
The three models
Resource usage reporting
Extended Events for Analysis Services
String store constraint
Summary
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: AlwaysOn
Mirroring, clustering and availability groups
Summary
Chapter 9: Distributed Replay
Terminology
Architecture
Distributed Replay – a hands on example
Installation
Usage
Additional resources
Summary
Chapter 10: 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

What You Will Learn

  • Learn how to install SQL Server 2012 core database features and advanced services
  • Master day to day administration tasks in the new SQL Server Management Studio
  • Take command of Transact SQL’s new keywords and functions
  • Explore the SQL Server Data Tools (SSDT) new development environment
  • Find out about the new FileTable data type
  • Learn about the Business Intelligence Semantic Models (BISM) in Analysis Services
  • Take advantage of Reporting Services Data Alerts
  • Find out about the new SSIS catalog, the SSIS Admin security role and how to upgrade from previous versions
  • Create a Data Quality Services (DQS) project and cleanse real-world data
  • Understand the new AlwaysOn Availability Features
  • Test new hardware and vendor upgrades using Distributed Replay
  • Discover the forthcoming Hadoop data platform and how to migrate to SQL Azure

In Detail

Microsoft SQL Server has been part of the enterprise database landscape since SQL Server 7 arrived in 1998 and has evolved into the relational and BI platform of choice by businesses around the globe. The performance and full feature set of SQL Server has been widely recognized by the business community and it is viewed as a powerful weapon in their database and business intelligence arsenal. SQL Server brings numerous benefits to all businesses, central to which is a thorough understanding of the technology, both current and new.

This is the book both DBAs and developers always wanted to buy but could never find in the bookstore. This is a SQL Server book that contains only the new features introduced in SQL Server 2012.

This book will give you a competitive advantage by helping you to quickly learn and understand the new features of SQL Server 2012. Most readers will already have an established knowledge of SQL Server and will want to update their 2008/2008R2 knowledge swiftly with least pain.

This book takes you through all of the new features of SQL Server 2012, from installing core database services and features, to the new administration and updated Transact-SQL functions. You will discover the new Analysis Services features, introduce data alerts and reporting features and explore the new enhancements to Integration Services. In addition you will learn how to automate, cleanse and transform critical business data with DQS and world-class enterprise level availability features.

Finally, you will venture into simulating real-world database loads using Distributed Replay and complete your journey with a look at the new SQL Server cloud services and the new Hadoop big data platform.

Authors

Read More