探索Microsoft SQL Server 2012：全新技术与实践指南

需积分: 11 71 浏览量更新于2024-07-26 收藏 10.73MB PDF 举报

《Microsoft SQL Server 2012介绍》由Microsoft Press出版，是 Ross Mistry 和 Stacia Misner 联合编著的一本专著，作为Microsoft Corporation的一部分，它反映了Microsoft在数据库管理系统领域的最新发展。该书于2012年发行，享有Microsoft Corporation的版权，所有内容未经许可不得复制或传播。本书的核心主题围绕Microsoft SQL Server 2012，这是Microsoft针对企业级数据库管理和分析的一款重要产品。SQL Server 2012在功能上进行了重大提升，包括但不限于性能优化、安全性增强、集成度改进以及对云计算和大数据的支持。它旨在帮助用户更有效地处理大规模数据，提供高度可靠的数据存储与管理解决方案，支持企业级应用的开发和运行。书中详细介绍了SQL Server 2012的新特性，如透明数据加密(TDE)以保护敏感数据，列级压缩技术提高存储效率，以及Power Pivot和Power Query工具的强大数据分析能力。此外，该版本还强调了其与Windows Azure的紧密集成，使用户能够轻松地将数据部署到云端，实现弹性扩展和灾难恢复。书中还涵盖了安装、配置、管理和维护SQL Server 2012的相关知识，以及如何设计高效的数据架构，同时对SQL Server的T-SQL语言进行了深入讲解，让读者能够充分利用其强大的查询和编程能力。对于开发者来说，书中提供了丰富的示例代码和实用技巧，以便快速上手并提升工作效率。值得注意的是，本书中的案例公司、组织、产品、域名等均为虚构，目的是为了便于教学和演示，实际应用时应根据具体情况进行调整。读者可以通过联系Microsoft Press Book Support获取更多支持，或者通过官方网站上的反馈链接分享对本书的评价。《Microsoft SQL Server 2012》是一本全面而深入的指南，不仅适合数据库管理员、IT专业人员，也适合希望深入了解数据库技术的开发人员，帮助他们理解和利用这一重要的企业级数据库平台。随着技术的发展，虽然SQL Server的版本可能有所更新，但本书的基本原则和学习价值依然具有参考价值。

xvi Introduction

How Is This Book Organized?

SQL Server 2012, like its predecessors, is more than a database engine. It is a collection of

components you can implement either separately or as a group to form a scalable, cloud-ready

information platform. In broad terms, this cloud-ready information platform consists of two

categories: those that help you manage data and those that help you deliver business intelligence (BI).

Accordingly, we divided this book into two parts to focus on the new capabilities for each of these

areas.

Part 1, “Database Administration,” is written with the database administrator (DBA) in mind and

introduces readers to the numerous innovations in SQL Server 2012. Chapter 1, “SQL Server 2012

Editions and Engine Enhancements,” discusses the key enhancements afliated with availability, scal-

ability, performance, manageability, security, and programmability. It then outlines the different SQL

Server 2012 editions, hardware and software requirements and installation, upgrade, and migration

strategies available. In Chapter 2, “High-Availability and Disaster-Recovery Enhancements” readers

learn about the new AlwaysOn features in SQL Server 2012—specically, AlwaysOn Availability Groups

and how they can be used to achieve a high level of condence in your data and related capabilities.

Chapter 3, “Performance and Scalability,” introduces a new index type called columnstore and explains

how it can be leveraged to signicantly accelerate data-warehousing workloads and other queries

that are similar in nature. Chapter 4, “Security Enhancements,” covers the new security enhancements

associated with the product, such as security manageability improvements and audit and authenti-

cation enhancements. Finally, Chapter 5, “Programmability and Beyond-Relational Enhancements,”

discusses the new beyond-relational enhancements positively impacting unstructured data, including

renements to existing technology features such as full-text search, spatial data, and FILESTREAM, as

well as brand new capabilities like FileTables and statistical semantic search.

Part 2, “Business Intelligence Development,” is written for readers who need to understand how

SQL Server 2012 can help them more easily perform data integration, data quality improvements,

master data management, data analysis, and reporting tasks. Chapter 6, “Integration Services,”

explores the comprehensive changes in this release affecting development, deployment, and admin-

istration of Integration Services packages. In Chapter 7, “Data Quality Services,” readers learn about

the newest BI component available in SQL Server 2012 for centralizing data-quality activities, includ-

ing how to store data-quality rules in a knowledge base and how to automate the discovery of rules.

Chapter 8, “Master Data Services,” reviews the improved interface of this feature that simplies the

implementation, workows, and administration of master data management. Chapter 9, “Analysis

Services and PowerPivot,” introduces the new tabular server mode, shows how to develop tabular

models, and describes enhancements to the Analysis Services platform and PowerPivot for Excel

capabilities. Last, Chapter 10, “Reporting Services,” covers the improvements in SharePoint integration

and details the self-service capabilities available with the new ad hoc reporting tool, Power View.

