Skip to content

new-updated-linux.md

Latest commit

 

History

History
213 lines (126 loc) · 10.5 KB

new-updated-linux.md

File metadata and controls

213 lines (126 loc) · 10.5 KB
title Updated - SQL Server on Linux docs | Microsoft Docs
description Display snippets of updated content for recently changed in documentation, for Microsoft SQL Server on Linux.
services na
documentationcenter
author MightyPen
manager jhubbard
editor rothja
ms.service na
ms.topic updart-autogen
ms.technology database-engine
ms.custom UpdArt.exe
ms.workload linux-sql
ms.tgt_pltfrm na
ms.devlang na
ms.date 07/17/2017
ms.author genemi

New and Recently Updated: SQL Server on Linux docs

Nearly every day Microsoft updates some of its existing articles on its Docs.Microsoft.com documentation website. This article displays excerpts from recently updated articles. Links to new articles might also be listed.

This article is generated by a program that is rerun periodically. Occasionally an excerpt can appear with imperfect formatting, or as markdown from the source article. Images are never displayed here.

Recent updates are reported for the following date range and subject:

  • Date range of updates:   2017-05-23   -to-   2017-07-17
  • Subject area:   Microsoft SQL Server on Linux.

 

New Articles Created Recently

The following links jump to new articles which have been added recently.

  1. Run the SQL Server 2017 container image with Docker
  2. Install SQL Server and create a database on Red Hat
  3. Install SQL Server and create a database on SUSE Linux Enterprise Server
  4. Install SQL Server and create a database on Ubuntu
  5. Sample: Unattended SQL Server installation script for Red Hat Enterprise Linux
  6. Sample: Unattended SQL Server installation script for SUSE Linux Enterprise Server
  7. Sample: Unattended SQL Server installation script for Ubuntu
  8. Active Directory Authentication with SQL Server on Linux
  9. High availability and data protection for availability group configurations
  10. Configure SQL Server 2017 container images on Docker
  11. Customer Feedback for SQL Server on Linux
  12. Encrypting Connections to SQL Server on Linux
  13. Install SQL Server Integration Services (SSIS) on Linux

 

Compact List of Articles Updated Recently

This compact list provides links to all the updated articles which are listed in the Excerpts section.

 

Updated Articles with Excerpts

This section displays the excerpts of updates gathered from articles which have recently experienced a large update.

The excerpts displayed here appear separated from their proper semantic context. Also, sometimes an excerpt is separated from important markdown syntax that surrounds it in the actual article. Therefore these excerpts are for general guidance only. The excerpts only enable you to know whether your interests warrant taking the time to click and visit the actual article.

For these and other reasons, do not copy code from these excerpts, and do not take as exact truth any text excerpt. Instead, visit the actual article.

 

 

1.   Configure SLES Cluster for SQL Server Availability Group

Updated: 2017-06-22           (Next)

 

Set cluster property start-failure-is-fatal to false

Start-failure-is-fatal indicates whether a failure to start a resource on a node prevents further start attempts on that node. When set to false, the cluster will decide whether to try starting on the same node again based on the resource's current failure count and migration threshold. So, after failover occurs, Pacemaker will retry starting the availability group resource on the former primary once the SQL instance is available. Pacemaker will take care of demoting the replica to secondary and it will automatically rejoin the availability group. Also, if start-failure-is-fatal is set to false, the cluster will fall back to the configured failcount limits configured with migration-threshold so you need to make sure default for migration threshold is updated accordingly.

To update the property value to false run:

sudo crm configure property start-failure-is-fatal=false
sudo crm configure rsc_defaults migration-threshold=5000

If the property has the default value of true, if first attempt to start the resource fails, user intervention is required after an automatic failover to cleanup the resource failure count and reset the configuration using: sudo crm resource cleanup <resourceName> command.

For more details on Pacemaker cluster properties see Configuring Cluster Resources.

Configure fencing (STONITH)

Pacemaker cluster vendors require STONITH to be enabled and a fencing device configured for a supported cluster setup. When the cluster resource manager cannot determine the state of a node or of a resource on a node, fencing is used to bring the cluster to a known state again. Resource level fencing ensures mainly that there is no data corruption in case of an outage by configuring a resource. You can use resource level fencing, for instance, with DRBD (Distributed Replicated Block Device) to mark the disk on a node as outdated when the communication link goes down.

 

 

2.   Release notes for SQL Server 2017 on Linux

Updated: 2017-06-20           (Previous)

 

SQL Server Integration Services (SSIS)

You can run SSIS packages on Linux. For more info, see the blog post announcing SSIS support for Linux. Please note the following known issues with this release.

  • The mssql-server-is package is only supported on Ubuntu at this time.

  • The following features are not supported when running SSIS packages on Linux:

    • SSIS Catalog DB
    • Schedule Packages execution by SQL Agent
    • Windows Authentication
    • Third-party components
    • Third-party ODBC drivers
    • ODBC Connection Manager, Source, and Destination (supported with SSIS on Linux CTP 2.1 Refresh)
    • Change Data Capture (CDC)
    • Scale Out
    • Azure Feature Pack
    • Hadoop and HDFS Support
    • Microsoft Connector for SAP BW

With SSIS on Linux CTP 2.1 Refresh, your SSIS packages can use ODBC connections on Linux. For more info, see the blog post announcing ODBC support on Linux.

 

Similar Articles

This section lists very similar articles for recently updated articles in other subject areas, within the same GitHub.com repository: MicrosoftDocs/sql-docs-pr.

Subject areas which do have new or recently updated articles

Subject areas which have no new or recently updated articles