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 Unleashed
Buy the print version of¿ and get the eBook version for free! eBook version includes chapters …
book
Pro SQL Server 2012 Integration Services
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, …
book
Microsoft® SQL Server® 2012 Integration Services
Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services …
book
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
With Microsoft SQL Server 2016, a variety of new features and enhancements to the data platform …