Introduction xvii

Conventions and Features in This Book

This book presents information using the following conventions, which are designed to make the

information more readable and easy to follow:

■

Each exercise consists of a series of tasks, presented as numbered steps (1, 2, and so on) listing

each action you must take to complete the exercise.

■

Boxed elements with labels such as “Note” provide additional information or alternative

methods for completing a step successfully.

■

Text that you type (apart from code blocks) appears in bold.

■

Transact-SQL code is used to help you further understand a specic example.

Pre-Release Software

To help you get familiar with SQL Server 2012 as early as possible after its release, we wrote this book

using examples that work with the Release Candidate 0 (RC0) version of the product. Consequently,

the nal version might include new features, and features we discuss might change or disappear.

Refer to the “What’s New in SQL Server 2012” topic in Books Online for SQL Server at

http://msdn.microsoft.com/en-us/library/ms130214%28v=sql.110%29.aspx for the most up-to-date

list of changes to the product. Be aware that you might also notice some minor differences between

the RTM version of the product and the descriptions and screen shots that we provide.

Acknowledgments

First, I would like to thank my colleagues at Microsoft Press and O’Reilly Media for providing me

with another great authorship opportunity and putting together a stellar product in such a short

period of time. Special thanks goes out to Devon Musgrave, Colin Lyth, Karen Szall, Carol Dillingham,

Steve Sagman, Mitch Tulloch, Roger LeBlanc, Christina Yeager, Anne Hamilton, Steve Weiss, and Ken

Jones. The publishing team’s support throughout this engagement is much appreciated.

Second, I would like to thank my immediate family for being very patient and understanding

considering I was absent from their lives on many evenings and weekends while I worked on this

book. I couldn’t have done this title without their love and support.

I would also like to acknowledge Shirmattie Seenarine for assisting me on this title. Shirmattie’s hard

work, contributions, edits, and rewrites are much appreciated. And to my author partner, Stacia

Misner, I want to thank you for once again doing an excellent job on the business intelligence part of

this book.

Finally, this book would not have been possible without support from my colleagues on the SQL

Server team who provided introductions, strategic technology guidance, technical reviews, and edits.

I would like to thank the following people: Tiffany Wissner, Quentin Clark, Joanne Hodgins, Justin

xviii Introduction

Erickson, Santosh Balasubramanian, Gopal Ashok, Goden Yao, Jack Richins, Susan Price, Michael Rys,

Srini Acharya, Darmadi Komo, and Luis Daniel Soto Maldonado.

–Ross Mistry

I, too, want to thank the entire team that has supported Ross and me through yet another publication.

It is a pleasure to collaborate again with all of you and with Ross. I look forward to future opportuni-

ties should they arise!

Each of the product teams has been very helpful, and I am grateful for their assistance and

appreciative of the products they have developed. In particular, I wish to thank Matt Masson,

Akshai Mirchandani, Marius Dumitru, and Thierry D’hers for their amazing responsiveness to my

questions because I know they are very busy people.

This is the rst book for which my husband did not have the opportunity to demonstrate his

seemingly unending supply of patience with me because he was busy in another state preparing a

new home for us. Therefore, I can’t really thank him for his support of this book in the typical sense,

but I can thank him for ensuring that I will have a comfortable place in which to work and write later

this year. He gives me great peace of mind and fuels my anticipation of things to come!

–Stacia Misner

Errata & Book Support

We’ve made every effort to ensure the accuracy of this book and its companion content. Any

errors that have been reported since this book was published are listed on our Microsoft Press site at

oreilly.com:

http://go.microsoft.com/FWLink/?Linkid=245673

If you nd an error that is not already listed, you can report it to us through the same page. If you

need additional support, email Microsoft Press Book Support at mspinput@microsoft.com.

Please note that product support for Microsoft software is not offered through the addresses above.

We Want to Hear from You

At Microsoft Press, your satisfaction is our top priority, and your feedback our most valuable asset.

Please tell us what you think of this book at:

http://www.microsoft.com/learning/booksurvey

The survey is short, and we read every one of your comments and ideas. Thanks in advance for

your input!

Stay in Touch

Let’s keep the conversation going! We’re on Twitter: http://twitter.com/MicrosoftPress.

剩余287页未读，继续阅读

huangyiye

粉丝: 0
资源: 14

探索Microsoft SQL Server 2012：全新技术与实践指南

Microsoft.Press.Introducing.Microsoft.SQL.Server.2012.Mar.2012.rar

Microsoft SQL Server 2012简介Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2008.pdf

有没有sqlserver2022的书籍

Microsoft SQL Server 2014简介Introducing Microsoft SQL Server 2014

Microsoft_Press_eBook_Introducing_Microsoft_SQL_Server_2012

Introducing Microsoft SQL Server 2008 sql2008 数据库

Introducing Microsoft SQL Server 2016.pdf

Introducing Microsoft SQL Server 2008 R2

spark_3_2_0-master-3.2.3-1.el7.noarch.rpm

最新资源