SQL Server v.Next CTP 1.3 now available with improvements to High Availability and Disaster Recovery

Reading time icon 2 min. read

Readers help support MSPoweruser. When you make a purchase using links on our site, we may earn an affiliate commission. Tooltip Icon

Read the affiliate disclosure page to find out how can you help MSPoweruser effortlessly and without spending any money. Read more

Microsoft today announced the release of SQL Server v.Next Community Technology Preview 1.3 for both Windows and Linux. This update includes improvements to HADR, including the ability to run Always On Availability Groups on Linux.

On Linux, SQL Server v.Next now allows you to create Always On Availability Groups, which integrate with Linux-based cluster resource managers to enable automatic monitoring, failure detection and automatic failover during unplanned outages. Also, Availability Groups can now work across Windows and Linux as part of the same Distributed Availability Group.

Other features included in this release,

  • Full text search is now available for all supported Linux distributions.
  • Resumable online index rebuilds enables users to recover more easily from interruption of index builds, or split an index build across maintenance windows.
  • Temporal Tables Retention Policy support enables customers to more easily manage the amount of historical data retained by temporal tables.
  • Indirect checkpoint performance improvements. Indirect checkpoint is the recommended configuration for large databases and for SQL Server 2016, and now it will be even more performant in SQL Server v.Next.
  • Minimum Replica Commit Availability Groups setting enables users to set the minimum number of replicas that are required to commit a transaction before committing on the primary.
  • For SQL Server v.Next technical preview running on Windows Server, encoding hints in SQL Server Analysis Services is an advanced feature to help optimize refresh times with no impact on query performance.

For more details on CTP 1.3, visit What’s New in SQL Server v.Next.

More about the topics: CTP, CTP 1.2, download, linux, microsoft, SQL Server Linux, SQL Server v.Next, windows