If you are a DBA or a Database architect, our article on SQL Server 2019 Always On Availability Groups should be of interest to you. SQL Server availability groups were first introduced with SQL Server 2012 enterprise edition. From thereon, the features for DR (disaster recovery) and HA (high-availability) have evolved to address various pain points.
While there were steady incremental updates for all the SQL Server versions released after 2012, the most significant feature update, in my opinion, was the introduction of “Basic availability groups.” It enabled customers with SQL Server Standard edition to use availability groups feature with some manageable restrictions. It also introduced the ability to deploy availability groups in a workgroup.
SQL Server 2017 introduced Linux & docker support. This enabled users to enable ‘availability groups’ on Linux based SQL Server deployments. It helps enterprises to diversify their deployment infrastructure investments. So, what’s changed, evolved or new in SQL Server 2019 availability groups? Read to find out more.
All editions of SQL Server have evolved over time and SQL Server 2019 is no exception. The 2019 edition is based on the following high-level features:
As you can see from the above table, SQL Server now supports HDFS, scale-out of data marts and talk to external systems like Teradata through Open database connectivity. This brings in additional complexity from the administrators perspective. However, supporting open frameworks like Hadoop & unstructured data is a necessary step to the future. So, with this in mind, let us look at some of the high-level features of availability groups in SQL Server 2019.
That is all we have for now for the new features of SQL Server 2019 Always On Availability Groups. Do let us know your thoughts and suggestions in the comments section below. Thanks for visiting!
Comments are closed.