: Michael Coles, Fabio Claudio Ferracchiati, Robert Walters, Chris Farmer, Jonathan Rae
: Accelerated SQL Server 2008
: Apress
: 9781430206064
: 1
: CHF 42.70
:
: Informatik
: English
: 816
: Wasserzeichen/DRM
: PC/MAC/eReader/Tablet
: PDF

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.
Contents at a Glance5
Contents7
About the Authors20
Acknowledgments22
Introduction23
Who This Book Is For24
Valuable Resources24
How This Book Is Structured25
Errata27
Contacting the Authors27
Overview of SQL Server28
SQL Server 2008 Overview29
The Vision of SQL Server 200829
SQL Server 2008 Editions31
A Word on Server Consolidation32
Summary33
SQL Server Installation and Configuration35
SQL Server Requirements35
Upgrading to SQL Server 200836
Summary49
Enterprise Data Platform50
Policy Management51
Needs Addressed by Policy Management51
Policy Management Components52
Sample Policies62
Policy Management Administration66
Summary69
High Availability70
High Availability Defined71
Database Mirroring72
Database Snapshots and Mirroring94
Windows Clustering in SQL Server99
SQL Server Replication99
Reducing Planned Downtime102
Summary103
Performance104
Managing and Monitoring Resources104
Optimizing Storage117
Improving Query Performance124
Summary131
Security132
Disabled Database Engine Features132
Principals and Securables137
Permissions147
Code Access Security151
Auditing in SQL Server 2008155
Summary163
SQL Server Encryption164
Encryption Keys165
Transparent Data Encryption179
Extensible Key Management182
Encryption Without Keys182
Hashing and Signing Data183
Security Catalog Views184
Query Efficiency185
Summary186
Automation and Monitoring187
SQL Server Agent188
Maintenance Plans206
SQLCMD214
PowerShell for SQL Server217
Database Mail224
SQL Profiler230
Extended Events236
Summary241
Service Broker243
What Is Service Broker?244
Creating Service Broker Applications247
Service Broker Routing and Security258
Message Priorities280
Troubleshooting Service Broker Using SSBDiagnose283
Summary284
Integrated Full-Text Search285
Creating Full-Text Catalogs and Indexes285
Querying with iFTS295
Managing Thesaurus Files300
Using Stoplists303
Searching Documents304
Managing iFTS305
Summary306
Development in SQL Server307
New Datatypes in SQL Server 2008308
Spatial Support in SQL Server 2008308
How Time Has Changed in SQL Server314
A New Hierarchical Datatype320
Filestream Support325
Summary335
T-SQL Enhancements for Developers336
Notable DML Features336
General Development371
Summary387
T-SQL Enhancements for DBAs388
Locking Enhancements388
Metadata Views389
Notable SQL Server Performance Monitor Counters395
DDL Triggers395
Indexing and Performance Enhancements399
<