Merge branch 'master' of https://github.com/MicrosoftDocs/sql-docs-pr into release-sqlseattle

v-alje · v-alje · commit 8ace7959bafa · 2019-05-17T17:12:04.000-07:00
diff --git a/docs/dma/dma-migrateonpremsql.md b/docs/dma/dma-migrateonpremsql.md
@@ -2,7 +2,7 @@
 title: "Upgrade on-premises SQL Server to SQL Server or SQL Server on Azure VMs using the Data Migration Assistant | Microsoft Docs"
 description: Learn how to use Data Migration Assistant to upgrade an on-premises SQL Server to a later version of SQL Server or to SQL Server on Azure VMs
 ms.custom: ""
-ms.date: "03/12/2019"
+ms.date: "05/18/2019"
 ms.prod: sql
 ms.prod_service: "dma"
 ms.reviewer: ""
@@ -13,15 +13,15 @@ helpviewer_keywords:
   - "Data Migration Assistant, on-premises SQL Server"
 ms.assetid: ""
 author: HJToland3
-ms.author: rajpo
+ms.author: jtoland
 manager: craigg
 ---
 
 # Upgrade on-premises SQL Server to SQL Server or SQL Server on Azure VMs using the Data Migration Assistant
 
 The Data Migration Assistant provides seamless assessments of SQL Server on-premises and upgrades to later versions of SQL Server or migrations to SQL Server on Azure VMs or Azure SQL Database.
 
-This article provides step-by-step instructions for upgrading SQL Server on-premises to later version of SQL Server or to SQL Server on Azure VMs by using the Data Migration Assistant.   
+This article provides step-by-step instructions for upgrading SQL Server on-premises to later versions of SQL Server or to SQL Server on Azure VMs by using the Data Migration Assistant.
 
 ## Create a new migration project
 
diff --git a/docs/dma/dma-whatsnew.md b/docs/dma/dma-whatsnew.md
@@ -1,7 +1,7 @@
 ---
 title: "What's new in Data Migration Assistant (SQL Server) | Microsoft Docs"
 ms.custom: ""
-ms.date: "03/12/2019"
+ms.date: "05/18/2019"
 ms.prod: sql
 ms.prod_service: "dma"
 ms.reviewer: ""
@@ -12,113 +12,154 @@ helpviewer_keywords:
   - "Data Migration Assistant, new features"
 ms.assetid: ""
 author: HJToland3
-ms.author: rajpo
+ms.author: jtoland
 manager: craigg
 ---
 
 # What's new in Data Migration Assistant
 This article lists the additions in each release of Data Migration Assistant (DMA).
 
+## DMA v4.3
+
+The v4.3 release of DMA provides support for:
+
+* SKU Recommendations for Azure SQL Database managed instances based on workload assessment.
+* RDS SQL Server as a source for assessments.
+* Agent job assessments for Azure SQL Database managed instance as a target.
+* The ability to ignore certain assessment rules; the list of error codes specified in the 'ignoreErrorCodes' property configured in DMA won't show up in DMA assessment results.
+* Assessment of T-SQL queries in job activity steps and providing appropriate recommendations
+* Extended events assessments (Public Preview).
+
+In addition, this release of DMA provides improved performance for handling a large number of schema objects in databases, as well as bug fixes related to:
+
+* Procedures compiled with native compilation, in some cases.
+* Complicated database schemas.
+
+## DMA v4.2
+
+The v4.2 release of DMA provides command line support for target readiness assessment for one or more server instances when migrating from on-premises SQL Server to an Azure SQL Database managed instance. Customers can now use the DMA command line to collect metadata about their database schema, detect the blockers, and learn about partially supported or unsupported features that affect migration to an Azure SQL Database managed instance. The results can then be rendered using the Power BI template provided.
+
 ## DMA v4.1
+
 The v4.1 release of DMA introduces support for comprehensive assessment of on-premises SQL Server databases migrating to Azure SQL Database Managed Instance.
 
 The assessment workflow helps you detect the following issues, which can affect your migration to Azure SQL Database Managed Instance:
 
-- **Unsupported or partially supported features**. DMA assesses your source SQL Server database for features in use that are partially supported or unsupported on the target Azure SQL Database Managed Instance. The tool then provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that customers can take this information into account when planning their migration projects.
+* **Unsupported or partially supported features**. DMA assesses your source SQL Server database for features in use that are partially supported or unsupported on the target Azure SQL Database Managed Instance. The tool then provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that customers can take this information into account when planning their migration projects.
 
-- **Compatibility issues**. DMA also identifies compatibility issues related to the following areas:
+* **Compatibility issues**. DMA also identifies compatibility issues related to the following areas:
 
