High Availability with Microsoft SQL Server 2012/2014SQHAFLFast LaneFL-SQHA1.0<p>Vor der Teilnahme an diesem Kurs ist es empfehlenswert, dass Teilnehmer folgende Fähigkeiten besitzen:
</p>
<ul>
<li>1 Jahr SQL Server-Erfahrung (nicht unbedingt SQL Server 2012)</li><li>1 Jahr Windows Server 2008 (oder höher) Erfahrung</li><li>1 Jahr Hyper-V-Erfahrung</li><li>1 Jahr Windows Failover Clustering Erfahrung</li></ul><p>Dieser Kurs richtet sich an diejenigen,die für Gestaltung und Umsetzung von Hochverfügbarkeitslösungen für SQL Server 2012 verantwortlich sind.</p><h5>High Availability Overview </h5><ul>
<li>Defining High Availability</li><li>Achieveing High Availiability</li></ul><h5>Overview of Windows Server Failover Clustering </h5><ul>
<li>Failover Clustering Concepts</li><li>Cluster Resources</li><li>Setting up a Windows Failover Cluster</li><li>MSDTC Clustering.</li></ul><h5>SQL Server 2012 High Availability Overview</h5><ul>
<li>SQL Server 2012 High Availability (HA) Technologies</li><li>High-level Considerations on Technology Choices</li><li>Common Combinations</li></ul><h5>AlwaysOn Failover Clustering</h5><ul>
<li>SQL Server Failover Clustering - Definitions and History</li><li>SQL Server 2012 Failover Clustering Instance (FCI)Maintaining a SQL Server 2012 FCI</li><li>Multi-Site Failover Clustering</li></ul><h5>AlwaysOn Availability Groups</h5><ul>
<li>Availability Group Concepts</li><li>Partners and Secondary Servers</li></ul><h5>Legacy Database Mirroring</h5><ul>
<li>Database Mirroring Overview</li><li>Database Mirroring Architecture</li><li>Enabling Database Mirroring</li><li>Database Mirroring Operations</li></ul><h5>Legacy Log Shipping</h5><ul>
<li>Log Shipping Overview</li><li>Log Shipping Architecture</li><li>Configuring Log Shipping</li><li>Log Shipping Internals</li><li>Administering Log Shipping</li></ul><h5>Using Replication for High Availability</h5><ul>
<li>Replication Overview</li><li>Replication Types</li><li>Replication Architecture</li><li>Configuring Replication</li><li>Replication Monitoring</li></ul><h5>High Availability Solutions Interoperability</h5><ul>
<li>AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups</li><li>AlwaysOn Failover Cluster Instances with Legacy Database Mirroring</li><li>AlwaysOn Availability Groups with Replication</li></ul><h5>High Availability with Virtualization</h5><ul>
<li>Hyper-V in Windows Server 2008 R2</li><li>Improvements in Windows Server 2012</li><li>SQL Server Hyper-V Support</li><li>Hyper-V HA Considerations (Using Cluster Shared Volumes for High Availability, Live Migration, Using Guest Clustering)</li></ul><h5>Meeting Your Availability Goals</h5><ul>
<li>Technology Choices</li><li>Servicing for Availability</li><li>Ongoing Maintenance (Indexing, Partitioning)</li><li>Processes and Procedures for Availability (Rule n.1, Understanding the Technologies Used, Understanding the Procedures and Escalation Paths, Planned Downtime)</li></ul>Vor der Teilnahme an diesem Kurs ist es empfehlenswert, dass Teilnehmer folgende Fähigkeiten besitzen:
- 1 Jahr SQL Server-Erfahrung (nicht unbedingt SQL Server 2012)
- 1 Jahr Windows Server 2008 (oder höher) Erfahrung
- 1 Jahr Hyper-V-Erfahrung
- 1 Jahr Windows Failover Clustering ErfahrungDieser Kurs richtet sich an diejenigen,die für Gestaltung und Umsetzung von Hochverfügbarkeitslösungen für SQL Server 2012 verantwortlich sind.High Availability Overview
- Defining High Availability
- Achieveing High Availiability
Overview of Windows Server Failover Clustering
- Failover Clustering Concepts
- Cluster Resources
- Setting up a Windows Failover Cluster
- MSDTC Clustering.
SQL Server 2012 High Availability Overview
- SQL Server 2012 High Availability (HA) Technologies
- High-level Considerations on Technology Choices
- Common Combinations
AlwaysOn Failover Clustering
- SQL Server Failover Clustering - Definitions and History
- SQL Server 2012 Failover Clustering Instance (FCI)Maintaining a SQL Server 2012 FCI
- Multi-Site Failover Clustering
AlwaysOn Availability Groups
- Availability Group Concepts
- Partners and Secondary Servers
Legacy Database Mirroring
- Database Mirroring Overview
- Database Mirroring Architecture
- Enabling Database Mirroring
- Database Mirroring Operations
Legacy Log Shipping
- Log Shipping Overview
- Log Shipping Architecture
- Configuring Log Shipping
- Log Shipping Internals
- Administering Log Shipping
Using Replication for High Availability
- Replication Overview
- Replication Types
- Replication Architecture
- Configuring Replication
- Replication Monitoring
High Availability Solutions Interoperability
- AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups
- AlwaysOn Failover Cluster Instances with Legacy Database Mirroring
- AlwaysOn Availability Groups with Replication
High Availability with Virtualization
- Hyper-V in Windows Server 2008 R2
- Improvements in Windows Server 2012
- SQL Server Hyper-V Support
- Hyper-V HA Considerations (Using Cluster Shared Volumes for High Availability, Live Migration, Using Guest Clustering)
Meeting Your Availability Goals
- Technology Choices
- Servicing for Availability
- Ongoing Maintenance (Indexing, Partitioning)
- Processes and Procedures for Availability (Rule n.1, Understanding the Technologies Used, Understanding the Procedures and Escalation Paths, Planned Downtime)3 Tage1552.00