|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-sql-server-high-availability-disaster-recovery/
课程评论：没有评论
课程名称：高级 SQL Server 高可用性与灾难恢复 课程概述：业务连续性至关重要。高可用性（HA）和灾难恢复（DR）确保您的基础设施始终无故障、平稳运行。熟悉各种 HA 和 DR 技术将帮助您大幅降低应用程序的停机时间。本课程首先介绍 SQL Server 中可用的高可用性和灾难恢复技术，包括复制、AlwaysOn 和日志传送。您将学习这些技术的概念、监控方法以及相关问题的故障排除技巧。同时，您将了解如何使用不同的 HA 和 DR 拓扑结构来创建高度可用的基础设施，包括混合拓扑。除此之外，您还将学习 Always On 的优缺点、先决条件和限制，以及日志传送——这是一种历史悠久的 SQL Server 解决方案，主要用于灾难恢复和 SQL Server 迁移。通过本课程，您将探索高可用性和灾难恢复技术的具体实现，能够在创建高度可用的基础设施时加以应用，包括混合拓扑。完成课程后，您将充满信心，期待用强大且高性能的基础设施改变游戏规则。 作者介绍：Ahmad Osama 是 Pitney Bowes Pvt Ltd 的数据库工程师，拥有微软数据平台 MVP 称号。他日常工作中致力于开发和维护高性能的本地和云端 SQL Server OLTP 环境，构建数据库的 CI/CD 环境及自动化。此外，Ahmad 还在 dataplatformlabs 上撰写博客，撰写超过 100 篇关于 SQL Server 管理/开发、Azure SQL 数据库和 Azure Data Factory 的文章，并定期在数据平台实验室社区的用户组活动和网络研讨会上发言。Gethyn Ellis 在 SQL Server 领域拥有超过 18 年的经验，最近 10 年专注于 Azure。他是一名微软认证培训师，还为 SQL Server 提供培训和咨询服务。此前，他曾在 Packt 出版社工作，并撰写有关《入门 SQL Server 2014 管理》、《Microsoft Azure IaaS 基础知识》和《专业 Azure SQL 数据库管理》的书籍。
Business continuity is of utmost importance. High availability (HA) and disaster recovery (DR) ensure that your infrastructure experiences no downtime and smoothly functions at all times. Sound knowledge of various HA and DR techniques help you to drastically reduce the downtime of your applications.This course begins by explaining the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You'll learn what they are, how to monitor them, and how to troubleshoot any related problems. You'll learn how to use different HA and DR topologies to create a highly available infrastructure that also includes hybrid topologies. You'll learn what is Always On, it's pros and cons, prerequisites, and restrictions. You'll also learn about log shipping, one of the oldest SQL Server solutions, which is mostly used for DR and SQL Server migration. Through this course, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies.By the end of the course, you'll feel confident and look forward to changing the game with robust and high performing infrastructure.About the AuthorAhmad Osama works for Pitney Bowes Pvt Ltd as a database engineer and is a Microsoft Data Platform MVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premises and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation. Other than his day to day work, Ahmad blogs at dataplatformlabs and has written over 100 blogs, including SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He regularly speaks at user group events and webinars conducted by the Dataplatformlabs community.Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" , "Microsoft Azure laaS Essentials", and Professional Azure SQL Database Administration.
