Merge pull request #28654 from MicrosoftDocs/main

v-alje · web-flow · commit 15234920616a · 2023-10-04T10:31:25.000-07:00
10/04 AM Publishing
diff --git a/azure-sql/database/automated-backups-overview.md b/azure-sql/database/automated-backups-overview.md
@@ -161,7 +161,10 @@ Hyperscale databases use a different backup scheduling mechanism. For more infor
 
 Backups that are no longer needed to provide PITR functionality are automatically deleted. Because differential backups and log backups require an earlier full backup to be restorable, all three backup types are purged together in weekly sets.
 
-For all databases, including [TDE-encrypted](transparent-data-encryption-tde-overview.md) databases, backups are compressed to reduce backup storage consumption and costs. Average backup compression ratio is 3 to 4 times. However, it can be significantly lower or higher depending on the nature of the data and whether data compression is used in the database.
+For all databases, including [TDE-encrypted](../database/transparent-data-encryption-tde-overview.md) databases, all full and differential backups are compressed, to reduce backup storage compression and costs. Average backup compression ratio is 3 to 4 times. However, it can be significantly lower or higher depending on the nature of the data and whether data compression is used in the database.
+
+> [!IMPORTANT]
+> For TDE-encrypted databases, log backups files are not compressed for performance reasons. Log backups for non-TDE-encrypted databases are compressed.
 
 Azure SQL Database computes your total used backup storage as a cumulative value. Every hour, this value is reported to the Azure billing pipeline. The pipeline is responsible for aggregating this hourly usage to calculate your consumption at the end of each month. After the database is deleted, consumption decreases as backups age out and are deleted. After all backups are deleted and PITR is no longer possible, billing stops.
    
diff --git a/azure-sql/managed-instance/automated-backups-overview.md b/azure-sql/managed-instance/automated-backups-overview.md
@@ -154,7 +154,10 @@ In other words, for any point in time during the retention period, there must be
 
 Backups that are no longer needed to provide PITR functionality are automatically deleted. Because differential backups and log backups require an earlier full backup to be restorable, all three backup types are purged together in weekly sets.
 
-For all databases, including [TDE-encrypted](../database/transparent-data-encryption-tde-overview.md) databases, backups are compressed to reduce backup storage compression and costs. Average backup compression ratio is 3 to 4 times. However, it can be significantly lower or higher depending on the nature of the data and whether data compression is used in the database.
+For all databases, including [TDE-encrypted](../database/transparent-data-encryption-tde-overview.md) databases, all full and differential backups are compressed, to reduce backup storage compression and costs. Average backup compression ratio is 3 to 4 times. However, it can be significantly lower or higher depending on the nature of the data and whether data compression is used in the database.
+
+> [!IMPORTANT]
+> For TDE-encrypted databases, log backups files are not compressed for performance reasons. Log backups for non-TDE-encrypted databases are compressed.
 
 Azure SQL Managed Instance computes your total used backup storage as a cumulative value. Every hour, this value is reported to the Azure billing pipeline. The pipeline is responsible for aggregating this hourly usage to calculate your consumption at the end of each month. After the database is deleted, consumption decreases as backups age out and are deleted. After all backups are deleted and PITR is no longer possible, billing stops.
 
diff --git a/docs/linux/sample-unattended-install-redhat.md b/docs/linux/sample-unattended-install-redhat.md
@@ -4,7 +4,7 @@ titleSuffix: SQL Server
 description: Use a sample bash script to install SQL Server on Red Hat Enterprise Linux (RHEL) without interactive input.
 author: rwestMSFT
 ms.author: randolphwest
-ms.reviewer: randolphwest
+ms.reviewer: armaha
 ms.date: 05/20/2022
 ms.service: sql
 ms.subservice: linux
