fix links

v-thepet · v-thepet · commit 14b73d933891 · 2019-11-19T11:38:03.000-08:00
diff --git a/docs/2014/database-engine/import-the-sqlps-module.md b/docs/2014/database-engine/import-the-sqlps-module.md
@@ -35,7 +35,7 @@ manager: craigg
 >  The verbs used in the names of two SQL Server cmdlets (`Encode-Sqlname` and `Decode-Sqlname`) do not match the approved verbs for Windows PowerShell 2.0. This has no effect on their operation, but Windows PowerShell raises a warning when the `sqlps` module is imported to a session.  
   
 ###  <a name="Security"></a> Security  
- By default, Windows PowerShell runs with the scripting execution policy set to **Restricted**, which prevents running any Windows PowerShell scripts. To load the `sqlps` module, you can use the `Set-ExecutionPolicy` cmdlet to enable running signed scripts, or any scripts. Only run scripts from trusted sources, and secure all input and output files using the appropriate NTFS permissions. For more information about enabling Windows PowerShell scripts, see [Running Windows PowerShell Scripts](https://docs.microsoft.com/powershell/scripting/setup/starting-windows-powershell?view=powershell-6#how-to-enable-windows-powershell-ise-on-earlier-releases-of-windows).  
+ By default, Windows PowerShell runs with the scripting execution policy set to **Restricted**, which prevents running any Windows PowerShell scripts. To load the `sqlps` module, you can use the `Set-ExecutionPolicy` cmdlet to enable running signed scripts, or any scripts. Only run scripts from trusted sources, and secure all input and output files using the appropriate NTFS permissions. For more information about enabling Windows PowerShell scripts, see [Running Windows PowerShell Scripts](https://docs.microsoft.com/powershell/scripting/getting-started/starting-windows-powershell?view=powershell-6#how-to-enable-windows-powershell-ise-on-earlier-releases-of-windows).  
   
 ##  <a name="LoadSqlps"></a> Load the sqlps Module  
 
diff --git a/docs/2014/reporting-services/report-data/power-pivot-connection-type-ssrs.md b/docs/2014/reporting-services/report-data/power-pivot-connection-type-ssrs.md
@@ -19,7 +19,7 @@ manager: kfile
 ## Prerequisites  
  The PowerPivot data source must be published in a PowerPivot Gallery on a SharePoint site.  
   
- To support connections from Report Builder to a PowerPivot workbook, you must have SQL Server 2008 R2 ADOMD.NET on your workstation computer. This client library is installed with PowerPivot for Excel, but if you are using a computer that does not have this application, you must download and install ADOMD.NET from the [SQL Server 2008 R2 Feature Pack](https://go.microsoft.com/fwlink/?LinkId=192565).  
+ To support connections from Report Builder to a PowerPivot workbook, you must have SQL Server 2008 R2 ADOMD.NET on your workstation computer. This client library is installed with PowerPivot for Excel, but if you are using a computer that does not have this application, you must download and install ADOMD.NET from the [SQL Server 2008 R2 Feature Pack](https://www.microsoft.com/download/details.aspx?id=16978).  
   
 ## Data Source Type  
  Use report data source type **Microsoft SQL Server Analysis Services**.  
diff --git a/docs/2014/sql-server/install/initial-configuration-powerpivot-for-sharepoint.md b/docs/2014/sql-server/install/initial-configuration-powerpivot-for-sharepoint.md
@@ -221,7 +221,7 @@ manager: craigg
   
  Installing the provider will allow workbooks that reference MSOLAP.4 in the data connection string to work as expected on a [!INCLUDE[ssSQL11](../../includes/sssql11-md.md)] PowerPivot server. Installing the SQL Server 2008 R2 OLE DB provider is an alternative approach to upgrading workbooks that were created in an earlier version of PowerPivot for Excel.  
   
- You can download the provider from [SQL Server 2008 R2 Feature Pack page](https://go.microsoft.com/fwlink/?LinkId=159570). Look for **Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2**, and then download the x64 Package of the `SQLServer2008_ASOLEDB10.msi` installation program.  
+ You can download the provider from [SQL Server 2008 R2 Feature Pack page](https://www.microsoft.com/download/details.aspx?id=16978). Look for **Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2**, and then download the x64 Package of the `SQLServer2008_ASOLEDB10.msi` installation program.  
   
  For more information about installing the provider, including verification steps, see [Install the Analysis Services OLE DB Provider on SharePoint Servers](../../../2014/sql-server/install/install-the-analysis-services-ole-db-provider-on-sharepoint-servers.md).  
   
diff --git a/docs/2014/sql-server/install/install-the-analysis-services-ole-db-provider-on-sharepoint-servers.md b/docs/2014/sql-server/install/install-the-analysis-services-ole-db-provider-on-sharepoint-servers.md
@@ -121,7 +121,7 @@ manager: craigg
   
 #### Step 1: Download and install the client library  
   
-1.  On the [SQL Server 2008 R2 Feature Pack page](https://go.microsoft.com/fwlink/?LinkId=159570), find Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008 R2.  
+1.  On the [SQL Server 2008 R2 Feature Pack page](https://www.microsoft.com/download/details.aspx?id=16978), find Microsoft Analysis Services OLE DB Provider for Microsoft SQL Server 2008 R2.  
   
 2.  Download the x64 Package of the `SQLServer2008_ASOLEDB10.msi` installation program. Although the file name contains SQLServer2008, it is the correct file for the SQL Server 2008 R2 version of the provider.  
   
diff --git a/docs/advanced-analytics/known-issues-for-sql-server-machine-learning-services.md b/docs/advanced-analytics/known-issues-for-sql-server-machine-learning-services.md
@@ -697,7 +697,7 @@ If you have an existing license for Revolution R Enterprise, you must put it on
 
 Some pre-release versions of [!INCLUDE[rsql_productname](../includes/rsql-productname-md.md)] included an R development environment for Windows that was created by Revolution Analytics. This tool is no longer provided, and is not supported.
 
-For compatibility with [!INCLUDE[rsql_productname](../includes/rsql-productname-md.md)], we recommend that you install Microsoft R Client instead. [R Tools for Visual Studio](https://www.visualstudio.com/vs/rtvs/) and [Visual Studio Code](https://code.visualstudio.com/) also supports Microsoft R solutions.
+For compatibility with [!INCLUDE[rsql_productname](../includes/rsql-productname-md.md)], we recommend that you install Microsoft R Client instead. [R Tools for Visual Studio](https://marketplace.visualstudio.com/items?itemName=MikhailArkhipov007.RTVS2019) and [Visual Studio Code](https://code.visualstudio.com/) also supports Microsoft R solutions.
 
 ### 2. Compatibility issues with SQLite ODBC driver and RevoScaleR
 
diff --git a/docs/advanced-analytics/r/set-up-a-data-science-client.md b/docs/advanced-analytics/r/set-up-a-data-science-client.md
@@ -213,7 +213,7 @@ When you reopen RStudio, the R executable from R Client (or standalone server) i
 
 If you don't already have a preferred IDE for R, we recommend **R Tools for Visual Studio**.
 
-+ [Download R Tools for Visual Studio (RTVS)](https://visualstudio.microsoft.com/vs/features/rtvs/)
++ [Download R Tools for Visual Studio (RTVS)](https://marketplace.visualstudio.com/items?itemName=MikhailArkhipov007.RTVS2019)
 + [Installation instructions](https://docs.microsoft.com/visualstudio/rtvs/installing-r-tools-for-visual-studio) - RTVS is available in several versions of Visual Studio.
 + [Get started with R Tools for Visual Studio](https://docs.microsoft.com/visualstudio/rtvs/getting-started-with-r)
 
diff --git a/docs/advanced-analytics/tutorials/deepdive-data-science-deep-dive-using-the-revoscaler-packages.md b/docs/advanced-analytics/tutorials/deepdive-data-science-deep-dive-using-the-revoscaler-packages.md
@@ -44,7 +44,7 @@ For instructions on client configuration, see [Set up a data science client for
 
 R developers typically use IDEs for writing and debugging R code. Here are some suggestions:
 
-- **R Tools for Visual Studio** (RTVS) is a free plug-in that provides Intellisense, debugging, and support for Microsoft R. You can use it with both R Server and SQL Server Machine Learning Services. To download, see [R Tools for Visual Studio](https://www.visualstudio.com/vs/rtvs/).
+- **R Tools for Visual Studio** (RTVS) is a free plug-in that provides Intellisense, debugging, and support for Microsoft R. You can use it with both R Server and SQL Server Machine Learning Services. To download, see [R Tools for Visual Studio](https://marketplace.visualstudio.com/items?itemName=MikhailArkhipov007.RTVS2019).
 
 - **RStudio** is one of the more popular environments for R development. For more information, see [https://www.rstudio.com/products/RStudio/](https://www.rstudio.com/products/RStudio/).
 
diff --git a/docs/analytics-platform-system/install-the-scom-management-packs.md b/docs/analytics-platform-system/install-the-scom-management-packs.md
@@ -21,7 +21,7 @@ System Center Operations Manager must be installed and running. SQL Server PDW 2
 ## <a name="Step1"></a>Step 1: Download the Management Packs  
 For the APS PDW workload, download the [System Center Management Pack for the Microsoft Analytics Platform System](https://go.microsoft.com/fwlink/?LinkId=396857).  
   
-For the appliance management, download the [SQL Server Appliance Base Management Pack](https://www.microsoft.com/download/details.aspx?displaylang=en&id=11436).  
+For the appliance management, download the [SQL Server Appliance Base Management Pack](https://docs.microsoft.com/previous-versions/system-center/packs/gg602398(v=technet.10)).  
   
 For older versions of PDW without APS, download the[System Center Monitoring Pack for Microsoft SQL Server 2012 Parallel Data Warehouse Appliance](https://go.microsoft.com/fwlink/p/?LinkId=282661).  
   
diff --git a/docs/connect/python/pymssql/python-sql-driver-pymssql.md b/docs/connect/python/pymssql/python-sql-driver-pymssql.md
@@ -21,4 +21,4 @@ ms.author: genemi
 * [Step 3: Proof of concept connecting to SQL using pymssql](../../../connect/python/pymssql/step-3-proof-of-concept-connecting-to-sql-using-pymssql.md)  
 
 ## Documentation
-* [pymssql documentation](https://pymssql.org)  
+* [pymssql documentation](https://pypi.org/project/pymssql/)  
diff --git a/docs/connect/python/pymssql/step-3-proof-of-concept-connecting-to-sql-using-pymssql.md b/docs/connect/python/pymssql/step-3-proof-of-concept-connecting-to-sql-using-pymssql.md
@@ -18,7 +18,7 @@ This example should be considered a proof of concept only.  The sample code is s
   
 ## Step 1:  Connect  
   
-The [pymssql.connect](https://pymssql.org/en/latest/ref/pymssql.html) function is used to connect to SQL Database.  
+The [pymssql.connect](https://pypi.org/project/pymssql/) function is used to connect to SQL Database.  
   
 ```python
     import pymssql  
@@ -28,7 +28,7 @@ The [pymssql.connect](https://pymssql.org/en/latest/ref/pymssql.html) function i
   
 ## Step 2:  Execute query  
   
-The [cursor.execute](https://pymssql.org/en/latest/ref/pymssql.html#pymssql.Cursor.execute) function can be used to retrieve a result set from a query against SQL Database. This function essentially accepts any query and returns a result set which can be iterated over with the use of [cursor.fetchone()](https://pymssql.org/en/latest/ref/pymssql.html#pymssql.Cursor.fetchone).  
+The [cursor.execute](https://pypi.org/project/pymssql/) function can be used to retrieve a result set from a query against SQL Database. This function essentially accepts any query and returns a result set which can be iterated over with the use of [cursor.fetchone()](https://pypi.org/project/pymssql/).  
   
   
 ```python
diff --git a/docs/database-engine/install-windows/install-sql-server-powershell.md b/docs/database-engine/install-windows/install-sql-server-powershell.md
@@ -28,7 +28,7 @@ You install the software that provides [!INCLUDE[ssNoVersion](../../includes/ssn
  
 - [!INCLUDE[ssManStudioFull](../../includes/ssmanstudiofull-md.md)] supports starting Windows PowerShell sessions from the Object Explorer tree. [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent supports Windows PowerShell job steps.  
   
-Windows Server 2012 and later and Windows 8 and later come with PowerShell installed and configured. For information about installing Windows PowerShell see [Installing Windows PowerShell](https://docs.microsoft.com/powershell/scripting/setup/installing-windows-powershell).  
+Windows Server 2012 and later and Windows 8 and later come with PowerShell installed and configured. For information about installing Windows PowerShell see [Installing Windows PowerShell](https://docs.microsoft.com/powershell/scripting/install/installing-windows-powershell).  
 
 For more information, see:   
 
