Microsoft SQL Server 2012 Step by Step.pdf

【实例简介】
这一本学习数据库的手册，本人感觉非常的实用。
MIcrosoft Microsoft SQL Server 2012 Step by step Patrick leblanc Published with the authorization of Microsoft Corporation by O'Reilly media, Inc 1005 Gravenstein Highway North Sebastopol, California 95472 Copyright o 2013 by Patrick Leblanc All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. SBN:978-0-7356-6386-2 123456789LS|876543 Printed and bound in the united states of america Microsoft Press books are available through booksellers and distributors worldwide. If you need support related tothisbook,emailMicrosoftPressBookSupportatmspinput@microsoft.com.Pleasetelluswhatyouthinkof thisbookathttp://www.microsoft.com/learning/booksurvey. Microsoftandthetrademarkslistedathttp.://www.microsoft.com/about/legal/en/us/intellectualproperty/ Trademarks/ EN-US. aspx are trademarks of the microsoft group of companies. All other marks are property of their respective owners The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred This book expresses the authors views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, O'Reilly Media, Inc, Microsoft Corporation. nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directl or indirectly by this book Acquisitions Editor: Ken Jones Developmental Editor: Box Twelve Communications Production Editor: Melanie Yarbrough Editorial Production: Box Twelve Communications Technical Reviewer: William assaf Copyeditor: Zyg Group, LLC Indexer BIM Publishing Services Cover Design: Twist Creative. Seattle Cover Composition: Zyg Group, LLC Illustrator: Rebecca Demarest I would like to dedicate this book to my wife. When /am frustrated and just want to quit, she finds a way to motivate me and drive me to get back on track. During the writing of this book, she never complained once about the long nights of typ- ing. Instead she encouraged and supported me the whole time Thank you sweetheart for all that you do for our family. / could not have done this without you PATRICK LEBLANC Contents at a glance Introduction ⅩX PART I GETTING STARTED WITH MICROSOFT SQL SERVER 2012 CHAPTER 1 Overview of Microsoft SQL Server 2012 CHAPTER 2 Installing, Configuring, and Upgrading Microsoft SQL Server 2012 ChaPTER 3 Using SQL Server 2012 administration and development tools 21 PART I DESIGNING DATABASES CHAPTER 4 Designing SQL Server databases 35 CHAPTER 5 Creating your first table 49 CHAPTER 6 Building and maintaining indexes PARTⅢ ADVANCED DATABASE DESIGN TOPICS CHAPTER 7 Table compression 95 CHAPTER8 Table partitioning 105 chaPTeR 9 Database snapshots 117 ChaPTer 10 The select statement 123 PART V USING TRANSACT-SQL (T-SQL CHAPTER 11 Advanced data retrieval topics 141 CHAPTER 12 Modifying data 151 ChaPTEr 13 Built-in scalar functions 163 PART V CREATING OTHER DATABASE OBJECTS CHAPTER 14 Advanced T-SQL topics 175 CHAPTER 15 Views 193 CHAPTER 16 User-defined functions 203 CHAPTER 17 Stored procedures 215 CHAPTER 18 Data manipulation triggers 225 PART VI SQL SERVER REPLICATION CHAPTER 19 Replication 235 PART VII DATABASE MAINTENANCE CHAPTER 20 Backups 255 CHAPTER 21 Managing and maintaining indexes and statistics 271 CHAPTER 22 Maintenance plans 283 PART VI DATABASE MANAGEMENT CHAPTER 23 SQL Server Profiler 293 CHAPTER 24 Extended Events 303 CHAPTER 25 SQL Server security 313 CHAPTER 26 Resource governor 333 CHAPTER 27 SQL Server Agent 345 CHAPTER 28 Database mail 365 CHAPTER 29 Data definition triggers 379 CHAPTER 30 Dynamic management objects 387 PART IX HIGH-AVAILABILITY SOLUTIONS CHAPTER 31 AlwaysOn 399 CHAPTER 32 Log shipping 421 Index 433 About the author 453 vi Contents at a glance Contents Introduction ⅩX PART GETTING STARTED WITH MICROSOFT SQL SERVER 2012 Chapter 1 Overview of Microsoft SQL Server 2012 Business intelligence Database engine T-SQL programming interface .4 Security subsystem Replication SQL Server Agent High Availability and Disaster Recovery Tools SQL Server Integration Services 566788 SQL Server Management Tools Summary Chapter 2 Installing, Configuring, and Upgrading Microsoft SQL Server 2012 Editions of SQl Server 2012 Choosing hardware for SQL Server 11 Software prerequisites Before installation SQL Server instances ...12 Service accounts 13 Collation sequences 14 Authentication modes 14 Installing SQL Server Installing SQL Server from the Setup Wizard 14 After installation 17 Assigning a TCP/IP port number to the SQL Server Database Engine 17 Opening a SQL Server instance port using Windows Firewall.. 18 How to upgrade to SQL Server 2012. 19 In-place upgrade 19 Side-by-side upgrade Summary Chapter 3 Using SQL Server 2012 administration and development tools Using SQL Server Books Online .....21 Using SQL Server Management Studio .23 Using SQL Server Management Studio to create solutions and projects 26 Using SQL Server Data Tools 27 Using SQL Server Configuration Manager .30 Summary PART DESIGNING DATABASES Chapter 4 Designing SQL Server databases 35 Understanding SQl Server system databases 35 master database ...36 tempdb datab 36 model database 36 b database resource database 37 distribution database 37 Understanding the sql server database structure 38 Creating a database Q Understanding arguments 41 Adding files and filegroups Detaching and attaching SQL Server databas 44 vu Contents 【实例截图】
【核心代码】