Book description
Unleash the new features of SQL Server 2012
- 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
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.
Table of contents
-
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
- Preface
- 1. Installing SQL Server 2012
- 2. SQL Server Administration
- 3. Transact SQL
- 4. Analysis Services
- 5. Reporting Services
-
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
- 7. Data Quality Services
- 8. AlwaysOn
- 9. Distributed Replay
-
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
-
Reasons for migrating to the cloud
- Big data and Hadoop: horses for courses
- Notes on the Microsoft Hadoop/Sqoop connector
- Summary
- A final word from the authors
- Index
Product information
- Title: What's New in SQL Server 2012
- Author(s):
- Release date: October 2012
- Publisher(s): Packt Publishing
- ISBN: 9781849687348
You might also like
book
Microsoft SQL Server 2012 Performance Tuning Cookbook
With this book you’ll learn all you need to know about performance monitoring, tuning, and management …
book
Microsoft Power BI Complete Reference
Design, develop, and master efficient Power BI solutions for impactful business insights Key Features Get to …
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …
book
Professional Microsoft SQL Server 2014 Integration Services
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL …