Mastering SQL server 2008
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...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley
c2009.
|
| Edición: | 1st edition |
| Colección: | Serious skills.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627331006719 |
Tabla de Contenidos:
- 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)
