Caricamento...
OEC502

Microsoft SQL Server High Availability Solutions

Prezzo

€ 830.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

2 gg
Un classico aspetto del disegno di architetture MS SQL Server è quello dell’alta disponibilità.
Per altro l’edizione SQL Server 2012 ha introdotto una grandissima novità sotto questo profilo: gli Availability Group all’interno della tecnologia AlwaysOn, in sostituzione del Database Mirroring (che resta comunque, al momento, ancora disponibile) .
Durante questo corso vedremo come implementare praticamente ed in maniera efficace le varie soluzioni di alta disponibilità disponibili per la piattaforma SQL Server: Log Shipping, Database Mirroring, Istanze Cluster e AlwaysOn Avalaibility Group.
 

 
 
Professionisti IT esperti in SQL Server


CONTENUTI:
 
Introduction to High Availability
  • Discussion: Why High Availability?
  • What Is High Availability?
  • Factors Affecting Availability
  • Choosing Between High Availability Options 
 
 Implementing Log Shipping
  • What Is Log Shipping?
  • Configuring Log Shipping
  • Switching Server Roles
  • Demo: Configure log shipping to automatically backup and restore transaction logs to another SQL Server
Exercise 1
  • Configure log shipping to automatically backup and restore transaction logs to a different SQL Server 
 
Implementing Database Mirroring
  •   What Is Database Mirroring?
  •   Database Mirroring Server Roles
  •   Options for Database Mirroring Configuration
  •   What Are Database Mirroring Endpoints?
  •   Establishing a Mirror Session
  •   Handling Failover
  •   Transparent Client Redirection
  •   Demo: configure database mirroring to provide high availability and automatic failover using a witness
  Exercise 2
  •   Configure mirroring to provide failover for databases.
 
Implementing Server Clustering
  •   What Is Server Clustering?
  •   Considerations for Server Clustering
  •   Installing SQL Server in a Cluster
  •   Always On SQL Server 2012 Enchancements
  •   Demo: Install a clustered Instance of SQL Server
  •   Exercise: Install a clustered Instance of SQL Server
 
Implementing Always On Availability Groups
  • AlwaysOn Availability Groups
  • Active Secondary Replicas
  • Creating an Availability Group
  • Managing an AlwaysOn Availability Group
  • Creating a Read Only outing
  • Demo: Creating an AlwaysOn Availability Group
Exercise 3
  •  Creating an AlwaysOn Availability Group 
 
 Using Distributed High Availability Solutions
  •   Considerations for Peer-to-Peer Replication
  •   Implementing Distributed Load Balancing
  •   Implementing Distributed High Availability
  •   Considerations for Optimizing Database Availability
 


Sede Data P
Bologna 13/12/2017
Milano 15/01/2018
Bologna 16/04/2018
Roma 18/06/2018
Milano 10/09/2018
Bologna 22/10/2018
Roma 26/11/2018