-    - Breaking changes:  The specific schema objects that may break the functionality migrating to the target database.  We recommend fixing these schema objects after the database migration.
-    - Behavioral changes: The schema objects reported may continue to work, but they may exhibit a different behavior, for example performance degradation.
-    - Informational issues:  These objects will not impact the migration but may have been deprecated from feature SQL Server releases.
+  * Breaking changes:  The specific schema objects that may break the functionality migrating to the target database.  We recommend fixing these schema objects after the database migration.
+  * Behavioral changes: The schema objects reported may continue to work, but they may exhibit a different behavior, for example performance degradation.
+  * Informational issues:  These objects won't impact the migration but may have been deprecated from feature SQL Server releases.
 
 After the assessment is complete, use our [Azure Database Migration Service](https://azure.microsoft.com/services/database-migration/) (DMS) to perform the migration of your SQL Server databases to Azure SQL Database Managed Instance.  DMS supports both [offline](https://docs.microsoft.com/azure/dms/tutorial-sql-server-to-managed-instance) (one-time) and [online](https://docs.microsoft.com/azure/dms/tutorial-sql-server-managed-instance-online) (minimal-downtime) database migrations to Azure SQL Database Managed Instance.
 
 ## DMA v4.0
+
 The v4.0 release of DMA introduces the Azure SQL Database SKU recommendations feature, which allows users to identify the minimum recommended Azure SQL Database SKU based on performance counters collected from the computer(s) hosting your databases. This feature provides recommendations related to pricing tier, compute level, and max data size, as well as estimated cost per month. It also offers the ability to provision all your databases to Azure in bulk.
 
 > [!NOTE]
-> This functionality is currently be available only via the Command Line Interface (CLI). Support for this feature via the DMA user interface is planned for delivery later this year.
+> This functionality is currently be available only via the Command Line Interface (CLI).
 
 For additional detail, see the article [Identify the right Azure SQL Database SKU for your on-premises database](dma-sku-recommend-sql-db.md).
 
 ## DMA v3.6
+
 The v3.6 release of DMA introduces "Auto fix" for the schema objects that are impacted by the most common migration blockers.
 
 This release provides autofix for the following migration blocker and behavior change issues:
-- The schema objects that use Unqualified Join syntax.
-- The schema objects that use the legacy RAISEERROR statement.
-- SQL statements that use Order By Integer Literal.
+
+* The schema objects that use Unqualified Join syntax.
+* The schema objects that use the legacy RAISEERROR statement.
+* SQL statements that use Order By Integer Literal.
 
 DMA performs automatic schema conversion for the objects impacted by the listed issues and prompts the user for confirmation before proceeding with the schema conversion. Users can review the suggested code changes and then either accept or reject all conversions for any given database object.
 
 DMA uses Microsoft Program Synthesis (PROSE) technology to suggest the code fixes. Learn more about [PROSE](https://microsoft.github.io/prose/).
 
 ## DMA v3.5
+
 The v3.5 release of DMA includes the following additions:
-- Significant performance improvements for migrating to Azure SQL Database (benchmark tests indicate the process is four times faster than with prior versions of DMA).
-- The memory footprint is further optimized to improve the stability of the migration workflow.
-- The ability to skip assessments during the schema and data migrations (if you've already performed the assessment and addressed any breaking schema objects prior to migration).
-- A fix to address an issue with the tool crashing when an invalid network share path is provided for backup files, when performing an upgrade of a legacy version of SQL Server on-premises to a later version or to SQL Server on Azure VMs.
+
+* Significant performance improvements for migrating to Azure SQL Database (benchmark tests indicate the process is four times faster than with prior versions of DMA).
+* The memory footprint is further optimized to improve the stability of the migration workflow.
+* The ability to skip assessments during the schema and data migrations (if you've already performed the assessment and addressed any breaking schema objects prior to migration).
+* A fix to address an issue with the tool crashing when an invalid network share path is provided for backup files, when performing an upgrade of a legacy version of SQL Server on-premises to a later version or to SQL Server on Azure VMs.
 
 ## DMA v3.4
+
 The v3.4 release of DMA includes the following additions:
-- Support for SQL Server 2017 as a source for migrations to Azure SQL Database.
-- Enhancements to stability, performance, and assessment rule correctness.
+
+* Support for SQL Server 2017 as a source for migrations to Azure SQL Database.
+* Enhancements to stability, performance, and assessment rule correctness.
 
 ## DMA v3.3
+
 The v3.3 release of DMA enables migration of an on-premises SQL Server instance to the new version of SQL Server 2017, on both Windows and Linux. While the overall migration workflow for Windows and Linux is the same, the move to SQL Server 2017 for Linux requires a couple of additional considerations.
 
 ### Specifying the back-up path
+
 Linux and Windows use different path formats. As a result, migrating to SQL Server 2017 on Linux requires that the user provide both the Windows and Linux versions of the path to the location of the physical file. You can provide both versions of the path in different ways depending on the location of the physical file.
 If the physical back-up file is on a computer running:
-- Linux, use a 'samba' share to share the file with other computers on the network.
-- Windows, use the 'mnt' command to mount the share onto the computer running Linux.
+
+* Linux, use a 'samba' share to share the file with other computers on the network.
+* Windows, use the 'mnt' command to mount the share onto the computer running Linux.
 
 > [!NOTE]
 > Details of using a 'samba' share or the 'mnt' command are beyond the scope of this article.
 
 ### Migrating Windows logins
+
 While the migration of Active Directory (AD) logins is officially supported by SQL Server 2017 on Linux, it requires additional configuration to work successfully. Refer to the article [Active Directory Authentication with SQL Server on Linux](https://docs.microsoft.com/sql/linux/sql-server-linux-active-directory-authentication) for detailed information about setting up Active Directory logins on SQL Server 2017 on Linux. After performing the required configuration, the setup is complete and you can migrate Active Directory logins as usual. Standard SQL Authentication works as expected without any additional setup.
 
 ## DMA v3.2
+
 The v3.2 release of DMA includes the following additions:
 
-- Schema and data migration are enabled from on-premises SQL Server databases to Azure SQL Database with a new migration workflow.
-- During schema migration to Azure SQL Database, DMA scripts your source database objects, provides guidance on how to fix any potential compatibility issues, and then deploys your schema to Azure.
+* Schema and data migration are enabled from on-premises SQL Server databases to Azure SQL Database with a new migration workflow.
+* During schema migration to Azure SQL Database, DMA scripts your source database objects, provides guidance on how to fix any potential compatibility issues, and then deploys your schema to Azure.
 
 ## DMA v3.1
+
 The v3.1 release of DMA includes the following additions:
 
-- Improved assessment recommendations for Azure SQL Databases in terms of database collations, use of unsupported system stored procedures, and CLR objects.
-- Assessment guidance for compatibility levels 130, 120, 110, and 100 when migrating to Azure SQL Databases.
+* Improved assessment recommendations for Azure SQL Databases in terms of database collations, use of unsupported system stored procedures, and CLR objects.
+* Assessment guidance for compatibility levels 130, 120, 110, and 100 when migrating to Azure SQL Databases.
 
 ## DMA v3.0
+
 The v3.0 release of DMA extends the Azure SQL database assessment to provide comprehensive recommendations to help fix issues related to:
 
-- Migration blocking issues.
-- Partially or unsupported features and functions.
+* Migration blocking issues.
+* Partially or unsupported features and functions.
 
 ## DMA v2.1
+
 The v2.1 release of DMA includes the following additions:
-- Command-line support for running assessments in an unattended mode, which helps to run assessments at scale. For additional detail, refer to the article [Run Data Migration Assistant from the command line](dma-commandline.md).
-- Performance improvements when users launch and close DMA.
-- The ability to configure SQL connection time-out. For additional detail, refer to the article [Configuration settings for Data Migration Assistant](dma-configurationsettings.md).
+
+* Command-line support for running assessments in an unattended mode, which helps to run assessments at scale. For additional detail, refer to the article [Run Data Migration Assistant from the command line](dma-commandline.md).
+* Performance improvements when users launch and close DMA.
+* The ability to configure SQL connection time-out. For additional detail, refer to the article [Configuration settings for Data Migration Assistant](dma-configurationsettings.md).
 
 ## DMA v2.0
+
 The v2.0 release of DMA includes improved Stretch database feature recommendations to provide proper prioritized tables that maximize the storage savings.
 
 ## DMA v1.0
+
 The v1.0 release of DMA is the initial release, and it provides for:
-- Discovery of issues that can affect an upgrade to an on-premises version of SQL Server. Any findings are described as compatibility issues, and they're categorized into the following areas:
-    - Breaking changes
-    - Behavior changes
-    - Deprecated features
-- Discovery of new features in the target SQL Server platform that the database can benefit from an upgrade. Any findings are described as feature recommendations, and they're categorized into the following areas:
-    - Performance
-    - Security
-    - Storage
--	Modern user experience to perform assessments.
+
+* Discovery of issues that can affect an upgrade to an on-premises version of SQL Server. Any findings are described as compatibility issues, and they're categorized into the following areas:
+  * Breaking changes
+  * Behavior changes
+  * Deprecated features
+* Discovery of new features in the target SQL Server platform that the database can benefit from after an upgrade. Any findings are described as feature recommendations, and they're categorized into the following areas:
+  * Performance
+  * Security
+  * Storage
+* Modern user experience to perform assessments.
 
 ## See also
+
 [Overview of Data Migration Assistant](../dma/dma-overview.md)
diff --git a/docs/reporting-services/choosing-microsoft-business-intelligence-bi-tools-for-analysis-and-reporting.md b/docs/reporting-services/choosing-microsoft-business-intelligence-bi-tools-for-analysis-and-reporting.md
@@ -5,7 +5,7 @@ ms.author: maggies
 manager: kfile
 ms.reviewer: ""
 ms.prod: reporting-services, sql-server
-ms.prod_service: reporting-services-native, reporting-services-sharepoint 
+ms.prod_service: reporting-services-native
 ms.topic: conceptual
 ms.custom: seodec18
 ms.date: 12/14/2018
diff --git a/docs/reporting-services/report-builder/print-a-report-reporting-services-in-sharepoint-mode.md b/docs/reporting-services/report-builder/print-a-report-reporting-services-in-sharepoint-mode.md
@@ -1,6 +1,6 @@
 ---
 title: "Print a Report (Reporting Services in SharePoint Mode) | Microsoft Docs"
-ms.date: 03/01/2017
+ms.date: 05/14/2019
 ms.prod: reporting-services
 ms.prod_service: "reporting-services-native"
 ms.technology: report-builder
@@ -13,6 +13,8 @@ helpviewer_keywords:
 ms.assetid: 026784f7-8cb4-4351-93ee-230b2ab0f8f5
 author: maggiesMSFT
 ms.author: maggies
+monikerRange: ">=sql-server-2016 <=sql-server-2016||=sqlallproducts-allversions"
+
 ---
 # Print a Report (Reporting Services in SharePoint Mode)
   For a report server that runs in SharePoint mode, there are three ways to print a report from a SharePoint Web application:  
diff --git a/docs/reporting-services/report-data/report-data-ssrs.md b/docs/reporting-services/report-data/report-data-ssrs.md
@@ -5,7 +5,7 @@ ms.author: maggies
 manager: kfile
 ms.reviewer: ""
 ms.prod: reporting-services
-ms.prod_service: reporting-services-sharepoint, reporting-services-native
+ms.prod_service: reporting-services-native
 ms.technology: report-data
 ms.topic: conceptual
 ms.custom: seodec18
@@ -15,6 +15,9 @@ ms.date: 12/14/2018
 # Report Data in SQL Server Reporting Services (SSRS)
 
   Report data can come from multiple sources of data in your organization. Your first step in designing a report is to create data sources and datasets that represent the underlying report data. Each data source includes data connection information. Each dataset includes a query command that defines the set of fields to use as data from a data source. To visualize data from each dataset, add a data region, such as a table, matrix, chart, or map. When the report is processed, the queries run on the data source, and each data region expands as needed to display the query results for the dataset.  
+
+> [!NOTE]
+> Reporting Services integration with SharePoint is no longer available after SQL Server 2016.
   
 ##  <a name="BkMk_ReportDataTerms"></a> Terms  
   
diff --git a/docs/reporting-services/report-server/configure-a-report-server-on-a-network-load-balancing-cluster.md b/docs/reporting-services/report-server/configure-a-report-server-on-a-network-load-balancing-cluster.md
@@ -3,7 +3,8 @@ title: "Configure a Report Server on a Network Load Balancing Cluster | Microsof
 author: maggiesMSFT
 ms.author: maggies
 manager: kfile
-ms.prod: reporting-services, reporting-services-sharepoint, reporting-services-native
+ms.prod: reporting-services
+ms.prod_service: reporting-services-native
 ms.technology: report-server
 ms.topic: conceptual
 ms.date: 10/03/2018
diff --git a/docs/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016.md b/docs/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016.md
@@ -1,7 +1,7 @@
 ---
 title: SQL Server Reporting Services features supported by its editions
 ms.prod: reporting-services
-ms.prod_service: reporting-services-sharepoint, reporting-services-native
+ms.prod_service: reporting-services-native
 ms.technology: reporting-services
 ms.topic: conceptual
 author: maggiesMSFT
diff --git a/docs/reporting-services/reports/previewing-reports.md b/docs/reporting-services/reports/previewing-reports.md
@@ -5,7 +5,7 @@ ms.author: maggies
 manager: kfile
 ms.reviewer: ""
 ms.prod: reporting-services
-ms.prod_service: reporting-services-sharepoint, reporting-services-native
+ms.prod_service: reporting-services-native
 ms.technology: reports
 ms.topic: conceptual
 ms.custom: seodec18
diff --git a/docs/reporting-services/tools/tutorial-how-to-locate-and-start-reporting-services-tools-ssrs.md b/docs/reporting-services/tools/tutorial-how-to-locate-and-start-reporting-services-tools-ssrs.md
diff --git a/docs/t-sql/functions/aggregate-functions-transact-sql.md b/docs/t-sql/functions/aggregate-functions-transact-sql.md
diff --git a/docs/t-sql/functions/patindex-transact-sql.md b/docs/t-sql/functions/patindex-transact-sql.md
