Merge pull request MicrosoftDocs#9839 from MicrosoftDocs/master

huypub · web-flow · commit acb5de9f4932 · 2019-04-12T15:24:18.000-07:00
4/12 PM Publish
diff --git a/docs/linux/sql-server-linux-create-availability-group.md b/docs/linux/sql-server-linux-create-availability-group.md
@@ -66,7 +66,7 @@ sudo systemctl restart mssql-server
 
 An availability group uses TCP endpoints for communication. Under Linux, endpoints for an AG are only supported if certificates are used for authentication. This means that the certificate from one instance must be restored on all other instances that will be replicas participating in the same AG. The certificate process is required even for a configuration-only replica. 
 
-Creating endpoints and restoring certificates can only be done via Transact-SQL. You can use non- [!INCLUDE[ssnoversion-md](../includes/ssnoversion-md.md)]-generated certificates as well. You will also need a process to manage and replace any certificates that expire.
+Creating endpoints and restoring certificates can only be done via Transact-SQL. You can use non- [!INCLUDE[ssnoversion-md](../includes/ssnoversion-md.md)]-generated certificates as well. You will also need a process to manage and replace any certificates that expire.
 
 > [!IMPORTANT]
 > If you plan to use the [!INCLUDE[ssmanstudiofull-md](../includes/ssmanstudiofull-md.md)] wizard to create the AG, you still need to create and restore the certificates by using Transact-SQL on Linux.
@@ -238,7 +238,7 @@ This example will create certificates for a three-node configuration. The instan
     GO
     ```
     
-10.  Restore LinAGN1_Cert and LinAGN3_Cert on LinAGN2. 
+10. Restore LinAGN1_Cert and LinAGN3_Cert on LinAGN2.
     
     ```SQL
     CREATE CERTIFICATE LinAGN1_Cert
@@ -252,8 +252,9 @@ This example will create certificates for a three-node configuration. The instan
     FROM FILE = '/var/opt/mssql/data/LinAGN3_Cert.cer';
     
     GO
+    ```
     
-11.  Grant the logins associated with LinAG1 and LinAGN3 permission to connect to the endpoint on LinAGN2.
+11. Grant the logins associated with LinAG1 and LinAGN3 permission to connect to the endpoint on LinAGN2.
     
     ```SQL
     GRANT CONNECT ON ENDPOINT::AGEP TO LinAGN1_Login;
@@ -265,7 +266,7 @@ This example will create certificates for a three-node configuration. The instan
     GO
     ```
     
-12.  Create the instance-level logins and users associated with LinAGN1 and LinAGN2 on LinAGN3.
+12. Create the instance-level logins and users associated with LinAGN1 and LinAGN2 on LinAGN3.
     
     ```SQL
     CREATE LOGIN LinAGN1_Login WITH PASSWORD = '<StrongPassword>';
@@ -279,7 +280,7 @@ This example will create certificates for a three-node configuration. The instan
     GO
     ```
     
-13.  Restore LinAGN1_Cert and LinAGN2_Cert on LinAGN3. 
+13. Restore LinAGN1_Cert and LinAGN2_Cert on LinAGN3. 
     
     ```SQL
     CREATE CERTIFICATE LinAGN1_Cert
@@ -293,8 +294,9 @@ This example will create certificates for a three-node configuration. The instan
     FROM FILE = '/var/opt/mssql/data/LinAGN2_Cert.cer';
     
     GO
+    ```
     
-14.  Grant the logins associated with LinAG1 and LinAGN2 permission to connect to the endpoint on LinAGN3.
+14. Grant the logins associated with LinAG1 and LinAGN2 permission to connect to the endpoint on LinAGN3.
     
     ```SQL
     GRANT CONNECT ON ENDPOINT::AGEP TO LinAGN1_Login;
@@ -411,7 +413,7 @@ This example shows how to create a two-replica AG that uses a configuration-only
     GO
     ```
     
-3.  In a query window connected to the configuration only replica, join it to the AG.
+3. In a query window connected to the configuration only replica, join it to the AG.
     
    ```SQL
     ALTER AVAILABILITY GROUP [<AGName>] JOIN WITH (CLUSTER_TYPE = EXTERNAL);
