Coles / Ferracchiati / Walters Accelerated SQL Server 2008

1. ed
ISBN: 978-1-4302-0606-4
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 816 Seiten

Accelerated SQL Server 2008 is a fast introduction to SQL Server 2008 for experienced database professionals. The book will appeal to readers who are smart, who learn fast, and who do not want to wade through a large amount of introductory material. The goal is to impart the essentials of using SQL Server 2008 as quickly as possible.

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Autoren/Hrsg.

Coles, Michael

Ferracchiati, Fabio Claudio

Walters, Robert

Farmer, Chris

Rae, Jonathan

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;7
3;About the Authors;20
4;Acknowledgments;22
5;Introduction;23
5.1;Who This Book Is For;24
5.2;Valuable Resources;24
5.3;How This Book Is Structured;25
5.4;Errata;27
5.5;Contacting the Authors;27
6;Overview of SQL Server;28
6.1;SQL Server 2008 Overview;29
6.1.1;The Vision of SQL Server 2008;29
6.1.2;SQL Server 2008 Editions;31
6.1.3;A Word on Server Consolidation;32
6.1.4;Summary;33
6.2;SQL Server Installation and Configuration;35
6.2.1;SQL Server Requirements;35
6.2.2;Upgrading to SQL Server 2008;36
6.2.3;Summary;49
7;Enterprise Data Platform;50
7.1;Policy Management;51
7.1.1;Needs Addressed by Policy Management;51
7.1.2;Policy Management Components;52
7.1.3;Sample Policies;62
7.1.4;Policy Management Administration;66
7.1.5;Summary;69
7.2;High Availability;70
7.2.1;High Availability Defined;71
7.2.2;Database Mirroring;72
7.2.3;Database Snapshots and Mirroring;94
7.2.4;Windows Clustering in SQL Server;99
7.2.5;SQL Server Replication;99
7.2.6;Reducing Planned Downtime;102
7.2.7;Summary;103
7.3;Performance;104
7.3.1;Managing and Monitoring Resources;104
7.3.2;Optimizing Storage;117
7.3.3;Improving Query Performance;124
7.3.4;Summary;131
7.4;Security;132
7.4.1;Disabled Database Engine Features;132
7.4.2;Principals and Securables;137
7.4.3;Permissions;147
7.4.4;Code Access Security;151
7.4.5;Auditing in SQL Server 2008;155
7.4.6;Summary;163
7.5;SQL Server Encryption;164
7.5.1;Encryption Keys;165
7.5.2;Transparent Data Encryption;179
7.5.3;Extensible Key Management;182
7.5.4;Encryption Without Keys;182
7.5.5;Hashing and Signing Data;183
7.5.6;Security Catalog Views;184
7.5.7;Query Efficiency;185
7.5.8;Summary;186
7.6;Automation and Monitoring;187
7.6.1;SQL Server Agent;188
7.6.2;Maintenance Plans;206
7.6.3;SQLCMD;214
7.6.4;PowerShell for SQL Server;217
7.6.5;Database Mail;224
7.6.6;SQL Profiler;230
7.6.7;Extended Events;236
7.6.8;Summary;241
7.7;Service Broker;243
7.7.1;What Is Service Broker?;244
7.7.2;Creating Service Broker Applications;247
7.7.3;Service Broker Routing and Security;258
7.7.4;Message Priorities;280
7.7.5;Troubleshooting Service Broker Using SSBDiagnose;283
7.7.6;Summary;284
7.8;Integrated Full-Text Search;285
7.8.1;Creating Full-Text Catalogs and Indexes;285
7.8.2;Querying with iFTS;295
7.8.3;Managing Thesaurus Files;300
7.8.4;Using Stoplists;303
7.8.5;Searching Documents;304
7.8.6;Managing iFTS;305
7.8.7;Summary;306
8;Development in SQL Server;307
8.1;New Datatypes in SQL Server 2008;308
8.1.1;Spatial Support in SQL Server 2008;308
8.1.2;How Time Has Changed in SQL Server;314
8.1.3;A New Hierarchical Datatype;320
8.1.4;Filestream Support;325
8.1.5;Summary;335
8.2;T-SQL Enhancements for Developers;336
8.2.1;Notable DML Features;336
8.2.2;General Development;371
8.2.3;Summary;387
8.3;T-SQL Enhancements for DBAs;388
8.3.1;Locking Enhancements;388
8.3.2;Metadata Views;389
8.3.3;Notable SQL Server Performance Monitor Counters;395
8.3.4;DDL Triggers;395
8.3.5;Indexing and Performance Enhancements;399
8.3.6;Snapshots;416
8.3.7;Data-Integrity Enhancements;421
8.3.8;Summary;422
8.4;.NET Integration;423
8.4.1;Introduction to SQL Server .NET Integration;424
8.4.2;SQL Server .NET Programming Model;426
8.4.3;Programming a CLR Stored Procedure;427
8.4.4;Deploying CLR Routines;445
8.4.5;Summary;446
8.5;Programming Assemblies;447
8.5.1;CLR User-Defined Types;448
8.5.2;CLR User-Defined Functions;468
8.5.3;CLR User-Defined Aggregates;477
8.5.4;CLR User-Defined Triggers;486
8.5.5;Managing Assemblies;491
8.5.6;Summary;491
8.6;SQL Server and XML;492
8.6.1;What Is XML?;492
8.6.2;What Are XPath and the XMLDOM?;493
8.6.3;Getting XML into the Database;498
8.6.4;Getting XML Out of the Database;514
8.6.5;Working with XML Data;522
8.6.6;Programming SQLXML from .NET and COM;525
8.6.7;Summary;532
8.7;SQL Server XML and XQuery Support;533
8.7.1;Using the XML Datatype;534
8.7.2;Inserting Data into XML Columns;542
8.7.3;Querying XML Data;545
8.7.4;Modifying XML Data;554
8.7.5;Indexing XML for Performance;555
8.7.6;Full-Text Search and the XML Datatype;558
8.7.7;Catalog Views and XML;559
8.7.8;Applications and XML;559
8.7.9;XML Web Services Support;560
8.7.10;Summary;570
8.8;LINQ to SQL;571
8.8.1;Object/Relational Mapping;571
8.8.2;Entity-Generation Tools;573
8.8.3;Running LINQ Queries;582
8.8.4;The DataContext Class;588
8.8.5;Summary;600
9;Business Intelligence in SQL Server;601
9.1;Reporting Services;602
9.1.1;Reporting Services Components;603
9.1.2;Building a Basic Report;616
9.1.3;Report Design Advanced Features;620
9.1.4;Visual Studio Integration and ReportViewer Controls;631
9.1.5;SharePoint Integration;637
9.1.6;End-User Ad Hoc Query and Reporting;638
9.1.7;Report Rendering;640
9.1.8;Data Regions;642
9.1.9;Summary;657
9.2;Analysis Services;658
9.2.1;New Analysis Services Features in SQL Server 2008;659
9.2.2;Analysis Services Fundamentals;660
9.2.3;OLAP, OLTP, and Data Warehouses;663
9.2.4;Analysis Services Projects;667
9.2.5;Working with Cubes;685
9.2.6;Using Analysis Services Scripting Language;699
9.2.7;Summary;702
9.3;Integration Services;703
9.3.1;An Overview of SSIS Features;703
9.3.2;The SSIS Integrated Development Environment;705
9.3.3;SSIS Fundamentals;707
9.3.4;Control Flow and Data Flow Designer Tasks;726
9.3.5;Change Data Capture;747
9.3.6;Logging;749
9.3.7;Dynamic Package Configuration;753
9.3.8;Variables;756
9.3.9;Precedence Constraints;758
9.3.10;Checkpoints;759
9.3.11;Transactions;759
9.3.12;Debugging;760
9.3.13;SSIS Package Handling;763
9.3.14;Summary;765
10;Index;766