@@ -31,7 +31,7 @@ This sample bash script installs [!INCLUDE [ssnoversion-md](../includes/ssnovers
 
 This example installs [!INCLUDE [sssql19-md](../includes/sssql19-md.md)] on RHEL 8.x. If you want to install a different version of [!INCLUDE [ssnoversion-md](../includes/ssnoversion-md.md)] or RHEL, change the Microsoft repository paths accordingly.
 
-Save the sample script to a file and then to customize it. You'll need to replace the variable values in the script. You can also set any of the scripting variables as environment variables, as long as you remove them from the script file.
+Save the sample script to a file. To customize it, you need to replace the variable values in the script. You can also set any of the scripting variables as environment variables, as long as you remove them from the script file.
 
 > [!IMPORTANT]  
 > The `SA_PASSWORD` environment variable is deprecated. Use `MSSQL_SA_PASSWORD` instead.
diff --git a/docs/master-data-services/master-data-services-and-data-quality-services-features-support.md b/docs/master-data-services/master-data-services-and-data-quality-services-features-support.md
@@ -8,18 +8,24 @@ ms.service: sql
 ms.subservice: master-data-services
 ms.topic: conceptual
 ---
+
 # Master Data Services and Data Quality Services Features Support
 
 [!INCLUDE [SQL Server - Windows only ASDBMI](../includes/applies-to-version/sql-windows-only-asdbmi.md)]
 
+This article describes which versions of SQL Server support [!INCLUDE[ssMDSshort_md](../includes/ssmdsshort-md.md)] and Data Quality Services.
 
-## [!INCLUDE[ssMDSshort_md](../includes/ssmdsshort-md.md)] and Data Quality Services
+## Master Data Services
 
-|Feature|Enterprise|Standard|Web|Express with Advanced Services|Express with Tools|Express|Developer|  
-|-------------|----------------|--------------|---------|------------------------------------|------------------------|-------------|---------------|  
-|[!INCLUDE[ssMDSshort](../includes/ssmdsshort-md.md)] database|Yes||||||Yes|  
-|[!INCLUDE[ssMDSmdm](../includes/ssmdsmdm-md.md)] web application|Yes||||||Yes|  
-|Data Quality Services|Yes||||||Yes|  
+|Feature |Enterprise|Standard |Web|Express with Advanced Services|Express with tools|Express|Developer|
+| -------- | -------- | -------- | -------- | -------- | -------- | -------- | -------- |
+|Master Data Services database|Yes||||||Yes|
+|Master Data Manager web application   |Yes||||||Yes|
 
+## Data Quality Services
+
+|Feature|Enterprise|Standard|Web|Express with Advanced Services|Express with Tools|Express|Developer|  
+| -------- | -------- | -------- | -------- | -------- | -------- | -------- | -------- |
+|Data Quality Services|Yes|Yes|Yes|Yes|Yes|Yes|Yes|  
 
 
diff --git a/docs/sql-server/azure-arc/data-collection.md b/docs/sql-server/azure-arc/data-collection.md
@@ -4,34 +4,34 @@ description: Explains data that Microsoft collects for reporting for Azure Arc-e
 author: anosov1960
 ms.author: sashan
 ms.reviewer: mikeray, randolphwest
-ms.date: 07/06/2023
+ms.date: 10/03/2023
 ms.topic: conceptual
 ms.custom: references_regions
 ---
 # Azure Arc-enabled SQL Server data collection and reporting
 
 [!INCLUDE [sqlserver](../../includes/applies-to-version/sqlserver.md)]
 
-This article describes the data that Azure Arc-enabled SQL Server transmits to Microsoft.
+This article describes the data that Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] transmits to Microsoft. Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] collects usage data as described in this article and at [Monitor Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)]](sql-monitoring.md).
 
-Azure Arc-enabled SQL Server, and any of the related Azure Arc-enabled services, don't store any customer data.
+Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] does not collect any personally identifiable information (PII) or end-user identifiable information, or store any customer data.
 
 ## Related products
 
-Azure Arc-enabled SQL Server uses the following products:
+Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] uses the following products:
 
 - Azure Arc-enabled servers
 
