Microsoft.SQL.Server.2008.R2.Unleashed

5星(超过95%的资源)
所需积分/C币:50 2015-08-28 22:57:39 47.93MB PDF
16
收藏 收藏
举报

Microsoft.SQL.Server.2008.R2.Unleashed,英文版
Microsoft SQL Server 2008 R2 Unleashed Publisher Copyright o 2011 by Pearson Education, Inc Paul Boger All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, Editor In Chief or otherwise, without written permission from the publisher. No patent liability is Karen gettman assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author Acquisitions Editor assume no responsibility for errors or omissions. Nor is any liability assumed for Neil rowe damages resulting from the use of the information contained herein SBN13:9780672330568 Development Editor SBN-10:0-67233056-3 Mark renfrow Library of Congress Cataloging-in-Publication Data is on file Managing Editor Sandra schroeder Printed in the United states of america First Printing september 2010 Project Editor Trademarks Seth Kerney All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the Chuck Hutchinson validity of any trademark or service mark Indexer Warning and Disclaimer Erika millen Every effort has been made to make this book as complete and as accurate as possi ble, but no warranty or fitness is implied. The information provided is on an"as is Proofreader basis. The author(s) and the publisher shall have neither liability nor responsibility to Leslie Joseph any person or entity with respect to any loss or damages arising from the information Debbie williams contained in this book or from the use of the CD or programs accompanying it. Bulk sales Technical Editor Pearson offers excellent discounts on this book when ordered in quantity for bulk Rebecca m. riordan purchases or special sales. For more information, please contact 」. Boyd no|an U.S. Corporate and Government sales Publishing 1800-3823419 Coordinator corpsales@pearsontechgroup.com Romney French For sales outside of the U.S., please contact International sales Multimedia Develope +13175813793 Dan scherf ternational@pearsontechgroup.com Designer Compositor Mark shira Contents at a Glance Introduction...........w.......... Part I Welcome to Microsoft SQL Server 1 SQL Server 2008 Overview. 2 What's New in SQL Server 2008 35 3 Examples of sQl server Implementations 51 Part I SQL Server Tools and Utilities 4 SQL Server Management Studio ... 5 SQL Server command-Line utilities 103 6 SQL Server profiler 121 Part Il SQL Server Administration 7 SQL Server System and Database Administration.………………165 8 Installing sql server 2008 185 9 Upgrading to SQL Server2008……… 27 10 Client Installation and configuration 263 11 Security and User Administration…………………………… 291 12 Data Encryption .335 13 Security and compliance......... 14 Database Backup and restore......... 377 15 Database mail .427 16 SQL Server Scheduling and Notification 449 17 Administering sql server 2008 with Power Shell 481 18 SQL Server High Availability 523 19 Replication .545 20 Database mirroring…… .617 21 SQL Server Clustering .655 22 Administering Policy-Based Management .687 Part v Database administration 23 Creating and managing databases 709 24 Creating and Managing Tables 741 25 Creating and managing indexes 791 26 Implementing data Integrity ∴811 27 Creating and managing views in sol server 837 28 Creating and managing stored procedures 869 29 Creating and Managing User-Defined Functions.……………………917 30 Creating and Managing Triggers.…………………..949 31 Transaction Management and the Transaction Log.…………………995 32 Database snapshots 1043 33 Database maintenance 1069 Part V SQL Server Performance and Optimization 34 Data Structures. Indexes, and performance.................1091 35 Understanding Query Optimization.……… 1209 36 Query Analysis 1301 37 Locking and performance 1341 38 Database design and performance 1403 39 Monitoring SQL Server Performance.…………… 1427 40 Managing workloads with the resource governor...........1493 41 A Performance and Tuning Methodology.……………….1519 Chapters on the CD Part V SQL Server Application Develop- ment 42 What's New for Transact-SQL in SQL Server 2008 1551 43 Transact-sQL Programming Guidelines, Tips, and Tricks 1637 44 Advanced Stored Procedure Programming and Optimization....1733 45 SQL Server and the. NET Framework 1787 46 SQLCLR: Developing SQL Server Objects in. NET 1825 47 Using XML in SQL Server 2008 1865 48 SQL Server Web services 1927 49 SQL Server Service Broker 1959 50 SQL Server Full-Text search 1997 Part VII SQL Server Business Intelligence Features 51 SQL Server 2008 Analysis Services 2029 52 SQL Server Integration Services 2099 53 SQL Server 2008 Reporting Services 2169 Part vIl Bonus Chapters 54 Managing Linked and Remote Servers 243 55 Configuring, Tuning, and Optimizing SQL Server Options.………2273 56 SQL Server Disaster recovery planning.…… 2329 2353 Contents Table of contents Introductio Part I Welcome to Microsoft SQL Server SQL Server 2008 Overview SQL Server Components and features 9 The sql server database engine... .10 SQL Server 2008 Administration and Management Tools .12 Replication .15 Database Mirroring.………….….17 Full-Text search .17 SQL Server Integration Services(SSIS)……………………18 SQL Server Analysis services(SSAS)……… .19 SQL Server reporting Services(SSRS)………20 SOL Server service broker SQL Server 2008 R2 Editions...... 23 SQL Server 2008 Standard edition 23 SQL Server 2008 Enterprise Edition 24 Differences between the enterprise and Standard editions of SQL Server Other SQL Server 2008 Editions .26 SQL Server licensing models 30 Web edition 32 Developer Edition Licensing…… Express Edition Licensing 32 Compact Edition3.5 Licensing………… ∴32 g Licensing model 32 Mixing licensing models Passive server/ Failover licensing………… 33 Virtual Server Licensing Multiple Instances of SQL Server 34 Summary 34 2 What's New in SQL Server 2008 35 New sQL Server 2008 Features New storage features New Data Types New Transact-SQL Constructs lew performance features 38 New security features 39 New Database administration Features. ,...........................................40 New sQL Server Management Studio Features PowerShell Integration 42 New Premium SQL Server editions...............42 SQL Server Utility for Multiserver management 43 Power Pivot for excel and share point ting ser 44 SQL Server 2008 Enhancements 45 SQL Server management studio Dynamic managementⅤiews.… .45 Database Mirroring.………… 6 SQLCLR Enhancements 46 Replication enhancements 6 SQL Server Integration services enhancements.............47 Service broker enhancements .47 Analysis services enhancements Installation enhancements Deprecated Features 49 Summary ∴50 3 Examples of SQL Server Implementations 51 Application terms .52 OLTP Application Examples 53 OLTP ERP Example……… .53 OLTP Shopping mp 56 DSS Application examples .57 DSS Example one 57 DSS Example two.∴ .58 DSS Example three Summary…………… ∴61 Part I SQL Server Tools and Utilities 4 SQL Server Management Studio What's new in Ssms 63 The Integrated Environment.……… Window management 65 grated Help Administration Tools ..w.w.ww....w.0.71 Registered servers Object explo .73 Activity monitor 75 Contents og File viewer SQL Server utility Development Tools...............................85 The Query editor…………… 85 anaging Projects in SSMS 93 Integrating ssms with Source control 95 Using ssms templates…….….….….….….…… T- SQL Debugging…………… Multiserver Queries..... 101 Summary………………………………….102 5 SQL Server Command-Line Utilities 103 What's New in sQl Server Command-Line utilities............104 The sqlcmd Command- Line Utility.…….……….105 Executing the sqlcmd Utility 106 Using Scripting Variables with sqlcmd 108 The dta Command-Line utility 109 The tablediff command- Line utility.…… 112 The bcp Command- Line utility∴………… 115 The sqldiag Command- Line utility……116 The sqlservr Command- Line Utility…………18 Summary 119 6 SQL Server Profiler 121 What's New with SQL Server Profiler...........................121 SQL Server Profiler architecture 122 Creating TI .123 vents ∴125 Data columns 127 Filters 130 Executing Traces and Working with Trace Output 132 g and Exporting Tr 132 Saving trace Output to a File…………………133 Saving trace Output to a Table………………………….134 Saving the Profiler gul output 134 Importing trace Files 135 Importing a Trace File into a Trace Table 135 Analyzing Trace Output with the Database Engine Tuning Advisor138 Replaying Trace Data 4138 Defining Server-Side traces 140 Monitoring Running traces 1353 Stopping Server-Side Traces 155 Profiler Usage Scenarios………….….….….….….…,………………….….157 Analyzing Slow Stored Procedures or Queries…………157 Deadlocks, Identifying Ad Hoc Queries ∴159 Identifying Performance Bottlenecks 160 Monitoring Auto-Update Statistics Monitoring application progress 162 Summary ∴……164 Part Il SQL Server Administration 7 SQL Server System and database Administration 165 What's New in SQl Server system and database administration....165 System Administrator Responsibilities 166 ystem Databases .166 The master database 167 The resource database 168 The model data The msdb database............168 The distribution database The tempdb Database…………………………….169 Maintaining System Databases……… System Tables 170 System views Compatibility views… 172 Catalog views 175 Information schema views ∴177 Dynamic Management Views.……………179 System Stored procedures.……… 181 Useful System Stored Procedures 182 Summary... 183 8 Installing SQL Server 2008 185 What's New in Installing sQl server 2008................................................185 Installation Requirements 186 Hardware requirements...................................186 Software Requirements 188 Installation Walkthrough ········· .192 Install Screens, Step by Step 192 Other Options Available in the SQL Server Installation Center..211 Installing SQL Server Using a Configuration File.………………212 Running an automated or Manual Install..............217 Contents Installing Service Packs and Cumulative Updates.………………..218 Installing SPl from the Command line 220 Slipstream installations 222 Summary 225 9 Upgrading to SQL Server 2008 227 What' New in Upgrading SQL Server.………………………27 Using the sQL Server Upgrade advisor(UA)…………28 Getting started with the ua 229 The Analysis Wizard.…,…,…,…,…,…,…,,…,,….230 The Report viewer ∴…235 Destination: SQL Server 2008 or SQL Server 2008 R2.............236 Side-by-Side migration 236 Upgrading In- Place.……………,…,…,…,…,……………242 Upgrading Using a Configuration File ∴250 Slipstreaming Upgrades 251 Upgrading from SQL Server 7 or SQL Server 6.5..............................252 Upgrading Other SQL Server Components.…… 53 Upgrading analysis services............................253 Upgrading reporting Services……… 255 Summary……………………261 10 Client Installation and Configuration 263 What's New in Client Installation and Configuration. ............................263 Client/ Server Networking Considerations.……..…..… 264 Server network protocols 264 The server endpoint layer .267 The Role of SQL Browser............... 270 Client installation 271 Installation Requirements................................271 Installing the client Tools 271 Installing SNAC 272 Client Configuration 274 Client Configuration Using ssCm..........................275 Connection Encryption 278 Client Data Access Technologies. .......................................................279 Provider choices 280 Driver choices 281 Connecting Using the various Providers and Drivers 281 General Networking Considerations and Troubleshooting 287 Summary 289

