Register your product to gain access to bonus material or receive a coupon.
<>Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.
Detailed information on…
CD-ROM includes
Introduction
Part I Welcome to Microsoft SQL Server
1 SQL Server 2005 Overview
2 What’s New in SQL Server 2005
Part II SQL Server Tools and Utilities
3 SQL Server Management Studio
4 SQL Server Command-Line Utilities
5 SQL Server Profiler
Part III SQL Server Administration
6 SQL Server System and Database Administration
7 Installing SQL Server 2005
8 Upgrading to SQL Server 2005
9 Client Installation and Configuration
10 Security and User Administration
11 Database Backup and Restore
12 Database Mail
13 SQL Server Scheduling and Notification
14 SQL Server High Availability.
15 Replication
16 Database Mirroring
17 SQL Server Clustering
Part IV Database Administration
18 Creating and Managing Databases
19 Creating and Managing Tables
20 Creating and Managing Indexes
21 Implementing Data Integrity
22 Creating and Managing Views in SQL Server
23 Creating and Managing Stored Procedures
24 Creating and Managing User-Defined Functions
25 Creating and Managing Triggers
26 Transaction Management and the Transaction Log
27 Database Snapshots
28 Database Maintenance
Part V SQL Server Performance and Optimization
29 Indexes and Performance
30 Understanding Query Optimization
31 Query Analysis
32 Locking and Performance
33 Database Design and Performance
34 Monitoring SQL Server Performance
Part VI SQL Server Application Development
35 What’s New for Transact-SQL in SQL Server 2005
36 SQL Server and the .NET Framework
37 Using XML in SQL Server 2005
38 SQL Server Web Services
Part VII SQL Server Business Intelligence Features
39 SQL Server 2005 Analysis Services
40 SQL Server Integration Services
41 SQL Server 2005 Reporting Services
Bonus Chapters on the CD
42 Managing Linked and Remote Servers
43 Configuring, Tuning, and Optimizing SQL Server Options
44 Administering Very Large SQL Server Databases
45 SQL Server Disaster Recovery Planning
46 Transact-SQL Programming Guidelines, Tips, and Tricks
47 SQL Server Notification Services
48 SQL Server Service Broker
49 SQL Server Full-Text Search
Index
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Part I Welcome to Microsoft SQL Server
1 SQL Server 2005 Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
2 What’s New in SQL Server 2005. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
Part II SQL Server Tools and Utilities
3 SQL Server Management Studio. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
4 SQL Server Command-Line Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89
5 SQL Server Profiler. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111
Part III SQL Server Administration
6 SQL Server System and Database Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155
7 Installing SQL Server 2005 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173
8 Upgrading to SQL Server 2005 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
9 Client Installation and Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221
10 Security and User Administration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247
11 Database Backup and Restore . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 291
12 Database Mail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 339
13 SQL Server Scheduling and Notification . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 361
14 SQL Server High Availability. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 393
15 Replication. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415
16 Database Mirroring. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 481
17 SQL Server Clustering. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 515
Part IV Database Administration
18 Creating and Managing Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547
19 Creating and Managing Tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 579
20 Creating and Managing Indexes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 623
21 Implementing Data Integrity. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 641
22 Creating and Managing Views in SQL Server. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 667
23 Creating and Managing Stored Procedures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 699
24 Creating and Managing User-Defined Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 799
25 Creating and Managing Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 833
26 Transaction Management and the Transaction Log. . . . . . . . . . . . . . . . . . . . . . . . . . . . 873
27 Database Snapshots . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 919
28 Database Maintenance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 945
Part V SQL Server Performance and Optimization
29 Indexes and Performance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 969
30 Understanding Query Optimization. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027
31 Query Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1115
32 Locking and Performance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1151
33 Database Design and Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1213
34 Monitoring SQL Server Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1233
Part VI SQL Server Application Development
35 What’s New for Transact-SQL in SQL Server 2005. . . . . . . . . . . . . . . . . . . . . . . . . . . . 1273
36 SQL Server and the .NET Framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1319
37 Using XML in SQL Server 2005 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1377
38 SQL Server Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1439
Part VII SQL Server Business Intelligence Features
39 SQL Server 2005 Analysis Services. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1473
40 SQL Server Integration Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1539
41 SQL Server 2005 Reporting Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1607
Bonus Chapters on the CD
42 Managing Linked and Remote Servers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1663
43 Configuring, Tuning, and Optimizing SQL Server Options. . . . . . . . . . . . . . . . 1693
44 Administering Very Large SQL Server Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1743
45 SQL Server Disaster Recovery Planning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1771
46 Transact-SQL Programming Guidelines, Tips, and Tricks . . . . . . . . . . . . . . . . . . . 1793
47 SQL Server Notification Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1841
48 SQL Server Service Broker. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1875
49 SQL Server Full-Text Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1913
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1941
Download the sample databases and code inadvertently left off the CD