Simmons / Carstarphen Pro SQL Server 2008 Administration

1. ed
ISBN: 978-1-4302-2374-0
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 592 Seiten

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server. Introduces new administration features of SQL Server 2008 Shows how to manage a SQL Server 2008 database at professional level Provides guidance on performance optimization

Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005. Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.

Autoren/Hrsg.

Simmons, Ken

Carstarphen, Sylvester

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;7
3;About the Authors;19
4;About the Technical Reviewer;20
5;Acknowledgments;21
6;Introduction;22
6.1;Who Should Read This Book;22
6.2;How the Book Is Structured;22
6.3;Downloading the Code;22
6.4;Contacting the Authors;23
7;Introducing Microsoft SQL Server 2008;24
7.1;New Feature Overview;25
7.1.1;Scalability Enhancements;26
7.1.2;Manageability Enhancements;27
7.1.3;Availability Enhancements;30
7.1.4;Programmability Enhancements;32
7.1.5;Security Enhancements;42
7.1.6;Summary;42
7.2;Pre-Installation Considerations;43
7.2.1;Choosing a SQL Server Edition;43
7.2.2;Determining Hardware Requirements;49
7.2.3;SQL Server Consolidation;60
7.2.4;Consolidation with Virtual Servers;62
7.2.5;Summary;63
7.3;Choosing a High-Availability Solution;64
7.3.1;What Exactly Is High Availability Anyway?;64
7.3.2;Failover Clustering;65
7.3.3;Database Mirroring;69
7.3.4;Copying Data with Log Shipping;74
7.3.5;Making Data Available Through Replication;77
7.3.6;Other High- Availability Techniques;84
7.3.7;High Availability Feature Comparison;85
7.3.8;Summary;86
8;Getting Started;87
8.1;Installing Microsoft SQL Server 2008;88
8.1.1;User Accounts;89
8.1.2;Preparation and Prerequisites;89
8.1.3;SQL Server Installation Center;90
8.1.4;Installing Your First Instance;97
8.1.5;Installing More Than One Instance;109
8.1.6;Command- Line Installation;114
8.1.7;Configuration File Installation;123
8.1.8;Summary;129
8.2;Upgrading to Microsoft SQL Server 2008;130
8.2.1;Upgrade Tools;130
8.2.2;SQL Server Integration Services;138
8.2.3;Upgrade Strategies;139
8.2.4;Post- Upgrade Procedures;157
8.2.5;Summary;160
8.3;Post-Installation;161
8.3.1;SQL Server Configuration Manager;161
8.3.2;Configuring the Instance;175
8.3.3;Preproduction Tasks;188
8.3.4;Summary;191
9;Administering Microsoft SQL Server 2008;192
9.1;Multi-Server Administration;193
9.1.1;Policy- Based Management;193
9.1.2;Central Management Servers;205
9.1.3;SQL Dependency Reporting;215
9.1.4;Summary;223
9.2;Managing Security Within the Database Engine;224
9.2.1;Security Language;224
9.2.2;Creating SQL Server Principals;226
9.2.3;Database Security;231
9.2.4;Securables;235
9.2.5;Permissions;240
9.2.6;GUI Security Administration;242
9.2.7;Encryption;257
9.2.8;Summary;264
9.3;Administering Database Objects;265
9.3.1;Database 101;265
9.3.2;Working with System Databases;266
9.3.3;Working with Database Snapshots;267
9.3.4;Working with Tables;271
9.3.5;Working with Views;286
9.3.6;Working with Synonyms;291
9.3.7;Working with Stored Procedures;294
9.3.8;Working with Functions;300
9.3.9;Working with Triggers;304
9.3.10;Working with the Common Language Runtime;307
9.3.11;Summary;309
9.4;Indexing for Performance;310
9.4.1;Index Vocabulary, Structure, and Concepts;310
9.4.2;Creating Indexes via T- SQL;317
9.4.3;Creating Indexes Using the GUI;329
9.4.4;Post- Index Creation;337
9.4.5;Putting It All Together;342
9.4.6;Summary;354
9.5;Managing Backups;355
9.5.1;Recovery Models;355
9.5.2;Backup Architecture;356
9.5.3;Backup Types;358
9.5.4;Backup Compression;365
9.5.5;Logical Backup Devices;367
9.5.6;The GUI Backup Interface;370
9.5.7;Backups from T- SQL;376
9.5.8;Using Encryption;378
9.5.9;Backing Up the System Databases;379
9.5.10;Backup History;381
9.5.11;Summary;382
9.6;Restore and Recovery Strategies;383
9.6.1;Restore Vocabulary;383
9.6.2;The Importance of Recovery Models;384
9.6.3;Practicing Your Recovery Strategy;385
9.6.4;Types of Restores;386
9.6.5;Online Recoveries;395
9.6.6;Restore Considerations;395
9.6.7;Recovery Examples;397
9.6.8;Summary;423
9.7;Automating Routine Maintenance;424
9.7.1;Database Mail;424
9.7.2;SQL Server Agent;437
9.7.3;Maintenance Plans;452
9.7.4;Summary;458
10;Troubleshooting and Tuning;459
10.1;Monitoring Your Server;460
10.1.1;Baseline Your Server;460
10.1.2;Familiarizing Yourself with the Performance Monitor;461
10.1.3;Monitoring Your CPU;463
10.1.4;Monitoring Your Memory;471
10.1.5;Monitoring Disk IO;478
10.1.6;Monitoring Miscellaneous Counters and DMVs;481
10.1.7;Capturing SQL Server PerfMon Counters Using DMVs;481
10.1.8;Leveraging the SQL Server Profiler;481
10.1.9;Using Server- Side Tracing;484
10.1.10;Automating Your Monitoring;486
10.1.11;Summary;487
10.2;Auditing SQL Server;488
10.2.1;Choosing Your Audit Type;488
10.2.2;Creating SQL Server Audits with T- SQL;489
10.2.3;Creating Server Audit Specifications;490
10.2.4;Creating Database Audit Specifications;493
10.2.5;Creating SQL Server Audits Using the GUI;498
10.2.6;Audit- Related Startup and Shutdown Problems;502
10.2.7;Useful SQL Server Audit Objects;503
10.2.8;Summary;503
10.3;Managing Query Performance;504
10.3.1;Correlating Profiler and the Performance Monitor;504
10.3.2;Finding Similar Queries;506
10.3.3;Running the Standard Performance Reports;508
10.3.4;Optimizing for Specific Parameter Values;510
10.3.5;Forcing Index Seeks;513
10.3.6;Forcing a Specific Execution Plan;515
10.3.7;Adding Hints Through Plan Guides;516
10.3.8;Managing Resources with the Resource Governor;520
10.3.9;Monitoring Resource Governor;528
10.3.10;Summary;532
11;Conclusion;533
11.1;Secrets to Excelling As a Professional DBA;534
11.1.1;Be Good at What You Do;534
11.1.2;Go Above and Beyond;536
11.1.3;Communicate Effectively;537
11.1.4;Remain Calm Under Pressure;539
11.1.5;Be an Effective Leader;541
11.1.6;Summary;543
11.2;What’s Next?;544
11.2.1;Ongoing Experimentation and Learning;544
11.2.2;Podcasts;545
11.2.3;Free Training Events;545
11.2.4;SQL Support Options;546
11.2.5;Web Sites Dedicated to SQL Server;549
11.2.6;Apress Titles for Specialized Topics;549
11.2.7;Summary;550
12;Index;551