The real MCTS SQL server 2008 exam 70-432 prep kit database implementation and maintenance
SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005, and is schedule to be released to manufacturing in September 2008. SQL Server 2008 is a much more significant update than SQL Server 2005, because it brings...
| Otros Autores: | , , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Burlington, Mass. :
Syngress Pub
c2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627539006719 |
Tabla de Contenidos:
- Front Cover; The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance; Copyright Page; Technical Editor; Lead Authors; Contributing Authors; Contents; Chapter 1: MCTS SQL Server 2008 Exam 432 New Features in SQL Server 2008; Introduction; A Word About the Test; New Feature Overview; Installation; Compressed Backups; Enhanced Configuration and Management of Audits; New Table Value Parameter; FileStream Data Types; Sparse Column Support; Encryption Enhancements; Key Management and Encryption; High Availability; Performance; Performance Data Management
- Resource Governor (similar to Query Governor)Freeze Plan; SQL Server 2008 Declarative Management Framework; Development Improvements; LINQ Support; MERGE Statement; Spatial Data Type; Analysis Services Improvements; ETL/SSIS Enhancements; Reporting Services; No Longer Requires IIS; Better Graphing; Export to Word Support; Deprecated Features; Discontinued Features; Summary of Exam Objectives; Exam Objectives Fast Track; Exam Objectives Frequently Asked Questions; Self Test; Self Test Quick Answer Key; Chapter 2: MCTS SQL Server 2008 Exam 432 Installing SQL Server 2008; Introduction
- SQL Versions, Requirements, Features, and DifferencesPlanning Your Installation; Upgrade Tools; Hardware Requirements: CPU, Memory, and Disk; Operating System Requirements; Software Requirements; Establishing Service Accounts; Upgrading vs. Side-by-Side Installation; Clustered Installation Considerations; Unattended Installations; Post-Upgrade Activity; Database Instances, Files, Locations, Filegroups, and Performance; Binary File Locations; Filegroups; Disk Planning Best Practices; Summary of Exam Objectives; Exam Objectives Fast Track; Exam Objectives Frequently Asked Questions; Self Test
- Self Test Quick Answer KeyChapter 3: MCTS SQL Server 2008 Exam 432 Configuring SQL Server 2008; Introduction; Instances vs. Default Instance; Instance Limitations; Performance Considerations; SQL Server Configuration Manager; Managing Services; Enabling FileStream; Managing Connections and Protocols; Shared Memory; Named Pipes; VIA; TCP/IP; Changing the TCP Port; Aliases; sp_configure and SQL Server Management Studio; Advanced Options; AWE; Setting the Maximum and Minimum Memory for SQL Server; Max Server Memory (MB); Min Server Memory (MB); Maximum Degree of Parallelism
- Security CertificationsC2 Auditing; Common Criteria Compliance; New Features; Backup Compression Default; FileStream Access Level; Database Mail; Configuring Database Mail; Full-Text Indexing; Configuring Full-Text Indexing; Managing Full-Text Indexes; Summary of Exam Objectives; Exam Objectives Fast Track; Exam Objectives Frequently Asked Questions; Self Test; Self Test Quick Answer Key; Chapter 4: MCTS SQL Server 2008 Exam 432 Managing Security; Introduction; Principals; Roles; The "Principle of Least Privilege"; Users; Schemas; Users versus Logins; Authentication Mode; Permissions
- Cross-Database Ownership Chaining