-The following data is collected to Azure for Azure Arc-enabled SQL Servers:
-
 ## Azure Arc-enabled SQL Server
 
+The following data is collected for Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] instances:
+
 | Description | Property name | Property type |
 | :-- | :-- | :-- |
 | SQL Server edition | `Edition` | `string` |
 | Resource ID of the hosting Azure Arc for Servers resource | `ContainerResourceId` | `string` |
 | Time when the resource was created | `CreateTime` | string |
-| The number of logical processors used by the SQL Server instance | `VCore` | `string` |
+| The number of logical processors used by the [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] instance | `VCore` | `string` |
 | Cloud connectivity status | `Status` | `string` |
 | SQL Server update level | `PatchLevel` | `string` |
 | SQL Server collation | `Collation` | `string` |
@@ -40,9 +40,9 @@ The following data is collected to Azure for Azure Arc-enabled SQL Servers:
 | Dynamic TCP ports used by SQL Server | `TcpDynamicPorts` | `string` |
 | Static TCP ports used by SQL Server | `TcpStaticPorts` | `string` |
 | SQL Server product ID | `ProductId` | `string` |
-| SQL Server provisioning state | `ProvisioningState` | `string` |
+| [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] provisioning state | `ProvisioningState` | `string` |
 
-The following JSON document is an example of the SQL Server - Azure Arc resource.
+The following JSON document is an example of the [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] - Azure Arc resource
 
 ```json
 {
@@ -88,7 +88,7 @@ The following JSON document is an example of the SQL Server - Azure Arc resource
 | Backup information | `backupInformation` | `object` |
 | Provisioning state | `provisioningState` | `string` |
 
-The following JSON document is an example of the SQL Server database - Azure Arc resource.
+The following JSON document is an example of the [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] database - Azure Arc resource.
 
 ```json
 {
@@ -116,6 +116,6 @@ The following JSON document is an example of the SQL Server database - Azure Arc
 
 ## Related content
 
-- [Automatically connect your SQL Server to Azure Arc](automatically-connect.md)
-- [Configure advanced data security for your SQL Server instance](configure-advanced-data-security.md)
-- [Configure best practices assessment on an Azure Arc-enabled SQL Server instance](assess.md)
+- [Automatically connect your [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] to Azure Arc](automatically-connect.md)
+- [Configure advanced data security for your [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] instance](configure-advanced-data-security.md)
+- [Configure best practices assessment on an Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] instance](assess.md)
diff --git a/docs/sql-server/azure-arc/includes/unsupported-configurations.md b/docs/sql-server/azure-arc/includes/unsupported-configurations.md
@@ -1,7 +1,7 @@
 ---
 author: MikeRayMSFT
 ms.author: mikeray
-ms.date: 09/28/2023
+ms.date: 10/03/2023
 ms.topic: include
 ---
 