...展开详情
试读 127P Microsoft.SQL.Server.2008.R2.Unleashed
立即下载
限时抽奖 低至0.43元/次
身份认证后 购VIP低至7折
一个资源只可评论一次,评论内容不能少于5个字
yz4066 很详细,受用。谢谢楼主
2015-11-30
回复
您会向同学/朋友/同事推荐我们的CSDN下载吗?
谢谢参与!您的真实评价是我们改进的动力~
  • 至尊王者

关注 私信
上传资源赚钱or赚积分
最新推荐
Microsoft.SQL.Server.2008.R2.Unleashed 50积分/C币 立即下载
1/127
Microsoft.SQL.Server.2008.R2.Unleashed第1页
Microsoft.SQL.Server.2008.R2.Unleashed第2页
Microsoft.SQL.Server.2008.R2.Unleashed第3页
Microsoft.SQL.Server.2008.R2.Unleashed第4页
Microsoft.SQL.Server.2008.R2.Unleashed第5页
Microsoft.SQL.Server.2008.R2.Unleashed第6页
Microsoft.SQL.Server.2008.R2.Unleashed第7页
Microsoft.SQL.Server.2008.R2.Unleashed第8页
Microsoft.SQL.Server.2008.R2.Unleashed第9页
Microsoft.SQL.Server.2008.R2.Unleashed第10页
Microsoft.SQL.Server.2008.R2.Unleashed第11页
Microsoft.SQL.Server.2008.R2.Unleashed第12页
Microsoft.SQL.Server.2008.R2.Unleashed第13页
Microsoft.SQL.Server.2008.R2.Unleashed第14页
Microsoft.SQL.Server.2008.R2.Unleashed第15页
Microsoft.SQL.Server.2008.R2.Unleashed第16页
Microsoft.SQL.Server.2008.R2.Unleashed第17页
Microsoft.SQL.Server.2008.R2.Unleashed第18页
Microsoft.SQL.Server.2008.R2.Unleashed第19页
Microsoft.SQL.Server.2008.R2.Unleashed第20页

试读结束, 可继续阅读

50积分/C币 立即下载