Designing Solutions for Microsoft SQL Server 2014

Descrizione del corso

The focus of this three-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Programma

1. Designing a Database Server Infrastructure
   • Planning a Database Server Infrastructure
   • Planning Server Hardware
   • Considerations for Database Server Consolidation
   • Managing Server Resources in a Consolidated Database Infrastructure
2. Designing a Logical Database Schema
   • Relational Database Design Techniques
   • Planning Schemas and Tables
3. Designing a Physical Database Implementation
   • Planning Files and Filegroups
   • Planning a Partitioning Data
   • Planning Compression
4. Incorporating Data Files into Databases
   • Considerations for Working with Data Files in SQL Server 2014
   • Implementing FileStream and FileTables
   • Searching Data Files
5. Tuning Database Performance
   • Optimizing Query Performance by Using Indexes
   • Working with Query Plans
   • Performance Monitoring
6. Designing Database Security
   • Introduction to Security Planning
   • Planning Security
   • Contained Databases
   • Protecting Data with Encryption
7. Policy Based Management
   • Introduction to Policy-Based Management
   • Planning and Implementing Policy-Based Management
8. Monitoring Server Health
   • Introduction to Server Health Monitoring
   • SQL Server Utility
9. Designing a Database Backup Solution
   • SQL Server Backup and Restore
   • Planning a Recovery Strategy
10. Automating Multi-Server Maintenance
    • Overview of Maintenance Automation
    • Managing Multiple Servers
11. Managing SQL Server with PowerShell
    • Introduction to Windows PowerShell
    • Scripting with Windows PowerShell
12. Replicating Data
    • SQL Server Replication
    • Planning Replication
13. Planning High availability
    • High-availability in SQL Server 2014
    • AlwaysOn availability Groups