{"id":14405,"date":"2022-12-29T08:21:28","date_gmt":"2022-12-29T07:21:28","guid":{"rendered":"https:\/\/www.itta.net\/formations\/sql-2016-alwayson-high-availability\/"},"modified":"2024-06-25T11:31:35","modified_gmt":"2024-06-25T09:31:35","slug":"sql-2016-alwayson-high-availability","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/","title":{"rendered":"SQL 2016 AlwaysOn High Availability (55246)"},"content":{"rendered":"<p><strong>Optimize Your SQL Server Infrastructure with Our Advanced AlwaysOn and High Availability Training<\/strong><\/p>\n<p>This <strong>SQL 2016<\/strong> AlwaysOn High Availability training is designed for database administrators and Windows engineers, immersing you in the advanced concepts of SQL AlwaysOn and High Availability.<\/p>\n<p>Using SQL 2016, you will learn to deploy failover clusters, configure availability groups, and perform proactive maintenance. Join us to master best practices for monitoring and troubleshooting availability groups while integrating key differences between SQL 2012, SQL 2014, and SQL 2016. Elevate your skills and ensure maximum availability of your SQL systems.<\/p>\n","protected":false},"featured_media":49047,"parent":0,"menu_order":0,"template":"","editeurs":[1488,1496],"domaine":[1254,1253],"class_list":["post-14405","formations","type-formations","status-publish","has-post-thumbnail","hentry","editeurs-microsoft","editeurs-sql-server-microsoft","domaine-analytics-data-management","domaine-it-pro"],"acf":{"reference":"55246AC","duree_nombre":3,"duree_unite":"jour","prix_virtuel":2350,"prix_presentiel":2500,"prix_blended":"","prix_elearning":"","views":2164,"niveau":["Interm\u00e9diaire"],"role":"","certifiant":"","pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Non certifiant","garanti":[""],"financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"SQL 2016 AlwaysOn High Availability Training","objectifs":"<ul>\r\n \t<li>Understand AlwaysOn High Availability<\/li>\r\n \t<li>Employ Server 2016 Failover Clustering<\/li>\r\n \t<li>Deploy SQL Failover Clusters<\/li>\r\n \t<li>Work with Availability Groups<\/li>\r\n \t<li>Perform maintenance<\/li>\r\n \t<li>Monitor and Troubleshoot Availability Groups<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>Experience as SQL DBA<\/li>\r\n \t<li>Experience as Windows IT PRO<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n \t<li>Experienced DBAs<\/li>\r\n \t<li>Windows Server Pros<\/li>\r\n \t<li>Team leaders<\/li>\r\n<\/ul>","examen":"","documentation":"<ul>\r\n \t<li>Digital courseware included<\/li>\r\n<\/ul>","lab__exercices":"<ul>\r\n \t<li>Online Labs<\/li>\r\n<\/ul>","contenu_cours":"<strong>Module 01: Introduction<\/strong>\r\n<ul>\r\n \t<li>Course introduction<\/li>\r\n<\/ul>\r\n<strong>Module 02: Alwayson and high availability concepts and terminology<\/strong>\r\n<ul>\r\n \t<li>Concepts and Terminology<\/li>\r\n \t<li>Table of Availability<\/li>\r\n \t<li>High Availability<\/li>\r\n \t<li>Causes of Downtime<\/li>\r\n \t<li>Planned downtime<\/li>\r\n \t<li>Unplanned downtime<\/li>\r\n \t<li>Disaster Recovery<\/li>\r\n \t<li>Recovery Time Objective (RTO)<\/li>\r\n \t<li>Recovery Point Objective (RPO)<\/li>\r\n \t<li>Recovery Level Objective (RLO)<\/li>\r\n \t<li>Storage Area Networks (SAN)<\/li>\r\n \t<li>Edition Changes from SQL 2012<\/li>\r\n \t<li>SQL Server 2014 Changes<\/li>\r\n \t<li>SQL Server 2016 Changes<\/li>\r\n \t<li>Legacy Solutions prior to Always On<\/li>\r\n \t<li>Failover Cluster Instances<\/li>\r\n \t<li>Log Shipping<\/li>\r\n \t<li>A Typical Log Shipping Configuration<\/li>\r\n \t<li>Monitor Server<\/li>\r\n \t<li>Replication<\/li>\r\n \t<li>Database Mirroring<\/li>\r\n \t<li>Database Mirroring Terminology<\/li>\r\n \t<li>Principle<\/li>\r\n \t<li>Mirror<\/li>\r\n \t<li>Witness (red box in image above)<\/li>\r\n \t<li>Database Snapshots<\/li>\r\n \t<li>Limitations of legacy solutions:<\/li>\r\n \t<li>What do we mean by Always On?<\/li>\r\n \t<li>Table of Always On Comparison<\/li>\r\n<\/ul>\r\n<strong>Module 03: Windows server 2016 failover clustering<\/strong>\r\n<ul>\r\n \t<li>Understanding Failover Clustering in Server 2016<\/li>\r\n \t<li>Statefull High Availability Solution<\/li>\r\n \t<li>Supported in both Standard and Datacenter<\/li>\r\n \t<li>Servers should run similar hardware<\/li>\r\n \t<li>Should run same edition<\/li>\r\n \t<li>Hyper-V best with datacenter<\/li>\r\n \t<li>Certified for Windows server logo<\/li>\r\n \t<li>Shared Storage<\/li>\r\n \t<li>Quorums<\/li>\r\n \t<li>Node Majority<\/li>\r\n \t<li>Node and Disk Majority configuration:<\/li>\r\n \t<li>Node and File Share Majority<\/li>\r\n \t<li>No Majority<\/li>\r\n \t<li>Configuration<\/li>\r\n \t<li>Cluster Networks Best Practices<\/li>\r\n \t<li>Connection to nodes to shared storage<\/li>\r\n \t<li>Private network for internal cluster<\/li>\r\n \t<li>Public network for client connections<\/li>\r\n \t<li>Cluster Aware Updating<\/li>\r\n \t<li>Virtual Machine Failover Clustering<\/li>\r\n \t<li>Preferred Owners<\/li>\r\n \t<li>Failover Failback<\/li>\r\n \t<li>Resources<\/li>\r\n \t<li>Dependences<\/li>\r\n \t<li>Heartbeat<\/li>\r\n<\/ul>\r\n<strong>Module 04: SQL 2016 failover cluster instances<\/strong>\r\n<ul>\r\n \t<li>Failover Cluster Instance<\/li>\r\n \t<li>As A FCI Appears To A Client<\/li>\r\n<\/ul>\r\n<strong>Module 05: SQL 2016 alwayson availability groups<\/strong>\r\n<ul>\r\n \t<li>Availability Groups and Replicas<\/li>\r\n \t<li>Primary Replica<\/li>\r\n \t<li>Secondary Replicas<\/li>\r\n \t<li>Availability Group Listener<\/li>\r\n \t<li>Availability Mode<\/li>\r\n \t<li>Synchronous Commit Mode<\/li>\r\n \t<li>Asynchronous Commit Mode<\/li>\r\n \t<li>Failover Modes<\/li>\r\n \t<li>Automatic Failover Without Data Loss<\/li>\r\n \t<li>Automatic Failover Requirements:<\/li>\r\n \t<li>Manual<\/li>\r\n \t<li>Manual Failover Requirements<\/li>\r\n \t<li>Common Topologies<\/li>\r\n<\/ul>\r\n<strong>Module 06: The Dasboard<\/strong>\r\n<ul>\r\n \t<li>The Dashboard<\/li>\r\n \t<li>How to view logs<\/li>\r\n \t<li>Using replication with Logins<\/li>\r\n \t<li>Using partially contained databases<\/li>\r\n<\/ul>\r\n<strong>Module 07: Active Secondary Availability Group Actions<\/strong>\r\n<ul>\r\n \t<li>Reporting with Secondary Replicas<\/li>\r\n \t<li>Configuring a Readable secondary<\/li>\r\n \t<li>Read-Only Routing<\/li>\r\n \t<li>Load Balancing<\/li>\r\n \t<li>Lab : Configure a Read-Only Secondary<\/li>\r\n \t<li>Database Backups with Secondary<\/li>\r\n \t<li>Steps of Backup Using secondary<\/li>\r\n \t<li>Backup Preference Options<\/li>\r\n<\/ul>\r\n<strong>Module 08: Maintenance<\/strong>\r\n<ul>\r\n \t<li>DBCC Checks<\/li>\r\n \t<li>Database Adding and Removing<\/li>\r\n<\/ul>\r\n<strong>Module 09: Monitoring and troubleshooting availibility groups<\/strong>\r\n<ul>\r\n \t<li>The Dashboard in Depth<\/li>\r\n \t<li>Events<\/li>\r\n \t<li>Policy Based Managemnt for Availability Groups<\/li>\r\n<\/ul>","cours_recommandes":[14825,14826],"infos_additionnelles":"<h2>SQL 2016 AlwaysOn High Availability Training (55246)<\/h2>\r\nOur training \"SQL Server 2016: High Availability and AlwaysOn\" provides you with an in-depth understanding of <strong>high availability concepts<\/strong> and <strong>AlwaysOn technologies<\/strong> for <strong>SQL Server<\/strong>. Discover the essential <strong>terminologies<\/strong>, <strong>availability tables<\/strong>, and the various causes of <strong>downtime<\/strong>, including planned and unplanned interruptions.\r\n\r\nEffective high availability management involves a thorough knowledge of <strong>disaster recovery<\/strong>. We will cover crucial concepts such as the <strong>Recovery Time Objective (RTO)<\/strong>, the <strong>Recovery Point Objective (RPO)<\/strong>, and the <strong>Recovery Level Objective (RLO)<\/strong>. You will also understand the importance of <strong>Storage Area Networks (SAN)<\/strong> and the edition changes in SQL Server since 2012, with a focus on the 2014 and 2016 versions.\r\n<h3>Windows Server 2016 Failover Clustering<\/h3>\r\nIn this section, delve into <strong>failover clustering<\/strong> in Windows Server 2016, a robust high availability solution for <strong>SQL Server<\/strong>. Learn to configure failover clusters on similar hardware and the same server edition, optimized for <strong>Hyper-V<\/strong> with Datacenter.\r\n\r\nExplore best practices for cluster networks, including connecting nodes to shared storage, private networks for internal clustering, and public networks for client connections. You will also learn to configure <strong>quorums<\/strong>, node and disk majority configurations, and implement cluster-aware updates.\r\n<h3>SQL 2016 Failover Cluster Instances<\/h3>\r\nDiscover <strong>Failover Cluster Instances (FCI)<\/strong> in SQL Server 2016. Learn how an FCI instance appears to a client and how these instances can ensure high availability for your critical databases.\r\n<h3>SQL 2016 AlwaysOn Availability Groups<\/h3>\r\n<strong>AlwaysOn Availability Groups<\/strong> are an advanced feature of SQL Server 2016 for ensuring high availability. Discover how to configure primary and secondary replicas, use availability group listeners, and the different availability modes, including synchronous and asynchronous commit modes.\r\n\r\nWe will also cover failover modes, the requirements for automatic failover without data loss, and common topologies for implementing availability groups. Ensure your SQL Server infrastructure is always ready to meet your business needs.\r\n<h3>The Dashboard<\/h3>\r\nThe SQL Server <strong>dashboard<\/strong> is an essential tool for monitoring and managing your SQL Server environments. Learn to view logs, use replication with connections, and manage partially contained databases. Maximize the efficiency and performance of your SQL Server with a well-configured dashboard.\r\n<h3>Active Secondary Availability Group Actions<\/h3>\r\nExplore the possible actions with active secondary replicas in SQL Server. Discover how to configure a readable secondary replica for reporting, read-only routing, and load balancing. Learn also to perform database backups using secondary replicas, with backup preference options.\r\n<h3>Maintenance<\/h3>\r\nRegular maintenance is crucial for the health of your SQL Server databases. Learn to perform DBCC checks and safely add or remove databases. Keep your SQL Server in perfect working condition with optimized maintenance practices.\r\n<h3>Monitoring and Troubleshooting Availability Groups<\/h3>\r\nFinally, the training focuses on monitoring and troubleshooting availability groups in SQL Server. Delve deeply into the dashboard, relevant events, and policy-based management to ensure high availability for your databases. Keep your SQL Server performing at its best by mastering monitoring and troubleshooting techniques.","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>180 days of access to Microsoft labs<\/li>\r\n \t<li>Documentation in digital format<\/li>\r\n \t<li>Achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by a certified trainer<\/li>\r\n \t<li>180 days of access to Microsoft labs<\/li>\r\n \t<li>Documentation in digital format<\/li>\r\n \t<li>Achievement badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>**SQL 2016 AlwaysOn High Availability Training** - ITTA<\/title>\n<meta name=\"description\" content=\"**Master SQL AlwaysOn and High Availability: Advanced SQL Server Training for SQL Administrators and Windows Engineers**\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/\",\"name\":\"**SQL 2016 AlwaysOn High Availability Training** - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/SQL-2016-AlwaysOn-High-Availability.png\",\"datePublished\":\"2022-12-29T07:21:28+00:00\",\"dateModified\":\"2024-06-25T09:31:35+00:00\",\"description\":\"**Master SQL AlwaysOn and High Availability: Advanced SQL Server Training for SQL Administrators and Windows Engineers**\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/SQL-2016-AlwaysOn-High-Availability.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/SQL-2016-AlwaysOn-High-Availability.png\",\"width\":1344,\"height\":896,\"caption\":\"Sql 2016 Alwayson High Availability\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/sql-2016-alwayson-high-availability\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IT Pro\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Analytics and Data Management\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/it-pro\\\/analytics-data-management\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"SQL 2016 AlwaysOn High Availability (55246)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"**SQL 2016 AlwaysOn High Availability Training** - ITTA","description":"**Master SQL AlwaysOn and High Availability: Advanced SQL Server Training for SQL Administrators and Windows Engineers**","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/","url":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/","name":"**SQL 2016 AlwaysOn High Availability Training** - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/#primaryimage"},"image":{"@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2022\/12\/SQL-2016-AlwaysOn-High-Availability.png","datePublished":"2022-12-29T07:21:28+00:00","dateModified":"2024-06-25T09:31:35+00:00","description":"**Master SQL AlwaysOn and High Availability: Advanced SQL Server Training for SQL Administrators and Windows Engineers**","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/#primaryimage","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2022\/12\/SQL-2016-AlwaysOn-High-Availability.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2022\/12\/SQL-2016-AlwaysOn-High-Availability.png","width":1344,"height":896,"caption":"Sql 2016 Alwayson High Availability"},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/sql-2016-alwayson-high-availability\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"IT Pro","item":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/"},{"@type":"ListItem","position":3,"name":"Analytics and Data Management","item":"https:\/\/www.itta.net\/en\/trainings\/it-pro\/analytics-data-management\/"},{"@type":"ListItem","position":4,"name":"SQL 2016 AlwaysOn High Availability (55246)"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14826"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14825"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media\/49047"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=14405"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14405"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}