Microsoft SQL server 2012 step by step

(BQ) Like most relational database management systems (RDBMSs), Tài liệu Microsoft SQL server 2012 step by step includes several components . The product itself, however, is often divided into two distinct categories: business intel-ligence (BI) and the Database Engine.
Nội dung trích xuất từ tài liệu:
Microsoft SQL server 2012 step by step t s o f icr os e s M P r r epPublished with the authorization of Microsoft Corporation by:O’Reilly Media, Inc.1005 Gravenstein Highway NorthSebastopol, California 95472With Microsoft prePress, you can access just-written content from upcomingbooks. The chapters come straight from our respected authors, before they’refully polished and debugged—for critical insights now, when you need them.This document contains one or more portions of a preliminary version of a Microsoft Press title and is provided“as is.” The content may be changed substantially upon final publication. In addition, this document may makereference to pre-released versions of software products that may be changed substantially prior to finalcommercial release. Microsoft reserves the right to not publish this title or any versions thereof (includingfuture prePress ebooks). This document is provided for informational purposes only. MICROSOFT MAKES NOWARRANTIES, EITHER EXPRESS OR IMPLIED, IN THIS DOCUMENT. Information and views expressed in thisdocument, including URL and other Internet website references may be subject to change without notice. Youbear the risk of using it.Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights undercopyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, ortransmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), orfor any purpose, without the express written permission of Microsoft Corporation.Some examples are for illustration only and are fictitious. No real association is intended or inferred. Thisdocument does not provide you with any legal rights to any intellectual property in any Microsoft product,service, or other offering.© 2013 Patrick LeBlanc. All rights reserved.Microsoft and the trademarks listed athttp://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks ofthe Microsoft group of companies. All other marks are property of their respective owners.Contents at a glancePart I Getting started with Microsoft SQL Server 2012Chapter 1 Overview of Microsoft SQL Server 2012Chapter 2 Installing, configuring, and upgradingMicrosoft SQL Server 2012Chapter 3 Using SQL Server 2012 administration anddevelopment toolsPart II Designing databasesChapter 4 Designing SQL Server databasesChapter 5 Creating your first tableChapter 6 Building and maintaining indexesPart III Advanced database design topicsChapter 7 Table compressionChapter 8 Table partitioningChapter 9 Database snapshotsChapter 10 The SELECT statementPart IV Using Transact-SQL (TSQL)Chapter 11 Advanced data retrieval topicsChapter 12 Modifying dataChapter 13 Built-in scalar functionsPart V Creating other database objectsChapter 14 Advanced TSQL topicsChapter 15 ViewsChapter 16 User-defined functionsChapter 17 Stored proceduresChapter 18 Data manipulation triggersPart VI SQL Server replicationChapter 19 ReplicationPart VII Database maintenanceChapter 20 BackupsChapter 21 Managing and maintaining indexes and statisticsChapter 22 Maintenance plansPart VIII Database managementChapter 23 SQL Server ProfilerChapter 24 Extended eventsChapter 25 SQL Server securityChapter 26 Resource GovernorChapter 27 SQL Server AgentChapter 28 Database mailChapter 29 Data definition triggersChapter 30 Dynamic management objectsPart IX High-availability solutionsChapter 31 AlwaysOnChapter 32 Log shippingNote: Chapters included in this file are indicated in black.PAR T IGetting startedwith MicrosoftSQL Server 2012CHAPTER 1 Sections, body text, and emphasis tags . . . . . . . . . . 3CHAPTER 2 Code elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7CHAPTER 3 Using SQL Server 2012 administration anddevelopment tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 1CHAPTER 1Overview ofMicrosoft SQL Server 2012 After completing this chapter, you will be able to ■■ Explain SQL Server components and features and their uses. ■■ Identify SQL Server features vital to your environment. ■■ Define and scope your SQL Server installation topology from a high level. The process of learning a new technology can be daunting and sometimes involves a tremendous amount of time and effort. Each step of the process, from installing and configuring the software to deploying the first project, introduces new challenges. These challenges often grow when the tech- nology includes several components and features, so the first step, especially with a multicomponent technology, is to identify the components your environment requires and gain a good understanding of the functionality of each component. To that end, in this chapter, you will examine the components and features of Microsoft SQL Server 2012 and determine how they fit into your installation. Like most relational database management systems (RDBMSs), SQL Server 2012 includes several components. The product itself, however, is often divided into two distinct categories: business intel- ligence (BI) and the Database Engine.Business Intelligence Business intelligence (BI) refers to data transformed into knowledge that can then be used to make more informed business decisions. For example, a company whose primary purpose is to ...