@@ -534,7 +536,7 @@ A Pacemaker high availability cluster underlying [!INCLUDE[ssnoversion-md](../in
 1.  In a query window connected to the first replica, execute the following:
 
     ```SQL
-    CREATE LOGIN PMLogin WITH PASSWORD '<StrongPassword>';
+    CREATE LOGIN PMLogin WITH PASSWORD ='<StrongPassword>';
     
     GO
     
diff --git a/docs/relational-databases/performance/best-practice-with-the-query-store.md b/docs/relational-databases/performance/best-practice-with-the-query-store.md
@@ -13,7 +13,7 @@ ms.assetid: 5b13b5ac-1e4c-45e7-bda7-ebebe2784551
 author: julieMSFT
 ms.author: jrasnick
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||= azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Best Practice with the Query Store
 [!INCLUDE[appliesto-ss-asdb-asdw-xxx-md](../../includes/appliesto-ss-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/performance/how-query-store-collects-data.md b/docs/relational-databases/performance/how-query-store-collects-data.md
@@ -13,7 +13,7 @@ ms.assetid: 8d5eec36-0013-480a-9c11-183e162e4c8e
 author: julieMSFT
 ms.author: jrasnick
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||= azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # How Query Store Collects Data
 [!INCLUDE[appliesto-ss-asdb-asdw-xxx-md](../../includes/appliesto-ss-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/performance/query-store-usage-scenarios.md b/docs/relational-databases/performance/query-store-usage-scenarios.md
@@ -13,7 +13,7 @@ ms.assetid: f5309285-ce93-472c-944b-9014dc8f001d
 author: julieMSFT
 ms.author: jrasnick
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||= azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Query Store Usage Scenarios
 [!INCLUDE[appliesto-ss-asdb-asdw-xxx-md](../../includes/appliesto-ss-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/query-store-catalog-views-transact-sql.md b/docs/relational-databases/system-catalog-views/query-store-catalog-views-transact-sql.md
@@ -1,7 +1,7 @@
 ---
 title: "Query Store Catalog Views (Transact-SQL) | Microsoft Docs"
 ms.custom: ""
-ms.date: "03/29/2016"
+ms.date: "04/12/2019"
 ms.prod: sql
 ms.prod_service: "database-engine, sql-database"
 ms.reviewer: ""
@@ -16,10 +16,10 @@ ms.assetid: 43d5466a-89e2-4e59-b87e-a2a78e59a1de
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Query Store Catalog Views (Transact-SQL)
-[!INCLUDE[tsql-appliesto-ss2016-asdb-xxxx-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-xxxx-xxx-md.md)]
+[!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
 
   This section contains the following catalog views.  
   
diff --git a/docs/relational-databases/system-catalog-views/sys-database-query-store-options-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-database-query-store-options-transact-sql.md
@@ -21,7 +21,7 @@ ms.assetid: 16b47d55-8019-41ff-ad34-1e0112178067
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.database_query_store_options (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/sys-query-context-settings-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-context-settings-transact-sql.md
@@ -20,7 +20,7 @@ ms.assetid: 3c1887df-6bd8-491e-82fc-d25ad9589faf
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.query_context_settings (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-plan-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-plan-transact-sql.md
@@ -21,7 +21,7 @@ ms.assetid: b4d05439-6360-45db-b1cd-794f4a64935e
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.query_store_plan (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-query-text-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-query-text-transact-sql.md
@@ -21,7 +21,7 @@ ms.assetid: f7032fa0-7c16-4492-bb82-685806c63a8c
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.query_store_query_text (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-query-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-query-transact-sql.md
@@ -21,7 +21,7 @@ ms.assetid: bdee149e-7556-4fc3-8242-925dd4b7b6ac
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.query_store_query (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-runtime-stats-interval-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-runtime-stats-interval-transact-sql.md
@@ -21,7 +21,7 @@ ms.assetid: 2be83785-0569-41a3-88c8-59bfa0932e6e
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.query_store_runtime_stats_interval (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-catalog-views/sys-query-store-runtime-stats-transact-sql.md b/docs/relational-databases/system-catalog-views/sys-query-store-runtime-stats-transact-sql.md
@@ -21,7 +21,7 @@ ms.assetid: ccf7a57c-314b-450c-bd34-70749a02784a
 author: stevestein
 ms.author: sstein
 manager: craigg
-monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||= azure-sqldw-latest||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # sys.query_store_runtime_stats (Transact-SQL)
 [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md](../../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)]
diff --git a/docs/relational-databases/system-stored-procedures/filestream-and-filetable-sp-filestream-force-garbage-collection.md b/docs/relational-databases/system-stored-procedures/filestream-and-filetable-sp-filestream-force-garbage-collection.md
@@ -31,20 +31,20 @@ manager: craigg
 ## Syntax  
   
 ```  
-sp_filestream_force_garbage_collection  
-    [ @dbname = ]  'database_name',  
-    [ @filename = ] 'logical_file_name' ]  
+sp_filestream_force_garbage_collection
+    [ @dbname = ]  'database_name'
+    [ , [ @filename = ] 'logical_file_name' ]
 ```  
   
 ## Arguments  
- **@dbname** = *database_name*
+ `[ @dbname = ]  'database_name'`  
  Signifies the name of the database to run the garbage collector on.  
   
 > [!NOTE]  
->  *dbname* is **sysname**. If not specified, current database is assumed.  
+> `@dbname` is **sysname**. If not specified, current database is assumed.  
   
- **@filename** = *logical_file_name*  
- Specifies the logical name of the FILESTREAM container to run the garbage collector on. **@filename** is optional. If no logical filename is specified, the garbage collector cleans all FILESTREAM containers in the specified database.  
+ `[ @filename = ] 'logical_file_name'`  
+ Specifies the logical name of the FILESTREAM container to run the garbage collector on. `@filename` is optional. If no logical filename is specified, the garbage collector cleans all FILESTREAM containers in the specified database.  
   
 ## Return Code Values  
   
diff --git a/docs/relational-databases/system-stored-procedures/sp-addlinkedsrvlogin-transact-sql.md b/docs/relational-databases/system-stored-procedures/sp-addlinkedsrvlogin-transact-sql.md
@@ -29,30 +29,29 @@ manager: craigg
 ## Syntax  
   
 ```  
-  
 sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'   
-     [ , [ @useself = ] 'TRUE' | 'FALSE' | NULL ]   
+     [ , [ @useself = ] { 'TRUE' | 'FALSE' | NULL } ]   
      [ , [ @locallogin = ] 'locallogin' ]   
      [ , [ @rmtuser = ] 'rmtuser' ]   
      [ , [ @rmtpassword = ] 'rmtpassword' ]   
 ```  
   
 ## Arguments  
- [ @rmtsrvname **=** ] **'***rmtsrvname***'**  
+ `[ @rmtsrvname = ] 'rmtsrvname'`  
  Is the name of a linked server that the login mapping applies to. *rmtsrvname* is **sysname**, with no default.  
   
- [ @useself **=** ] **'**TRUE**'** | 'FALSE' | 'NULL'  
+ `[ @useself = ] { 'TRUE' | 'FALSE' | NULL }'`  
  Determines whether to connect to *rmtsrvname* by impersonating local logins or explicitly submitting a login and password. The data type is **varchar(**8**)**, with a default of TRUE.  
   
  A value of TRUE specifies that logins use their own credentials to connect to *rmtsrvname*, with the *rmtuser* and *rmtpassword* arguments being ignored. FALSE specifies that the *rmtuser* and *rmtpassword* arguments are used to connect to *rmtsrvname* for the specified *locallogin*. If *rmtuser* and *rmtpassword* are also set to NULL, no login or password is used to connect to the linked server.  
   
- [ @locallogin **=** ] **'***locallogin***'**  
+ `[ @locallogin = ] 'locallogin'`  
  Is a login on the local server. *locallogin* is **sysname**, with a default of NULL. NULL specifies that this entry applies to all local logins that connect to *rmtsrvname*. If not NULL, *locallogin* can be a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] login or a Windows login. The Windows login must have been granted access to [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] either directly, or through its membership in a Windows group granted access.  
   
