| SQL Server 2008 New Features |
ID: SQNFEAT | Longueur du cours:2 | Nom de Compagnie:Choquette Technology Associates Inc.
|
|
Module 0: Database Engine Improvements |
- Backup Compression
- Extensible Key Mangement
- Transparent Data Encryption
- Declarative Policy Management
- Spatial Data Storage, Methods and Indexing
- Configuration Servers
- Change Tracking
- Filestream Storage
- Hot Add Cpu
- Plan Guide Enhancements
- Query Processing On Partitioned Objects
- Partition Switching On Partitioned Tables and Indexes
- Resource Governor
|
|
Module 1: SQL Server Management Studio Enhancements |
- Tsql Query Editor Intellisense
- Tsql Error List Window
- Multi Server Query Targeting
- Improved Personalization Support
|
|
Module 2: Tsql Enhancements |
- Added Lock Escalation Option
- Multi Value Inserts
- Improved Query Hints
- New Hierarchical Data Type
- Added Merge Statement
- Table Valued Parameters
- User Defined Table Type
- Setting the Compatibility Level with Alter Database
- Using Grouping Sets
- Forceseek Option
|
|
Module 3: Other Enhancements |
- Data Collector
- Database Mirroring
- Automatic Recovery for Corrupted Pages
- Improved Reporting
- Extended Events
- Change Data Capture
- Bitmap Filtering
- Dynamic Management Views
- Expanded Ddl Triggers and Event Notifications
|
|
Module 4: New Service Features |
- What’s New in Analysis Services
- What’s New in Reporting Services
- What’s New in Service Broker
- What’s New in Notification Services
- What’s New in Ssis
|