Module 3: Designing a Physical Database Implementation
- Files and Filegroups
- Partitioning Data
- Compressing Data
Module 4: Designing a Database Solution for BLOB Data
- Considerations for BLOB Data
- Working with FileStream
- Using Full-text Search
Module 5: Tuning Database Performance
- Optimizing Query Performance with Indexes
- Managing Query Plans
- Performance Monitoring and Tuning
Module 6: Designing Database Security
- Designing Server-Level Security
- Designing Database-Level Security
- Transparent Database Encryption
- Auditing Database Activity
Module 7: Using Policy-Based Management
- Introduction to Policy-Based Management
- Implementing Policy-Based Management
- Planning For Policy-Based Management
Module 8: Monitoring Server Health
- Introduction to Health Monitoring
- Options for Monitoring Health
- Using the SQL Server Utility
Module 9: Designing a Database Backup Solution
- SQL Server Backup and Restore
- Planning a Recovery Strategy
Module 10: Automating Multi-Server Maintenance
- Overview of Maintenance Automation
- Managing Multiple Servers
Module 11: Managing SQL Server with PowerShell
- Introduction to PowerShell
Module 12: Replicating Data
- SQL Server Replication
- Planning Replication
Module 13: Designing for High Availability
- High Availability in SQL Server 2012
- AlwaysOn Availability Groups
Durata: 5gg. Ore 9:00 - 17:00
Costo: € 1.190 +IVA. Compreso Materiale didattico Ufficiale MOC (Microsoft Official Courseware) ed Attestato Ufficiale MOC (Microsoft Official Curriculum); 2 coffee break al giorno.
