What's New in SQL Server 2012

Unleash the new features of SQL Server 2012 with this book and ebook.

What's New in SQL Server 2012

Rachel Clements, Jon Reade

Unleash the new features of SQL Server 2012 with this book and ebook.
Mapt Subscription
FREE
$30.00/m after trial
eBook
$10.00
RRP $20.99
Save 52%
Print + eBook
$34.99
RRP $34.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$10.00
$34.99
$29.99 p/m after trial
RRP $20.99
RRP $34.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


What's New in SQL Server 2012 Book Cover
What's New in SQL Server 2012
$ 20.99
$ 10.00
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide Book Cover
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
$ 29.99
$ 10.00
Buy 2 for $20.00
Save $30.98
Add to Cart

Book Details

ISBN 139781849687348
Paperback238 pages

Book Description

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.

Table of Contents

Chapter 1: Installing SQL Server 2012

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

Authors

Table of Contents

Chapter 1: Installing SQL Server 2012

Book Details

ISBN 139781849687348
Paperback238 pages
Read More

Read More Reviews

Recommended for You

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide Book Cover
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
$ 29.99
$ 10.00
SQL Server Analysis Services 2012 Cube Development Cookbook Book Cover
SQL Server Analysis Services 2012 Cube Development Cookbook
$ 35.99
$ 10.00
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 10.00
Desire2Learn for Higher Education Cookbook Book Cover
Desire2Learn for Higher Education Cookbook
$ 26.99
$ 10.00
Android Native Development Kit Cookbook Book Cover
Android Native Development Kit Cookbook
$ 29.99
$ 10.00
Construct 2 Game Development by Example Book Cover
Construct 2 Game Development by Example
$ 26.99
$ 10.00