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

MikeRayMSFT · MikeRayMSFT · commit eb661af4ae12 · 2019-08-19T17:08:33.000-07:00
diff --git a/docs/advanced-analytics/toc.yml b/docs/advanced-analytics/toc.yml
@@ -1,7 +1,7 @@
 - name: SQL Server Machine Learning Services Documentation
   href: ../advanced-analytics/index.yml
 
-- name: Welcome to SQL Server >>
+- name: Welcome to SQL Server >
   href: ../sql-server/sql-server-technical-documentation.md?toc=../toc.json
 
 - name: Overview
@@ -167,7 +167,7 @@
       href: ../advanced-analytics/tutorials/demo-data-iris-in-sql.md
     - name: NYC Taxi data set
       href: ../advanced-analytics/tutorials/demo-data-nyctaxi-in-sql.md
-- name: Samples >
+- name: Samples >>
   href: https://github.com/Microsoft/sql-server-samples
 - name: Solutions
   href: ../advanced-analytics/tutorials/data-science-scenarios-and-solution-templates.md
@@ -325,7 +325,7 @@
       href: ../advanced-analytics/r/ref-r-sqlrutils.md
 - name: Resources
   items:
-  - name: Release notes >>
+  - name: Release notes >
     href: ../sql-server/sql-server-2017-release-notes.md?toc=../toc.json
   - name: Troubleshooting
     items:
diff --git a/docs/analytics-platform-system/toc.yml b/docs/analytics-platform-system/toc.yml
@@ -1,7 +1,7 @@
 - name: Overview of APS (PDW)
   href: ../analytics-platform-system/home-analytics-platform-system-aps-pdw.md
 
-- name: Welcome to SQL Server >>
+- name: Welcome to SQL Server >
   href: ../sql-server/sql-server-technical-documentation.md?toc=../toc.json
 
 - name: What's new in APS
diff --git a/docs/big-data-cluster/hdfs-tiering-mount-s3.md b/docs/big-data-cluster/hdfs-tiering-mount-s3.md
@@ -5,7 +5,7 @@ description: This article explains how to configure HDFS tiering to mount an ext
 author: nelgson
 ms.author: negust
 ms.reviewer: mikeray
-ms.date: 07/31/2019
+ms.date: 08/15/2019
 ms.topic: conceptual
 ms.prod: sql
 ms.technology: big-data-cluster
@@ -56,10 +56,10 @@ Now that you have prepared a credential file with access keys, you can start mou
    
 1. Set environment variable MOUNT_CREDENTIALS following the instructions above
 
-1. Mount the remote HDFS storage in S3 using **azdata bdc storage-pool mount create**. Replace the placeholder values before running the following command:
+1. Mount the remote HDFS storage in Azure using **azdata bdc hdfs mount create**. Replace the placeholder values before running the following command:
 
    ```bash
-   azdata bdc storage-pool mount create --remote-uri s3a://<S3 bucket name> --mount-path /mounts/<mount-name>
+   azdata bdc hdfs mount create --remote-uri s3a://<S3 bucket name> --mount-path /mounts/<mount-name>
    ```
 
    > [!NOTE]
@@ -91,7 +91,7 @@ azdata bdc hdfs mount refresh --mount-path <mount-path-in-hdfs>
 
 ## <a id="delete"></a> Delete the mount
 