- [ @rmtuser **=** ] **'***rmtuser***'**  
+ `[ @rmtuser = ] 'rmtuser'`  
  Is the remote login used to connect to *rmtsrvname* when @useself is FALSE. When the remote server is an instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] that does not use Windows Authentication, *rmtuser* is a [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] login. *rmtuser* is **sysname**, with a default of NULL.  
   
- [ @rmtpassword **=** ] **'***rmtpassword***'**  
+ `[ @rmtpassword = ] 'rmtpassword'`  
  Is the password associated with *rmtuser*. *rmtpassword* is **sysname**, with a default of NULL.  
   
 ## Return Code Values  
diff --git a/docs/relational-databases/system-stored-procedures/sp-audit-write-transact-sql.md b/docs/relational-databases/system-stored-procedures/sp-audit-write-transact-sql.md
@@ -29,22 +29,21 @@ manager: craigg
 ## Syntax  
   
 ```  
-  
-sp_audit_write [ @user_defined_event_id =  ] user_defined_event_id ,   
-        [ @succeeded =  succeeded   
-    [ , [ @user_defined_information =  ] 'user_defined_information' ]   
-    [ ; ]  
+sp_audit_write [ @user_defined_event_id = ] user_defined_event_id
+    [ , [ @succeeded = ] succeeded ]
+    [ , [ @user_defined_information = ] 'user_defined_information' ]
+    [ ; ]
 ```  
   
 ## Arguments  
