Close
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Microsoft Adds Always On Availability Groups to SQL Server vNext

    Written by

    Pedro Hernandez
    Published February 21, 2017
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      Microsoft has released Community Technology Preview (CTP) 1.3 of the next version of SQL Server for both Windows and Linux, codenamed SQL Server vNext.

      The newest preview release follows last month’s CTP 1.2, which included SUSE Linux support. This time around, the software giant added the Always On Availability Groups feature to the Linux edition, enabling customers to test the database software’s hardiness while running critical workloads.

      “Always On Availability Groups is SQL Server’s flagship solution for HADR [high availability and disaster recovery],” explained Mihaela Blendea, senior program manager of SQL Server at Microsoft, in a blog post. First appearing in SQL Server 2012, the feature “provides High Availability for groups of databases on top of direct attached storage, supporting multiple active secondary replicas for integrated HA/DR, automatic failure detection, fast transparent failover, and read load balancing. This broad set of capabilities is enabling customers to meet the strictest availability SLA [service-level agreement] requirements for their mission-critical workloads,” she added.

      Always On Availability Groups works on all supported Linux distributions, namely Red Hat Enterprise Linux, Ubuntu and the aforementioned SUSE Linux Enterprise Server. It enables multi-database failover, fast failure detection and failover and database-level health monitoring and failover triggering, among other capabilities designed to help keep critical applications up and running in the event of an outage or other mishap that strikes a customer’s data center.

      An overview of the feature and its use cases is available in Blendea’s blog post.

      Also new in SQL Server vNext CTP 1.3 is full text search in all supported Linux distributions, resumable online index rebuilds and support for Temporal Tables Retention Policies that eases the management of historical data stored in temporal tables. Indirect Checkpoint, a recommended configuration used in large databases, performs faster courtesy of new tweaks.

      Another performance-enhancing feature is Encoding Hints. In a separate post, Christian Wade, senior program manager of Analysis Services at Microsoft, explained that the feature can be “used to optimize processing (data refresh) of large in-memory tabular models.”

      Typically, when running Analysis Services on SQL Server, the feature takes sample values from a numerical column to choose between a data encoding method (value encoding or the space-saving hash encoding method). After partially processing a column and gathering enough information about how data is distributed therein, Analysis Services can switch gears, requiring a time-consuming restart of the encoding process, said Wade.

      Encoding Hints may help speed things up by allowing “the modeler to specify a preference for the encoding method given prior knowledge from data profiling and/or in response to re-encoding trace events,” added Wade. “Since aggregation over hash-encoded columns is slower than over value-encoded columns, value encoding may be specified as a hint for such columns.”

      Encoding Hints is not a setting, he cautioned, since there are no guarantees the software will apply the “hints.” A complete list of new functionality in CTP 1.3 is available in this online support document.

      Pedro Hernandez
      Pedro Hernandez
      Pedro Hernandez is a writer for eWEEK and the IT Business Edge Network, the network for technology professionals. Previously, he served as a managing editor for the Internet.com network of IT-related websites and as the Green IT curator for GigaOM Pro.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2024 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×