-To delete the mount, use the **azdata bdc storage-pool mount delete** command, and specify the mount path in HDFS:
+To delete the mount, use the **azdata bdc hdfs mount delete** command, and specify the mount path in HDFS:
 
 ```bash
 azdata bdc hdfs mount delete --mount-path <mount-path-in-hdfs>
diff --git a/docs/big-data-cluster/tutorial-load-sample-data.md b/docs/big-data-cluster/tutorial-load-sample-data.md
@@ -28,7 +28,7 @@ This tutorial explains how to use a script to load sample data into a [!INCLUDE[
    - **kubectl**
    - **sqlcmd**
    - **curl**
-
+ 
 ## <a id="sampledata"></a> Load sample data
 
 The following steps use a bootstrap script to download a SQL Server database backup and load the data into your big data cluster. For ease of use, these steps have been broken out into [Windows](#windows) and [Linux](#linux) sections.
@@ -125,4 +125,4 @@ Data ingestion:
 
 Notebooks:
 
-- [Tutorial: Run a sample notebook on a SQL Server 2019 big data cluster](tutorial-notebook-spark.md)
+- [Tutorial: Run a sample notebook on a SQL Server 2019 big data cluster](tutorial-notebook-spark.md)
diff --git a/docs/connect/toc.yml b/docs/connect/toc.yml
@@ -1,7 +1,7 @@
 - name: Programming to interact with SQL Server
   href: ../connect/homepage-sql-connection-programming.md
 
-- name: Welcome to SQL Server >>
+- name: Welcome to SQL Server >
   href: ../sql-server/sql-server-technical-documentation.md?toc=../toc.json
 
 - name: SQL Server Drivers
diff --git a/docs/integration-services/control-flow/foreach-loop-container.md b/docs/integration-services/control-flow/foreach-loop-container.md
@@ -46,7 +46,7 @@ ms.author: janinez
   
 -   Foreach ADO.NET Schema Rowset enumerator to enumerate the schema information about a data source. For example, you can enumerate and get a list of the tables in the [!INCLUDE[ssSampleDBnormal](../../includes/sssampledbnormal-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] database.  
   
--   Foreach File enumerator to enumerate files in a folder. The enumerator can traverse subfolders. For example, you can read all the files that have the *.log file name extension in the Windows folder and its subfolders.  
+-   Foreach File enumerator to enumerate files in a folder. The enumerator can traverse subfolders. For example, you can read all the files that have the *.log file name extension in the Windows folder and its subfolders. Note that the order in which the files are retrieved cannot be specified.  
   
 -   Foreach From Variable enumerator to enumerate the enumerable object that a specified variable contains. The enumerable object can be an array, an ADO.NET **DataTable**, an [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] enumerator, and so on. For example, you can enumerate the values of an array that contains the name of servers.  
   
diff --git a/docs/integration-services/install-windows/install-integration-services.md b/docs/integration-services/install-windows/install-integration-services.md
@@ -38,9 +38,9 @@ ms.author: janinez
 -   [Security Considerations for a SQL Server Installation](../../sql-server/install/security-considerations-for-a-sql-server-installation.md)    
     
 ## Install standalone or side by side    
-You can install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)][!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] in the following configurations:    
+You can install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] in the following configurations:    
     
--   You can install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)][!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] on a computer that has no previous instances of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].    
+-   You can install [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)] on a computer that has no previous instances of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].    
     
 -   You can install [!INCLUDE[ssISCurrent](../../includes/ssiscurrent-md.md)] side by side with an existing instance of [!INCLUDE[ssISnoversion](../../includes/ssisnoversion-md.md)].    
     
@@ -116,6 +116,6 @@ For a complete installation of [!INCLUDE[ssISnoversion](../../includes/ssisnover
 
 -   **Optional additional components**. You can optionally download additional third-party components from the SQL Server Feature Package.
 
-    -   MicrosoftÂ® Connector for SAP BW for Microsoft SQL ServerÂ®. To get these components, see [MicrosoftÂ® SQL ServerÂ® 2017 Feature Pack](https://www.microsoft.com/download/details.aspx?id=55992).
+    -   Microsoft® Connector for SAP BW for Microsoft SQL Server®. To get these components, see [Microsoft® SQL Server® 2017 Feature Pack](https://www.microsoft.com/download/details.aspx?id=55992).
 
     -   Microsoft Connector Version 5.0 for Oracle by Attunity and Microsoft Connector Version 5.0 for Teradata by Attunity. To get these components, see [Microsoft Connectors v5.0 for Oracle and Teradata](https://www.microsoft.com/download/details.aspx?id=55179).
diff --git a/docs/integration-services/toc.yml b/docs/integration-services/toc.yml
@@ -1,7 +1,7 @@
 - name: SQL Server Integration Services (SSIS)
   href: ../integration-services/sql-server-integration-services.md
 
-- name: Welcome to SQL Server >>
+- name: Welcome to SQL Server >
   href: ../sql-server/sql-server-technical-documentation.md?toc=../toc.json
 
 - name: Overview
@@ -1803,11 +1803,11 @@
         href: ../integration-services/lesson-3-3-testing-the-deployed-packages.md
 - name: Resources
   items:
-  - name: Get help in the SSIS forum >
+  - name: SSIS forum >>
     href: https://social.msdn.microsoft.com/Forums/en-US/home
-  - name: Get help on Stack Overflow >
+  - name: Stack Overflow >>
     href: https://stackoverflow.com/questions/tagged/ssis
-  - name: Follow the SSIS team blog >
+  - name: SSIS blog >>
     href: https://blogs.msdn.microsoft.com/ssis/
-  - name: Report issues & request features >
+  - name: Product feedback >>
     href: https://feedback.azure.com/forums/908035-sql-server
diff --git a/docs/reporting-services/toc.yml b/docs/reporting-services/toc.yml
@@ -1,7 +1,7 @@
 - name: What is SQL Server Reporting Services (SSRS)?
   href: ../reporting-services/create-deploy-and-manage-mobile-and-paginated-reports.md
 
-- name: Welcome to SQL Server >>
+- name: Welcome to SQL Server >
   href: ../sql-server/sql-server-technical-documentation.md?toc=../toc.json
 
 - name: Overview
@@ -1678,7 +1678,7 @@
   items:
   - name: REST API
     href: ../reporting-services/developer/rest-api.md
-  - name: REST API samples >
+  - name: REST API samples >>
     href: https://github.com/Microsoft/Reporting-Services
   - name: Integrating Reporting Services into Applications
     href: ../reporting-services/application-integration/integrating-reporting-services-into-applications.md
diff --git a/docs/sql-server/media/sql-server-docs-navigation-guide/double-carrots-in-sql-docs-toc.png b/docs/sql-server/media/sql-server-docs-navigation-guide/double-carrots-in-sql-docs-toc.png
diff --git a/docs/sql-server/media/sql-server-docs-navigation-guide/download-pdf.png b/docs/sql-server/media/sql-server-docs-navigation-guide/download-pdf.png
diff --git a/docs/sql-server/media/sql-server-docs-navigation-guide/navigate-back-to-sql-toc.png b/docs/sql-server/media/sql-server-docs-navigation-guide/navigate-back-to-sql-toc.png
diff --git a/docs/sql-server/media/sql-server-docs-navigation-guide/single-carrots-in-sql-docs-toc.png b/docs/sql-server/media/sql-server-docs-navigation-guide/single-carrots-in-sql-docs-toc.png
diff --git a/docs/sql-server/sql-docs-navigation-guide.md b/docs/sql-server/sql-docs-navigation-guide.md
@@ -33,16 +33,15 @@ If you'd like to create a PDF, select the **Download PDF** link found at the bot
 
 ## TOC navigation hints
 
-Entries in the table of contents (TOC) that have a `>` at the end of the entry indicate that you will be taken away from docs.microsoft.com. 
+Entries in the table of contents (TOC) that have a `>` at the end of the entry indicate that you will be taken to technical documentation with a different table of contents. 
 
 ![Single carrots in toc](media/sql-server-docs-navigation-guide/single-carrots-in-sql-docs-toc.png)
 
-
-Entries in the TOC that have a `>>` indicate that you will be taken to technical documentation with a different table of contents. 
+Entries in the TOC that have a `>>` indicate that you will be taken away from docs.microsoft.com. 
 
 ![TOC navigation markers](media/sql-server-docs-navigation-guide/double-carrots-in-sql-docs-toc.png)
 
-If you navigate to one of these pages, you can come back to the main SQL Server technical page, and table of contents, by selecting the "Welcome to SQL Server >>" entry found at the top of each of these table of contents. 
+If you navigate to one of these pages, you can come back to the main SQL Server technical page, and table of contents, by selecting the "Welcome to SQL Server >" entry found at the top of each of these table of contents. 
 
 ![Navigate back to SQL toc](media/sql-server-docs-navigation-guide/navigate-back-to-sql-toc.png)
 
@@ -58,7 +57,7 @@ You can use the [version filter](versioning-system-monikers-ui-sql-server.md) to
 
 ![SQL Docs version filter](media/sql-server-docs-navigation-guide/sql-docs-version-filter.gif)
 
-Selecting **All SQL** \> **Hide nothing** ensures that all content is visible, and that nothing is hidden by the version filter. The [**Hide nothing** option is not recommended for routine use](versioning-system-monikers-ui-sql-server.md#anchor-allsql-hidenothing).
+Selecting **All SQL** \> **Hide nothing** ensures that all content is visible, and that nothing is hidden by the version filter. The **Hide nothing** option may reveal content relevant to several different versions of SQL Server within the same article, which might be contradictory, unclear, or confusing. As such the [**Hide nothing** option is not recommended for routine use](versioning-system-monikers-ui-sql-server.md#anchor-allsql-hidenothing). 
 
 ## Breadcrumbs
 
diff --git a/docs/toc.yml b/docs/toc.yml
@@ -1984,7 +1984,7 @@
         href: relational-databases/xml/use-the-value-and-nodes-methods-with-openxml.md
 - name: Development
   items:
-  - name: Code a client program >>
+  - name: Code a client program > 
     displayName: ADO, ADO.NET, connect, C#, C++, Java, Node.js, ODBC, OLE DB, PHP, Python, Ruby
     href: connect/index.md
   - name: Data tier applications
@@ -4502,7 +4502,7 @@
         href: database-engine/configure-windows/server-properties-advanced-page.md
 - name: Migrate & load data
   items:
-  - name: SQL Server Integration Services (SSIS) >>
+  - name: SQL Server Integration Services (SSIS) > 
     href: integration-services/index.md
   - name: Bulk Copy Utility (bcp)
     href: tools/bcp-utility.md
@@ -5694,13 +5694,13 @@
           href: sql-server/stretch-database/extended-events-for-stretch-database.md
     - name: Resources
       items:
-      - name: Pricing >
+      - name: Pricing >>
         href: https://azure.microsoft.com/pricing/details/sql-server-stretch-database/
-      - name: Blog >
+      - name: Blog >>
         href: https://blogs.technet.microsoft.com/dataplatforminsider/tag/stretch-database/
-      - name: Service updates >
+      - name: Service updates >>
         href: https://azure.microsoft.com/updates/?product=sql-server-stretch-database
-      - name: Videos >
+      - name: Videos >>
         href: https://azure.microsoft.com/documentation/videos/index/?services=sql-server-stretch-database
   - name: Database Experimentation Wizard
     href: dea/database-experimentation-assistant-overview.md
@@ -7424,15 +7424,15 @@
         href: relational-databases/polybase/polybase-type-mapping.md
     - name: Resources
       items:
-      - name: DBA Stack Exchange >
+      - name: DBA Stack Exchange >>
         href: https://dba.stackexchange.com/questions/tagged/sql-server
-      - name: Stack Overflow >
+      - name: Stack Overflow >>
         href: https://stackoverflow.com/questions/tagged/sql-server
-      - name: MSDN Forums >
+      - name: MSDN Forums >>
         href: https://social.msdn.microsoft.com/Forums/home?category=sqlserver
-      - name: Submit feedback >
+      - name: Submit feedback >>
         href: https://feedback.azure.com/forums/908035-sql-server
-      - name: Reddit >
+      - name: Reddit >>
         href: https://www.reddit.com/r/SQLServer
   - name: Linked servers
     href: relational-databases/linked-servers/linked-servers-database-engine.md
@@ -7530,14 +7530,14 @@
       href: relational-databases/synonyms/create-synonyms.md
 - name: Reporting & Analytics
   items:
-  - name: Advanced Analytics & Machine learning >>
+  - name: Advanced Analytics & Machine learning > 
     href: advanced-analytics/
-  - name: Analytics Platform System >>
+  - name: Analytics Platform System > 
     displayName: APS, PDW, Parallel Data Warehouse
     href: analytics-platform-system/index.md
-  - name: SQL Server Analysis Services (SSAS) >>
+  - name: SQL Server Analysis Services (SSAS) > 
     href: https://docs.microsoft.com/en-us/analysis-services/analysis-services-overview
-  - name: SQL Server Reporting Services (SSRS) >>
+  - name: SQL Server Reporting Services (SSRS) > 
     href: reporting-services/index.md
   - name: Master Data Services
     displayName: MDS
@@ -8284,11 +8284,11 @@
       items:
       - name: FAQ
         href: azure-data-studio/faq.md
-      - name: Azure Data Studio GitHub repo >
+      - name: Azure Data Studio GitHub repo >>
         href: https://www.github.com/Microsoft/azuredatastudio
-      - name: SQL Server Blog >
+      - name: SQL Server Blog >>
         href: https://blogs.technet.microsoft.com/dataplatforminsider/
-      - name: Report issues & make suggestions >
+      - name: Report issues & make suggestions >>
         href: https://github.com/microsoft/azuredatastudio/issues
   - name: Command prompt utilities
     href: tools/command-prompt-utility-reference-database-engine.md
@@ -10018,7 +10018,7 @@
         href: ssms/user-assistance-in-sql-server-management-studio.md
       - name: Anonymous Usage Data
         href: ssms/sql-server-management-studio-telemetry-ssms.md
-      - name: Feedback > 
+      - name: Feedback >> 
         href: https://aka.ms/sqlfeedback
   - name: SqlPackage.exe
     items:
@@ -10429,17 +10429,17 @@
     items:
     - name: Troubleshoot
       href: linux/sql-server-linux-troubleshooting-guide.md
-    - name: How to License >
+    - name: How to License >>
       href: https://www.microsoft.com/sql-server/sql-server-2017-pricing
-    - name: DBA Stack Exchange >
+    - name: DBA Stack Exchange >>
       href: https://dba.stackexchange.com/questions/tagged/sql-server
-    - name: Stack Overflow >
+    - name: Stack Overflow >>
       href: https://stackoverflow.com/questions/tagged/sql-server  # Note: this S.O. https address occurs multiple times in this toc/toc.yml file. Is okay if beneficial.
-    - name: MSDN Forums >
+    - name: MSDN Forums >>
       href: https://social.msdn.microsoft.com/Forums/home
-    - name: Submit feedback >
+    - name: Submit feedback >>
       href: https://feedback.azure.com/forums/908035-sql-server
-    - name: Reddit >
+    - name: Reddit >>
       href: https://www.reddit.com/r/SQLServer  # Note: this Reddit https address occurs multiple times in this toc/toc.yml file. Is okay if beneficial.
 - name: SQL on Azure
   items:
@@ -10453,39 +10453,39 @@
   items:
   - name: Learn
     items:
-    - name: Microsoft Virtual Academy >
+    - name: Microsoft Virtual Academy >>
       href: https://mva.microsoft.com/product-training/sql-server  # TODO: MVA website is being retired in 2019.  (Removed trailing '#!lang=1033'.)
-    - name: SQL on Channel 9 >
+    - name: SQL on Channel 9 >>
       href: https://channel9.msdn.com/Search
   - name: Help
     items:
     - name: Get help
       href: sql-server/sql-server-get-help.md
     - name: Versioning of SQL docs
       href: sql-server/versioning-system-monikers-ui-sql-server.md
-    - name: DBA Stack Exchange >
+    - name: DBA Stack Exchange >>
       href: https://dba.stackexchange.com/questions/tagged/sql-server
-    - name: Stack Overflow >
+    - name: Stack Overflow >>
       href: https://stackoverflow.com/questions/tagged/sql-server
-    - name: MSDN Forums >
+    - name: MSDN Forums >>
       href: https://social.msdn.microsoft.com/Forums/home
-    - name: Reddit >
+    - name: Reddit >>
       href: https://www.reddit.com/r/SQLServer
   - name: Blogs  # TODO: Blog websites on MSDN & TechNet are being retired in 2019.
     items:
-    - name: SQL Server >
+    - name: SQL Server >>
       href: https://blogs.technet.microsoft.com/dataplatforminsider/
-    - name: Database Engine >
+    - name: Database Engine >>
       href: https://blogs.msdn.microsoft.com/sqlserverstorageengine/
-    - name: Security >
+    - name: Security >>
       href: https://blogs.msdn.microsoft.com/sqlsecurity/
-    - name: Data Tools >
+    - name: Data Tools >>
       href: https://blogs.msdn.microsoft.com/ssdt/
   - name: Feedback
     items: 
-    - name: SQL Docs > 
+    - name: SQL Docs >> 
       href: https://aka.ms/sqldocsfeedback
-    - name: SQL Server > 
+    - name: SQL Server >> 
       href: https://feedback.azure.com/forums/908035-sql-server
     - name: Edit SQL Documentation!
       href: sql-server/sql-server-docs-contribute.md
@@ -10510,7 +10510,7 @@
     items:
     - name: Samples Overview
       href: samples/sql-samples-where-are.md
-    - name: All Github Samples >
+    - name: All Github Samples >>
       href: https://github.com/Microsoft/sql-server-samples/tree/master/samples
     - name: AdventureWorks
       items:
