8000 Linkfix: SQL (2021-06) · debuglevel/sql-docs@bcdb73a · GitHub
[go: up one dir, main page]
Skip to content

Commit bcdb73a

Browse files
v-kentsv-kents
committed
Linkfix: SQL (2021-06)
1 parent 5d85533 commit bcdb73a

26 files changed

+48
-53
lines changed

‎docs/big-data-cluster/big-data-cluster-faq.yml‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -139,13 +139,13 @@ sections:
139139
You can use EXECUTE AT to query DMVs like sys.dm_db_partition_stats to get the data in each local table.
140140
- question: Is curl the only option to upload files to HDFS?
141141
answer: |
142-
No, you can use [azdata bdc hdfs cp](/sql/azdata/reference/reference-azdata-bdc-hdfs#azdata-bdc-hdfs-cp). If you provide the root directory the command will recursively copy the whole tree. You can copy in/out using this command just by changing what is the source/target paths.
142+
No, you can use [azdata bdc hdfs cp](../azdata/reference/reference-azdata-bdc-hdfs.md#azdata-bdc-hdfs-cp). If you provide the root directory the command will recursively copy the whole tree. You can copy in/out using this command just by changing what is the source/target paths.
143143
- question: How can I load data into the data pool?
144144
answer: |
145145
You can use MSSQL Spark connector library to help with SQL and data pool ingestion. For a guided walk-through, see [Tutorial: Ingest data into a SQL Server data pool with Spark jobs](tutorial-data-pool-ingest-spark.md#start-a-spark-streaming-job).
146146
- question: If I have a lot of data on a (Windows) network path, which contains lots of folders/sub-folders and text files, how do I upload them to HDFS on Big data cluster?
147147
answer: |
148-
Give [azdata bdc hdfs cp](/sql/azdata/reference/reference-azdata-bdc-hdfs#azdata-bdc-hdfs-cp) a try. If you provide the root directory the command will recursively copy the whole tree. You can copy in/out using this command just by changing what is the source/target paths.
148+
Give [azdata bdc hdfs cp](../azdata/reference/reference-azdata-bdc-hdfs.md#azdata-bdc-hdfs-cp) a try. If you provide the root directory the command will recursively copy the whole tree. You can copy in/out using this command just by changing what is the source/target paths.
149149
- question: Is it possible to increase the size of the storage pool on a deployed cluster?
150150
answer: |
151151
There is no azdata interface to perform this operation at this time. You have the option to resize desired PVCs manually. Resizing is a complex operation, see [Persistent Volumes in Kubernetes Documentation](https://kubernetes.io/docs/concepts/storage/persistent-volumes/).
@@ -191,7 +191,7 @@ sections:
191191
You can add packages at job submission using the steps in the [sample notebook for installing packages in Spark](https://github.com/microsoft/sql-server-samples/blob/master/samples/features/sql-big-data-cluster/spark/config-install/installpackage_Spark.ipynb).
192192
- question: Do I need to use SQL Server 2019 to use R and Python for SQL Server Big Data Clusters?
193193
answer: |
194-
Machine Learning (ML) Services (R and Python) is available beginning in SQL Server 2017. ML Services is available in SQL Server Big Data Clusters as well. For more information, see [What is SQL Server Machine Learning?](/sql/machine-learning/sql-server-machine-learning-services).
194+
Machine Learning (ML) Services (R and Python) is available beginning in SQL Server 2017. ML Services is available in SQL Server Big Data Clusters as well. For more information, see [What is SQL Server Machine Learning?](../machine-learning/sql-server-machine-learning-services.md).
195195
- name: Licensing
196196
questions:
197197
- question: How do SQL Server licenses work for SQL Server Big Data Clusters?

‎docs/big-data-cluster/release-notes-big-data-cluster.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -246,7 +246,7 @@ SQL Server 2019 General Distribution Release 1 (GDR1) - introduces general avail
246246
> `Additional error <2>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection, SqlState: 08001, NativeError: 10054 Additional error <3>: ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]`
247247
> `Invalid connection string attribute, SqlState: 01S00, NativeError: 0 .`
248248
249-
- **Solution**: Due to the heightened security requirements of Ubuntu 20.04 over the previous base image version, the remote connection is not allowed for a certificate using the SHA1 algorithm. The default self-signed certificate of SQL Server releases 2005-2016 used the SHA1 algorithm. Refer to this blog post for more information on [changes made to self-signed certificates in SQL Server 2017](https://techcommunity.microsoft.com/t5/sql-server-support/changes-to-hashing-algorithm-for-self-signed-certificate-in-sql/ba-p/319026). In the remote SQL Server instance, use a certificate that is created with an algorithm that uses at least 112 bits of security (for example, SHA256). For production environments, it is recommended to obtain a trusted certificate from a Certificate Authority. For testing purposes, self-signed certificate can also be used. To create a self-signed certificate, see the [Powershell Cmdlet New-SelfSignedCertificate](/powershell/module/pkiclient/new-selfsignedcertificate) or [certreq command](/windows-server/administration/windows-commands/certreq_1). For instructions to install a new certificate it on the remote SQL Server instance, see [Enable encrypted connections to the Database Engine](/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine.md)
249+
- **Solution**: Due to the heightened security requirements of Ubuntu 20.04 over the previous base image version, the remote connection is not allowed for a certificate using the SHA1 algorithm. The default self-signed certificate of SQL Server releases 2005-2016 used the SHA1 algorithm. Refer to this blog post for more information on [changes made to self-signed certificates in SQL Server 2017](https://techcommunity.microsoft.com/t5/sql-server-support/changes-to-hashing-algorithm-for-self-signed-certificate-in-sql/ba-p/319026). In the remote SQL Server instance, use a certificate that is created with an algorithm that uses at least 112 bits of security (for example, SHA256). For production environments, it is recommended to obtain a trusted certificate from a Certificate Authority. For testing purposes, self-signed certificate can also be used. To create a self-signed certificate, see the [Powershell Cmdlet New-SelfSignedCertificate](/powershell/module/pkiclient/new-selfsignedcertificate) or [certreq command](/windows-server/administration/windows-commands/certreq_1). For instructions to install a new certificate it on the remote SQL Server instance, see [Enable encrypted connections to the Database Engine](../database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine.md)
250250

251251

252252
### Partial loss of logs collected in ElasticSearch upon rollback
@@ -476,4 +476,4 @@ Upgrading using different repositories for current and target builds is not supp
476476
477477
## Next steps
478478
479-
For more information about [!INCLUDE[big-data-clusters-2019](../includes/ssbigdataclusters-ss-nover.md)], see [What are [!INCLUDE[big-data-clusters-2019](../includes/ssbigdataclusters-ver15.md)]?](big-data-cluster-overview.md)
479+
For more information about [!INCLUDE[big-data-clusters-2019](../includes/ssbigdataclusters-ss-nover.md)], see [What are [!INCLUDE[big-data-clusters-2019](../includes/ssbigdataclusters-ver15.md)]?](big-data-cluster-overview.md)

‎docs/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -30,7 +30,7 @@ Version 9.2 is the latest general availability (GA) version. It supports Java 8,
3030
When you download the driver, there are multiple JAR files. The name of the JAR file indicates the version of Java that it supports.
3131

3232
> [!Note]
33-
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](https://aka.ms/downloadmssqljdbcenglish). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
33+
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
3434
3535
## Available languages
3636

‎docs/connect/odbc/download-odbc-driver-for-sql-server.md‎

Lines changed: 1 addition & 1 deletion
< 83C3 td data-grid-cell-id="diff-d85334a13dcfc88dd8766df8d65d6d3d5984b6eda0093ea46de3134668e8b759-34-34-1" data-selected="false" role="gridcell" style="background-color:var(--bgColor-default);text-align:center" tabindex="-1" valign="top" class="focusable-grid-cell diff-line-number position-relative diff-line-number-neutral left-side">34
Original file line numberDiff line numberDiff line change
@@ -33,7 +33,7 @@ Version 17.7.2 is the latest general availability (GA) version. If you have a pr
3333
- Released: March 10, 2021
34

3535
> [!Note]
36-
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](https://aka.ms/downloadmsodbcsqlenglish). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
36+
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
3737
3838
## Available languages
3939

‎docs/connect/oledb/download-oledb-driver-for-sql-server.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ Microsoft OLE DB Driver 18.5 for SQL Server is the latest general availability (
2929
- Released: December 1, 2020
3030

3131
> [!Note]
32-
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](https://aka.ms/downloadmsoledbsqlusenglish). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
32+
> If you are accessing this page from a non-English language version, and want to see the most up-to-date content, please visit the [US-English version of the site](). You can download different languages from the US-English version site by selecting [available languages](#available-languages).
3333
3434
## Available languages
3535

‎docs/database-engine/configure-windows/configure-windows-service-accounts-and-permissions.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -25,8 +25,8 @@ Most services and their properties can be configured by using SQL Server Configu
2525
| SQL Server 2019 | C:\Windows\SysWOW64\SQLServerManager15.msc |
2626
| SQL Server 2017 | C:\Windows\SysWOW64\SQLServerManager14.msc |
2727
| SQL Server 2016 | C:\Windows\SysWOW64\SQLServerManager13.msc |
28-
| [SQL Server 2014](https://docs.microsoft.com/previous-versions/sql/2014/) | C:\Windows\SysWOW64\SQLServerManager12.msc |
29-
| [SQL Server 2012](https://docs.microsoft.com/previous-versions/sql/sql-server-2012/hh231622(v=sql.110)) | C:\Windows\SysWOW64\SQLServerManager11.msc |
28+
| [SQL Server 2014](/previous-versions/sql/2014/) | C:\Windows\SysWOW64\SQLServerManager12.msc |
29+
| [SQL Server 2012](/previous-versions/sql/sql-server-2012/hh231622(v=sql.110)) | C:\Windows\SysWOW64\SQLServerManager11.msc |
3030

3131
## <a name="Service_Details"></a> Services Installed by SQL Server
3232

@@ -590,4 +590,4 @@ The following table shows service names that are displayed by localized versions
590590

591591
- [File Locations for Default and Named Instances of SQL Server](../../sql-server/install/file-locations-for-default-and-named-instances-of-sql-server.md)
592592

593-
- [Install Master Data Services](../../master-data-services/install-windows/install-master-data-services.md)
593+
- [Install Master Data Services](../../master-data-services/install-windows/install-master-data-services.md)

‎docs/database-engine/configure-windows/sql-server-service-broker.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -100,8 +100,8 @@ FROM ExpenseQueue;
100100

101101
Cross-instance service broker message exchange is supported only between Azure SQL Managed Instances:
102102

103-
- `CREATE ROUTE`: You can't use CREATE ROUTE with ADDRESS other than LOCAL or DNS name of another SQL Managed Instance. Port specified must be 4022. See [CREATE ROUTE](/sql/t-sql/statements/create-route-transact-sql).
104-
- `ALTER ROUTE`: You can't use ALTER ROUTE with ADDRESS other than LOCAL or DNS name of another SQL Managed Instance. Port specified must be 4022. See See [ALTER ROUTE](/sql/t-sql/statements/alter-route-transact-sql).
103+
- `CREATE ROUTE`: You can't use CREATE ROUTE with ADDRESS other than LOCAL or DNS name of another SQL Managed Instance. Port specified must be 4022. See [CREATE ROUTE](../../t-sql/statements/create-route-transact-sql.md).
104+
- `ALTER ROUTE`: You can't use ALTER ROUTE with ADDRESS other than LOCAL or DNS name of another SQL Managed Instance. Port specified must be 4022. See See [ALTER ROUTE](../../t-sql/statements/alter-route-transact-sql.md).
105105

106106
Transport security is supported, dialog security is not:
107107

‎docs/machine-learning/troubleshooting/common-issues-external-script-execution.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -152,7 +152,7 @@ This error can mean one of several things:
152152

153153
- Launchpad might have insufficient external users to run the external query. For example, if you are running more than 20 external queries concurrently, and there are only 20 default users, one or more queries might fail.
154154

155-
- Insufficient memory is available to process the R task. This error happens most often in a default environment, where SQL Server might be using up to 70 percent of the computer's resources. For information about how to modify the server configuration to support greater use of resources by R, see [Operationalizing your R code](/sql/machine-learning/tutorials/python-ski-rental-linear-regression-deploy-model).
155+
- Insufficient memory is available to process the R task. This error happens most often in a default environment, where SQL Server might be using up to 70 percent of the computer's resources. For information about how to modify the server configuration to support greater use of resources by R, see [Operationalizing your R code](../tutorials/python-ski-rental-linear-regression-deploy-model.md).
156156

157157
## "Can't find package"
158158

‎docs/machine-learning/tutorials/walkthrough-deploy-and-use-the-model.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -222,7 +222,7 @@ Now that you have learned how to work with [!INCLUDE[ssNoVersion](../../includes
222222

223223
You might also want to explore these additional samples and resources:
224224

225-
+ [Data science scenarios and solution templates](/sql/machine-learning/tutorials/python-tutorials)
225+
+ [Data science scenarios and solution templates](./python-tutorials.md)
226226
+ [In-database advanced analytics](r-taxi-classification-introduction.md)
227227
+ [Machine Learning Server How-to guides](/machine-learning-server/r/how-to-introduction)
228228
+ [Machine Learning Server Additional Resources](/machine-learning-server/resources-more)

‎docs/relational-databases/backup-restore/sql-server-vss-writer-logging.md‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -101,7 +101,7 @@ Previously, only active profiler tracing would allow the DBA to detect such an e
101101
In order of appearance, we can see the following information is logged:
102102
- An explicit mention of the `OnIdentify` VSS event.
103103
- A list of all active (running) [!INCLUDE[ssSQL11](../../includes/ssnoversion-md.md)] instances, along with their instance name, major version, and Edition.
104-
- The indication we didn’t attempt to list “User Instances” – a specific [!INCLUDE[ssSQL11](../../includes/ssnoversion-md.md)] feature also known as [LocalDB](/sql/database-engine/configure-windows/sql-server-express-localdb) and typically not involved on enterprise database servers.
104+
- The indication we didn’t attempt to list “User Instances” – a specific [!INCLUDE[ssSQL11](../../includes/ssnoversion-md.md)] feature also known as [LocalDB](../../database-engine/configure-windows/sql-server-express-localdb.md) and typically not involved on enterprise database servers.
105105

106106
### Successful Component-mode VSS backup
107107

@@ -289,4 +289,3 @@ The INI file lists the following level: DEFAULT | MINIMAL | VERBOSE.
289289
[RESTORE &#40;Transact-SQL&#41;](../../t-sql/statements/restore-statements-transact-sql.md)
290290
[Back Up and Restore of SQL Server Databases](../../relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases.md)
291291
[SQL Server Transaction Log Architecture and Management Guide](../../relational-databases/sql-server-transaction-log-architecture-and-management-guide.md)
292-

0 commit comments

Comments
 (0)
0