Mastering SQL server 2008 / Michael Lee, Gentry Bieker.

Format:

Book

Author/Creator:

Lee, Michael, 1966-

Contributor:

Bieker, Gentry.

Series:

Serious skills.

Serious skills

Language:

English

Subjects (All):

Client/server computing.

Relational databases.

SQL server.

Physical Description:

1 online resource (795 p.)

Edition:

1st edition

Other Title:

Mastering Microsoft SQL server 2008

SQL server 2008

Place of Publication:

Indianapolis, Ind. : Wiley, c2009.

Language Note:

English

System Details:

text file

Summary:

As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support-the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

Contents:

MASTERING Microsoft® SQL Server® 2008; Acknowledgments; About the Authors; Contents at a Glance; Contents; Introduction; Who Should Read This Book; The Mastering Series; What Is Covered in This Book; How to Contact the Authors; Chapter 1: Overview of Microsoft SQL Server 2008; SQL Server in the Enterprise World; Installing SQL Server 2008; The SQL Server Tool Set; The Bottom Line; Chapter 2: Understanding SQL Server Architecture; Essential Internals; The SQL Server System Catalog; Datatyping; The Bottom Line; Chapter 3: Databases, Files, and Resource Management; Planning a Database

Creating DatabasesManaging Databases, Files, and Filegroups; The Bottom Line; Chapter 4: Tables and CRUD Operations; Designing Data Storage; Creating and Dropping SQL Server Tables; Selecting Data from a Table; Modifying Data; The Bottom Line; Chapter 5: Procedural Programming; Procedural Structures; Stored Procedures; Views; User-Defined Functions; Using Synonyms; The Bottom Line; Chapter 6: Managing Data Integrity; Understanding Data Integrity Controls; Working with Constraints; Working with DML Triggers; Rule and Default Objects; The Bottom Line; Chapter 7: SQL Server and XML

Returning XML from SQL Server Using FOR XMLThe xml Datatype; Validating XML with Schemas; Implementing XQuery; XML Indexes; The Bottom Line; Chapter 8: Managing User Security; The SQL Server Security Infrastructure; Implementing SQL Server Principals and Authentication; Implementing Permissions in SQL Server; The Bottom Line; Chapter 9: Data Recovery; Transaction Architecture; Backup and Restore Strategies; Performing Backups; Performing Restores; Other Issues; The Bottom Line; Chapter 10: Monitoring SQL Server Activity; Using System Monitor; Using SQL Profiler & Trace; DDL Triggers

Event NotificationsThe Bottom Line; Chapter 11: Using the SQL Server Agent Service; SQL Agent and Automation; Creating Jobs; Creating Alerts; Creating Operators; Scripting the SQL Agent; The Bottom Line; Chapter 12: Data Availability and Distribution; Overview of SQL Server Availability and Distribution Options; Database Log Shipping; Database Mirroring; Replication; The Bottom Line; Chapter 13: SQL Server Data Security; Understanding the SQL Server Key Infrastructure; Using Transparent Data Encryption; Encrypting Data Using SQL Server; Module Signing; The Bottom Line

Chapter 14: Indexing Strategies for Query OptimizationIndex Architecture; Creating and Managing Indexes; Special Index Considerations; The Bottom Line; Chapter 15: Transactions and Locking; The SQL Server Locking Architecture; Transaction Management; Distributed Transactions; Getting Transaction and Locking Information; The Bottom Line; Chapter 16: Using the Resource Governor and Policy-Based Management; The Resource Governor; Understanding Policy-Based Management; The Bottom Line; Chapter 17: SQL Server and the .NET Client; Understanding ADO. NET; Special Operations in ADO.NET

Introducing Language Integrated Query (LINQ)

Notes:

Includes index.

ISBN:

9786612012358

9781282012356

1282012355

9781118257388

1118257383

9780470467398

0470467398

OCLC:

768230333