Goals
- Evaluate the existing business environment
- Plan and implement policy-based management
- Describe the needs to consolidate workloads with SQL Server 2014
- Use Microsoft Azure storage with SQL Server 2014
- Plan high-level solutions Availability and Disaster Recovery
- Plan and implement database replication
Program
Business data requirements
Assess existing infrastructure
Practical workshops: Evaluate an existing Enterprise Data infrastructure
Microsoft System Center policy-based management
Practical Workshops: Strategy-Based Planning and Implementation Management
Database Server Consolidation Requirements
Manage Resources in a Consolidated Database Infrastructure
Practical workshops: SQL Server Consolidation
Overview of SQL Server Cloud Computing in a Private Cloud
Practical Workshops: Preparing to Install SQL Server in a Virtual Machine Template
Overview of Microsoft Azure Microsoft Azure
Storage
Duration
5 days
Price
£ 2134
Audience
Database professionals
Prerequisites
Experience required with relational databases
Reference
BAS1123-F
Introduction to Microsoft Azure SQL Databases Microsoft Azure SQL Database
Security
Implement and Manage Databases
Introduction to Microsoft Azure Virtual Machines
Connectivity and Security of Microsoft Azure Virtual Machines
Create Databases in Microsoft Azure Virtual Machines
Practical workshops: Using ShippiPreparing Connecting a SQL Server installation in a Templateng virtual machine
High Availability Concepts and Options in SQL Server 2014
Sending Logs
Practical Workshops: Using Log Shipping
Introduction to Windows Server Failover Clustering
Instances SQL Server AlwaysOn Failover Cluster
Hands-on Workshops: Implementing an AlwaysOn Failover Cluster Instance
Introduction to AlwaysOn Availability Group
Working with AlwaysOn Availability Group
Requirements for using AlwaysOn Availability Group
Practical Workshops: Implementing and Testing an AlwaysOn Availability Group
High Availability and Disaster Recovery with SQL Server 2014
High Availability and Disaster Recovery for Databases in Microsoft Azure
Practical Workshops: Planning for high availability and disaster recovery
SQL Server Replication
Planning for Replication
Practical workshops: Planning and implementation of replication
Sessions
Contact us for more informations about session date