Linkfix: SQL (2021-10)

v-kents · v-kents · commit dbb8b8cab8b6 · 2021-10-06T11:09:12.000-07:00
diff --git a/docs/big-data-cluster/active-directory-deploy.md b/docs/big-data-cluster/active-directory-deploy.md
@@ -129,7 +129,7 @@ For details on how to update the AD groups for these settings see [Manage Big Da
 
 > [!NOTE]
 > The `security.activeDirectory.enableAES` parameter is available starting with SQL Server Big Data Clusters CU13. If the big data cluster is a version prior to CU13, the following steps are required:
-> 1. Run the `azdata bdc rotate -n <your-cluster-name>` command, this command will rotate the keytabs in the cluster which is necessary to ensure that the AES entries in keytabs are correct. For more information, see [azdata bdc](/sql/azdata/reference/reference-azdata-bdc). Additionally, `azdata bdc rotate` will rotate the passwords of the AD objects that were auto-generated during the initial deployment in the specified OU.
+> 1. Run the `azdata bdc rotate -n <your-cluster-name>` command, this command will rotate the keytabs in the cluster which is necessary to ensure that the AES entries in keytabs are correct. For more information, see [azdata bdc](../azdata/reference/reference-azdata-bdc.md). Additionally, `azdata bdc rotate` will rotate the passwords of the AD objects that were auto-generated during the initial deployment in the specified OU.
 > 2. Set the the following flags 'This account supports Kerberos AES 128 bit encryption' and 'This account supports Kerberos AES 256 bit encryption' on each of auto-generated AD objects in the OU that you provided during the initial big data cluster deployment. This can be achieved by executing the following PowerShell script  `Get-ADUser -Filter * -SearchBase '<OU Path>' | Set-ADUser -replace @{ 'msDS-SupportedEncryptionTypes' = '24' }` on your domain controller which sets the AES fields on each account in the OU given in `<OU Path>` parameter.
 
   >[!IMPORTANT]
diff --git a/docs/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server.md b/docs/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server.md
@@ -62,8 +62,8 @@ manager: erikre
   
 |Permissions|Link|  
 |-----------------|----------|  
-|The cluster name object (CNO) of WSFC cluster that is hosting the availability group must have **Create Computer objects** permission.<br /><br /> In Active Directory, a CNO by default does not have **Create Computer objects** permission explicitly and can create 10 virtual computer objects (VCOs). After 10 VCOs are created, the creation of additional VCOs will fail. You can avoid this by granting the permission explicitly to the WSFC cluster's CNO. Note that VCOs for availability groups that you have deleted are not automatically deleted in Active Directory and count against your 10 VCO default limit unless they are manually deleted.<br /><br /> Note: In some organizations, the security policy prohibits granting **Create Computer objects** permission to individual user accounts.|*Steps for configuring the account for the person who installs the cluster* in [Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory](https://technet.microsoft.com/library/cc731002\(WS.10\).aspx#BKMK_steps_installer)<br /><br /> *Steps for prestaging the cluster name account* in [Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory](https://technet.microsoft.com/library/cc731002\(WS.10\).aspx#BKMK_steps_precreating)|  
-|If your organization requires that you prestage the computer account for a listener virtual network name, you will need membership in the **Account Operator** group or your domain administrator's assistance.|*Steps for prestaging an account for a clustered service or application* in [Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory](https://technet.microsoft.com/library/cc731002\(WS.10\).aspx#BKMK_steps_precreating2).|  
+|The cluster name object (CNO) of WSFC cluster that is hosting the availability group must have **Create Computer objects** permission.<br /><br /> In Active Directory, a CNO by default does not have **Create Computer objects** permission explicitly and can create 10 virtual computer objects (VCOs). After 10 VCOs are created, the creation of additional VCOs will fail. You can avoid this by granting the permission explicitly to the WSFC cluster's CNO. Note that VCOs for availability groups that you have deleted are not automatically deleted in Active Directory and count against your 10 VCO default limit unless they are manually deleted.<br /><br /> Note: In some organizations, the security policy prohibits granting **Create Computer objects** permission to individual user accounts.|*Steps for configuring the account for the person who installs the cluster* in [Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory](/#BKMK_steps_installer)<br /><br /> *Steps for prestaging the cluster name account* in [Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory](/#BKMK_steps_precreating)|  
+|If your organization requires that you prestage the computer account for a listener virtual network name, you will need membership in the **Account Operator** group or your domain administrator's assistance.|*Steps for prestaging an account for a clustered service or application* in [Failover Cluster Step-by-Step Guide: Configuring Accounts in Active Directory](/#BKMK_steps_precreating2).|  
   
 > [!TIP]  
 >  Generally, it is simplest not to prestage the computer account for a listener virtual network name. If you can, let the account to be created and configured automatically when you run the WSFC High Availability wizard.  
diff --git a/docs/includes/alter-workload-group.md b/docs/includes/alter-workload-group.md
@@ -53,7 +53,7 @@ ALTER WORKLOAD GROUP { group_name | "default" }
  -  For user-defined workload groups, the server tries to reduce the query degree of parallelism until the memory requirement falls under the limit, or until the degree of parallelism equals 1. If the query memory requirement is still greater than the limit, error 8657 occurs.    
  -  For internal and default workload groups, the server permits the query to obtain the required memory.  
    
- Be aware that both cases are subject to [time-out error 8645](/sql/relational-databases/errors-events/mssqlserver-8645-database-engine-error) if the server has insufficient physical memory.  
+ Be aware that both cases are subject to [time-out error 8645](../relational-databases/errors-events/mssqlserver-8645-database-engine-error.md) if the server has insufficient physical memory.  
   
 #### REQUEST_MAX_CPU_TIME_SEC = *value*       
  Specifies the maximum amount of CPU time, in seconds, that a request can use. *value* must be 0 or a positive integer. The default setting for *value* is 0, which means unlimited. By default, Resource Governor will not prevent a request from continuing if the maximum time is exceeded. However, an event will be generated. For more information, see [CPU Threshold Exceeded Event Class](../relational-databases/event-classes/cpu-threshold-exceeded-event-class.md). 
@@ -146,4 +146,4 @@ GO
  [CREATE RESOURCE POOL &#40;Transact-SQL&#41;](../t-sql/statements/create-resource-pool-transact-sql.md)   
  [ALTER RESOURCE POOL &#40;Transact-SQL&#41;](../t-sql/statements/alter-resource-pool-transact-sql.md)   
  [DROP RESOURCE POOL &#40;Transact-SQL&#41;](../t-sql/statements/drop-resource-pool-transact-sql.md)   
- [ALTER RESOURCE GOVERNOR &#40;Transact-SQL&#41;](../t-sql/statements/alter-resource-governor-transact-sql.md)  
+ [ALTER RESOURCE GOVERNOR &#40;Transact-SQL&#41;](../t-sql/statements/alter-resource-governor-transact-sql.md)
diff --git a/docs/linux/sql-server-linux-performance-get-started.md b/docs/linux/sql-server-linux-performance-get-started.md
@@ -157,7 +157,7 @@ For more information about In-Memory OLTP, see the following topics:
 - [Migrating to In-Memory OLTP](../relational-databases/in-memory-oltp/plan-your-adoption-of-in-memory-oltp-features-in-sql-server.md)
 - [Faster temp table and table variable by using memory optimization](../relational-databases/in-memory-oltp/faster-temp-table-and-table-variable-by-using-memory-optimization.md)
 - [Monitor and Troubleshoot Memory Usage](../relational-databases/in-memory-oltp/monitor-and-troubleshoot-memory-usage.md)
-- [In-Memory OLTP (In-Memory Optimization)](../relational-databases/in-memory-oltp/in-memory-oltp-in-memory-optimization.md)
+- [In-Memory OLTP (In-Memory Optimization)](../relational-databases/in-memory-oltp/overview-and-usage-scenarios.md)
 
 ## Use Query Store
 Query Store collects detailed performance information about queries, execution plans, and runtime statistics.
diff --git a/docs/linux/sql-server-linux-setup-sql-agent.md b/docs/linux/sql-server-linux-setup-sql-agent.md
@@ -53,7 +53,7 @@ sudo systemctl restart mssql-server
 > If you are upgrading from 2017 CU3 or below with Agent installed, SQL Server Agent will be enabled automatically and previous Agent packages will be uninstalled.  
 
 > [!NOTE]
-> SQL Server Management Studio Object Explorer does not display the contents of the SQL Server Agent node unless *Agent XPs* extended stored procedures are enabled, regardless of the SQL Server Agent service state. For more information, see [Agent XPs Server Configuration Option](/sql/database-engine/configure-windows/agent-xps-server-configuration-option)
+> SQL Server Management Studio Object Explorer does not display the contents of the SQL Server Agent node unless *Agent XPs* extended stored procedures are enabled, regardless of the SQL Server Agent service state. For more information, see [Agent XPs Server Configuration Option](../database-engine/configure-windows/agent-xps-server-configuration-option.md)
 
 ## <a name="InstallAgentBelowCU4"></a>Install the SQL Server Agent
 
diff --git a/docs/machine-learning/python/reference/azureml-model-management-sdk/azureml-model-management-sdk.md b/docs/machine-learning/python/reference/azureml-model-management-sdk/azureml-model-management-sdk.md
@@ -37,7 +37,7 @@ This topic is a high-level description of package functionality. These classes a
 |--------|-|
 | Current version: |  1.0.1b7 |
 | Built on: | [Anaconda](https://www.continuum.io/why-anaconda) distribution of [Python 3.5](https://www.python.org/doc) |
-| Package distribution: | [Machine Learning Server 9.x](/machine-learning-server/what-is-machine-learning-server) </br>[SQL Server 2017 Machine Learning Server (Standalone)](/sql/machine-learning/r/r-server-standalone#whats-new-in-microsoft-machine-learning-server) |
+| Package distribution: | [Machine Learning Server 9.x](/machine-learning-server/what-is-machine-learning-server) </br>[SQL Server 2017 Machine Learning Server (Standalone)](../../../r/r-server-standalone.md#whats-new-in-microsoft-machine-learning-server) |
 
 
 
@@ -84,7 +84,7 @@ There are three primary use cases for this release:
 
 Add both Python modules to your computer by running setup: 
 
-+ Set up [Machine Learning Server](/machine-learning-server/install/machine-learning-server-install) for Python or [Python Machine Learning Services](/sql/machine-learning/install/sql-machine-learning-services-windows-install).
++ Set up [Machine Learning Server](/machine-learning-server/install/machine-learning-server-install) for Python or [Python Machine Learning Services](../../../install/sql-machine-learning-services-windows-install.md).
 
 Next, follow this quickstart to try it yourself:
 
diff --git a/docs/machine-learning/r/reference/microsoftml/rxfastforest.md b/docs/machine-learning/r/reference/microsoftml/rxfastforest.md
@@ -279,7 +279,7 @@ Microsoft Corporation [`Microsoft Technical Support`](https://go.microsoft.com/f
 [`Quantile regression forest`](http://jmlr.org/papers/volume7/meinshausen06a/meinshausen06a.pdf)
 
 
-[`From Stumps to Trees to Forests`](https://blogs.technet.microsoft.com/machinelearning/2014/09/10/from-stumps-to-trees-to-forests/)
+[`From Stumps to Trees to Forests`](/archive/blogs/machinelearning/from-stumps-to-trees-to-forests)
 
 
 
@@ -335,8 +335,3 @@ Microsoft Corporation [`Microsoft Technical Support`](https://go.microsoft.com/f
   # Plot actual versus predicted values with smoothed line
   rxLinePlot(Score ~ Ozone, type = c("p", "smooth"), data = rxFastForestScoreDF)
 ```
-
-
-
-
-
diff --git a/docs/machine-learning/r/reference/microsoftml/rxlogisticregression.md b/docs/machine-learning/r/reference/microsoftml/rxlogisticregression.md
@@ -299,7 +299,7 @@ Microsoft Corporation [`Microsoft Technical Support`](https://go.microsoft.com/f
 [`Training of L1-Regularized Log-Linear Models`](https://research.microsoft.com/apps/pubs/default.aspx?id=78900)
 
 
-[`and L2 Regularization for Machine Learning`](https://msdn.microsoft.com/magazine/dn904675.aspx)
+[`and L2 Regularization for Machine Learning`](/archive/msdn-magazine/2015/february/test-run-l1-and-l2-regularization-for-machine-learning)
 
 
 
@@ -352,7 +352,3 @@ Microsoft Corporation [`Microsoft Technical Support`](https://go.microsoft.com/f
   badPrediction = scoreMultiDF$Species != scoreMultiDF$PredictedLabel
   scoreMultiDF[badPrediction,]
 ```
-
-
-
-
diff --git a/docs/machine-learning/r/reference/microsoftml/rxoneclasssvm.md b/docs/machine-learning/r/reference/microsoftml/rxoneclasssvm.md
@@ -224,7 +224,7 @@ Microsoft Corporation [`Microsoft Technical Support`](https://go.microsoft.com/f
 [`Anomaly detection`](https://en.wikipedia.org/wiki/Anomaly_detection)
 
 
-[`Azure Machine Learning Studio (classic): One-Class Support Vector Machine`](https://msdn.microsoft.com/library/azure/dn913103.aspx)
+[`Azure Machine Learning Studio (classic): One-Class Support Vector Machine`](/azure/machine-learning/studio-module-reference/one-class-support-vector-machine)
 
 
 [`Support of a High-Dimensional Distribution`](https://research.microsoft.com/pubs/69731/tr-99-87.pdf)
@@ -279,8 +279,3 @@ Microsoft Corporation [`Microsoft Technical Support`](https://go.microsoft.com/f
   # Look at average scores conditioned by 'isIris'
   rxCube(Score ~ F(isIris), data = scoreDF)
 ```
-
-
-
-
-
diff --git a/docs/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002.md b/docs/relational-databases/logs/troubleshoot-a-full-transaction-log-sql-server-error-9002.md
@@ -298,7 +298,7 @@ AND bs.backup_start_date > DATEADD(month, -2, sysdatetime()) --only look at last
 ORDER BY bs.database_name asc, bs.Backup_Start_Date desc;
 ```
 
-A complete history of all SQL Server backup and restore operations on a server instance is stored in the `msdb` system database. For more information on backup history, see [Backup History and Header Information (SQL Server)](/sql/relational-databases/backup-restore/backup-history-and-header-information-sql-server).
+A complete history of all SQL Server backup and restore operations on a server instance is stored in the `msdb` system database. For more information on backup history, see [Backup History and Header Information (SQL Server)](../backup-restore/backup-history-and-header-information-sql-server.md).
 
 #### Create a transaction log backup
 
@@ -537,4 +537,4 @@ If autogrow is disabled, the database is online, and sufficient space is availab
  [Transaction Log Backups &#40;SQL Server&#41;](../../relational-databases/backup-restore/transaction-log-backups-sql-server.md)   
  [sp_add_log_file_recover_suspect_db &#40;Transact-SQL&#41;](../../relational-databases/system-stored-procedures/sp-add-log-file-recover-suspect-db-transact-sql.md)  
  [MSSQLSERVER_9002](../errors-events/mssqlserver-9002-database-engine-error.md)  
- [How a log file structure can affect database recovery time - Microsoft Tech Community](https://techcommunity.microsoft.com/t5/sql-server-support/how-a-log-file-structure-can-affect-database-recovery-time/ba-p/315780)  
+ [How a log file structure can affect database recovery time - Microsoft Tech Community](https://techcommunity.microsoft.com/t5/sql-server-support/how-a-log-file-structure-can-affect-database-recovery-time/ba-p/315780)
diff --git a/docs/relational-databases/system-functions/freetexttable-transact-sql.md b/docs/relational-databases/system-functions/freetexttable-transact-sql.md
@@ -171,5 +171,5 @@ GO
  [Rowset Functions &#40;Transact-SQL&#41;](../../t-sql/functions/opendatasource-transact-sql.md)   
  [SELECT &#40;Transact-SQL&#41;](../../t-sql/queries/select-transact-sql.md)   
  [WHERE &#40;Transact-SQL&#41;](../../t-sql/queries/where-transact-sql.md)   
- [precompute rank Server Configuration Option](/sql/database-engine/discontinued-database-engine-functionality-in-sql-server)  
- [Compare features in Azure SQL Database and Azure SQL Managed Instance](https://azure.microsoft.com/documentation/articles/sql-database-preview-whats-new/?WT.mc_id=TSQL_GetItTag)
+ [precompute rank Server Configuration Option](../../database-engine/discontinued-database-engine-functionality-in-sql-server.md)  
+ [Compare features in Azure SQL Database and Azure SQL Managed Instance](/azure/azure-sql/database/features-comparison?WT.mc_id=TSQL_GetItTag)
diff --git a/docs/reporting-services/install-windows/install-or-uninstall-the-reporting-services-add-in-for-sharepoint.md b/docs/reporting-services/install-windows/install-or-uninstall-the-reporting-services-add-in-for-sharepoint.md
@@ -272,4 +272,4 @@ Rssharepoint.msi /?
 [Install the first Report Server in SharePoint mode](install-the-first-report-server-in-sharepoint-mode.md)   
 [Reporting Services Report Server &#40;SharePoint Mode&#41;](../../reporting-services/report-server-sharepoint/reporting-services-report-server-sharepoint-mode.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/install-windows/install-reporting-services-sharepoint-mode.md b/docs/reporting-services/install-windows/install-reporting-services-sharepoint-mode.md
@@ -59,4 +59,4 @@ There are two core [!INCLUDE[ssRSnoversion](../../includes/ssrsnoversion-md.md)]
  [Data Alerts Architecture and Workflow](../../reporting-services/reporting-services-data-alerts.md#AlertingWF)   
  [Data Alert Manager for Alerting Administrators](../../reporting-services/data-alert-manager-for-alerting-administrators.md)  
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/reporting-services/report-server-sharepoint/deploy-report-viewer-web-part.md b/docs/reporting-services/report-server-sharepoint/deploy-report-viewer-web-part.md
@@ -170,4 +170,4 @@ The following languages are supported with the web part:
 
 After the Report Viewer web part has been deployed and activated, you can add the web part to a SharePoint page. For more information, see [Add Report Viewer web part to a SharePoint page](add-report-viewer-web-part-to-page.md).
 
-More questions? [Try asking the Reporting Services forum](https://go.microsoft.com/fwlink/?LinkId=620231)
+More questions? [Try asking the Reporting Services forum](/answers/search.html?c=&f=&includeChildren=&q=ssrs+OR+reporting+services&redirect=search%2fsearch&sort=relevance&type=question+OR+idea+OR+kbentry+OR+answer+OR+topic+OR+user)
diff --git a/docs/sql-server/migrate/guides/sql-server-to-sql-server-upgrade-guide.md b/docs/sql-server/migrate/guides/sql-server-to-sql-server-upgrade-guide.md
@@ -18,7 +18,7 @@ For other migration guides, see [Azure Database Migration](/data-migration/).
 ## Prerequisites
 
 Before beginning your migration project, it's important to address the associated prerequisites.
-Learn about the supported versions and considerations for [upgrading SQL Server database.](/sql/database-engine/install-windows/upgrade-sql-server)
+Learn about the supported versions and considerations for [upgrading SQL Server database.](../../../database-engine/install-windows/upgrade-sql-server.md)
 
 To prepare for the migration, download and install the:
 
@@ -197,17 +197,17 @@ After you have the necessary prerequisites in place and have completed the tasks
 
 Review the compatibility issues discovered with DMA tool.
 
-Preserve backup logs, maintenance plans, and other automated tasks, including jobs by creating a backup of the system [database msdb.](/sql/relational-databases/backup-restore/back-up-and-restore-of-system-databases-sql-server)
+Preserve backup logs, maintenance plans, and other automated tasks, including jobs by creating a backup of the system [database msdb.](../../../relational-databases/backup-restore/back-up-and-restore-of-system-databases-sql-server.md)
 
-View [linked servers](/sql/relational-databases/linked-servers/linked-servers-database-engine) by using SQL Server Management Studio. In the Object Explorer, right-click server objects to expand list.
+View [linked servers](../../../relational-databases/linked-servers/linked-servers-database-engine.md) by using SQL Server Management Studio. In the Object Explorer, right-click server objects to expand list.
 
 Additional considerations may be needed 
 based on the complexity of your data and 
 environment.
 
 [Troubleshoot orphaned users.](../../failover-clusters/troubleshoot-orphaned-users-sql-server.md)
 
-[Migrating-triggers.](/sql/relational-databases/linked-servers/linked-servers-database-engine)
+[Migrating-triggers.](../../../relational-databases/linked-servers/linked-servers-database-engine.md)
 
 [Migrate system objects using scripts wizard.](../../../ssms/scripting/generate-and-publish-scripts-wizard.md)
 