- **@user_defined_event_id**  
+ `[ @user_defined_event_id = ] user_defined_event_id`  
  A parameter defined by the user and recorded in the **user_defined_event_id** column of the audit log. *@user_defined_event_id* is type **smallint**.  
   
- **@succeeded**  
- A parameter passed by user to indicate whether the event was successful or not. This appears in the succeeded column of the audit log. *@succeeded* is **bit**.  
+ `[ @succeeded = ] succeeded`  
+ A parameter passed by user to indicate whether the event was successful or not. This appears in the succeeded column of the audit log. `@succeeded` is **bit**.  
   
- **@user_defined_information**  
- Is the text defined by the user and recorded in the new user_defined_event_id column of the audit log. *@user_defined_information* is **nvarchar(4000)**.  
+ `[ @user_defined_information = ] 'user_defined_information'`  
+ Is the text defined by the user and recorded in the new user_defined_event_id column of the audit log. `@user_defined_information` is **nvarchar(4000)**.  
   
 ## Return Code Values  
  0 (success) or 1 (failure)  
diff --git a/docs/relational-databases/system-stored-procedures/sp-delete-database-firewall-rule-azure-sql-database.md b/docs/relational-databases/system-stored-procedures/sp-delete-database-firewall-rule-azure-sql-database.md
@@ -28,14 +28,13 @@ monikerRange: "= azuresqldb-current || = sqlallproducts-allversions"
  
 ## Syntax  
   
-```  
-  
+```    
 sp_delete_database_firewall_rule [@name =] [N]'name'
 [ ; ]  
 ```  
   
 ## Arguments  
- [**@name =**] **'**_name_**'**  
+ `[@name =] [N]'name'`  
  The name of the database-level firewall setting that will be removed. *name* is **nvarchar(128)** with no default value. The Unicode identifier `N` is optional for [!INCLUDE[ssSDS_md](../../includes/sssds-md.md)]. 
   
 ## Permissions  
diff --git a/docs/relational-databases/wmi-provider-configuration/working-with-the-wmi-provider-for-configuration-management.md b/docs/relational-databases/wmi-provider-configuration/working-with-the-wmi-provider-for-configuration-management.md
diff --git a/docs/t-sql/statements/create-spatial-index-transact-sql.md b/docs/t-sql/statements/create-spatial-index-transact-sql.md