@@ -11,6 +11,7 @@ Azure Arc-enabled [!INCLUDE [ssnoversion-md](../../../includes/ssnoversion-md.md
 - [!INCLUDE [ssnoversion-md](../../../includes/ssnoversion-md.md)] Failover Cluster Instances (FCI).
 - [!INCLUDE [ssnoversion-md](../../../includes/ssnoversion-md.md)] roles other than the Database Engine, such as Analysis Services (SSAS), Reporting Services (SSRS), or Integration Services (SSIS).
 - [!INCLUDE [ssnoversion-md](../../../includes/ssnoversion-md.md)] editions: Business Intelligence.
+- Private Link connections to the Azure Arc data processing service at the `san-af-<region>-prod.azurewebsites.net` endpoint used for inventory and usage upload.
 - [!INCLUDE [sql2008-md](../../../includes/sql2008-md.md)], [!INCLUDE [sql2008r2-md](../../../includes/sql2008r2-md.md)], and older versions.
 - Installing the Arc agent and [!INCLUDE [ssnoversion-md](../../../includes/ssnoversion-md.md)] extension can't be done as part of sysprep image creation.
 - [!INCLUDE [ssnoversion-md](../../../includes/ssnoversion-md.md)] in Azure Virtual Machines.
diff --git a/docs/sql-server/end-of-support/sql-server-extended-security-updates.md b/docs/sql-server/end-of-support/sql-server-extended-security-updates.md
@@ -335,9 +335,9 @@ Now you can continue to the [Confirmation](#confirmation) section.
 
 1. We recommend you use a year-specific tag to link your [!INCLUDE [ssnoversion-md](../../includes/ssnoversion-md.md)] instances to your ESU invoice number for easy reference. For example:
 
-   - First year: `Year1OrderID`
-   - Second year: `Year2OrderID`
-   - Third year: `Year3OrderID`
+   - First year: `Year1InvoiceID`
+   - Second year: `Year2InvoiceID`
+   - Third year: `Year3InvoiceID`
 
    > [!NOTE]  
    > If you use Azure services such as Azure Dedicated Host, Azure VMware Solution, Azure Nutanix Solution, and Azure Stack (Hub, Edge, and HCI), you can set the ESU invoice number to `InvoiceNotNeeded`.
diff --git a/docs/ssdt/ssis-vs2019-troubleshooting-guide.md b/docs/ssdt/ssis-vs2019-troubleshooting-guide.md
@@ -55,8 +55,10 @@ If you install successfully, but the solution shows **"incompatible"**, and "The
 1. Open Visual Studio -> Extension -> Manage Extensions -> Installed
 1. Enable SSIS extension
 1. Relaunch Visual Studio
-
-If you get an error during installation, and find **"Bundle action failed: Invalid pointer (0x80004003)"** in the log. You can check the logs under %temp%\SsdtisSetup, the  more detail log is under Microsoft.DataTools.IntegrationServices_{timestamp}_ISVsix.log:
+   
+If you get an error during installation, and find **"Process returned error: 0x80131500"** in the log. You can open %temp%\SsdtisSetup folder, search in Microsoft.DataTools.IntegrationServices_{timestamp}_ISVsix.log:
+- When the error is "Pre-check verification failed with warning(s) :  AnotherInstallationRunning.",
+  - kill MSIExec.exe in task manager, and retry. 
 - When the error is "The file {filefullpath} already exists.":
    1. ```
       cd C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE
diff --git a/docs/ssdt/ssis-vs2022-troubleshooting-guide.md b/docs/ssdt/ssis-vs2022-troubleshooting-guide.md
@@ -93,16 +93,9 @@ If you install successfully, but the solution shows **"incompatible"**, and "The
 1. Enable SSIS extension
 1. Relaunch Visual Studio
 
-If you get an error during installation, and find **"Bundle action failed: Invalid pointer (0x80004003)"** in the log. You can check the logs under %temp%\SsdtisSetup, the  more detail log is under Microsoft.DataTools.IntegrationServices_{timestamp}_ISVsix.log:
-- When the error is "The file {filefullpath} already exists.":
-   1. ```
-      cd C:\Program Files\Microsoft Visual Studio\2022\Community\Common7\IDE
-      rm CommonExtensions\Microsoft\SSIS\* 
-      rm PublicAssemblies\SSIS\* 
-      rm "PublicAssemblies\Microsoft BI\Business Intelligence Projects\Integration Services\"* 
-      ```
-   1. Repair the vs2022
-   1. Restart and reinstall
+If you get an error during installation, and find **"Process returned error: 0x80131500"** in the log. You can open %temp%\SsdtisSetup folder, search in Microsoft.DataTools.IntegrationServices_{timestamp}_ISVsix.log:
+- When the error is "Pre-check verification failed with warning(s) :  AnotherInstallationRunning.",
+  - kill MSIExec.exe in task manager, and retry. 
 - When the error is "Object reference not set to an instance of an object.",
   - delete the broken instance folder "%ProgramData%\Microsoft\VisualStudio\Packages\_Instances\<InstallationID>"
 - When the error is "Error 0x80091007: Failed to verify hash of payload",
