Merge pull request #12288 from MicrosoftDocs/master

huypub · web-flow · commit af5e1f74a8c1 · 2019-10-02T15:27:41.000-07:00
10/02 PM Publish
diff --git a/docs/advanced-analytics/administration/resource-governor.md b/docs/advanced-analytics/administration/resource-governor.md
@@ -3,7 +3,7 @@ title: Manage Python and R workloads with Resource Governor
 description: Learn how to use Resource Governor to manage CPU, physical IO, and memory resources allocation for Python and R workloads in SQL Server Machine Learning Services.
 ms.prod: sql
 ms.technology: machine-learning
-ms.date: 10/01/2019
+ms.date: 10/02/2019
 ms.topic: conceptual
 author: dphansen
 ms.author: davidph
@@ -25,11 +25,11 @@ For more general information, see [Resource Governor](../../relational-databases
 
 By default, the external script runtimes for machine learning are limited to no more than 20% of total machine memory. It depends on your system, but in general, you might find this limit inadequate for serious machine learning tasks such as training a model or predicting on many rows of data. 
 
-## Use Resource Governor to control resourcing
+## Manage resources with Resource Governor
  
 By default, external processes use up to 20% of total host memory on the local server. You can modify the default resource pool to make server-wide changes, with R and Python processes utilizing whatever capacity you make available to external processes.
 
-Alternatively, you can construct custom *external resource pools*, with associated workload groups and classifiers, to determine resource allocation for requests originating from specific programs, hosts, or other criteria that you provide. An external resource pool is a type of resource pool introduced in [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] to help manage the R and Python processes external to the database engine.
+Alternatively, you can create custom **external resource pools**, with associated workload groups and classifiers, to determine resource allocation for requests originating from specific programs, hosts, or other criteria that you provide. An external resource pool is a type of resource pool introduced in [!INCLUDE[sssql15-md](../../includes/sssql15-md.md)] to help manage the R and Python processes external to the database engine.
 
 1. [Enable resource governance](https://docs.microsoft.com/sql/relational-databases/resource-governor/enable-resource-governor) (it is off by default).
 
diff --git a/docs/big-data-cluster/deployment-high-availability.md b/docs/big-data-cluster/deployment-high-availability.md
@@ -82,6 +82,11 @@ The following steps show how to create a patch file that includes these settings
     ```bash
     azdata bdc config patch -c custom-aks/bdc.json --patch-file patch.json
     ```
+1. Start cluster deployment using the cluster configuration profile created above
+
+    ```bash
+    azdata bdc create --config-profile custom-aks --accept-eula yes
+    ```
 
 ## Connect to SQL Server databases
 
diff --git a/docs/database-engine/configure-windows/hybrid-buffer-pool.md b/docs/database-engine/configure-windows/hybrid-buffer-pool.md
@@ -89,6 +89,8 @@ SELECT name, is_memory_optimized_enabled FROM sys.databases;
 
 When formatting your PMEM device on Windows, use the largest allocation unit size available for NTFS (2 MB in Windows Server 2019) and ensure the device has been formatted for DAX (Direct Access).
 
+For optimal performance, enable [Locked Pages in Memory](./enable-the-lock-pages-in-memory-option-windows.md) on Windows.
+
 Files sizes should be a multiple of 2 MB (modulo 2 MB should equal zero).
 
 If the server scoped setting for Hybrid buffer pool is set to disabled, Hybrid buffer pool will not be used by any user database.
diff --git a/docs/relational-databases/data-tier-applications/delete-a-data-tier-application.md b/docs/relational-databases/data-tier-applications/delete-a-data-tier-application.md
@@ -128,102 +128,96 @@ ms.author: "sstein"
   
  [Using the Delete Data-tier Application Wizard](#UsingDeleteDACWizard)  
   
-##  <a name="DeleteDACPowerShell"></a> Delete a DAC Using PowerShell  
- **To delete a DAC using a PowerShell script**  
+##  <a name="DeleteDACPowerShell"></a> Using PowerShell  
+
+1. Create a SMO Server object and set it to the instance that contains the DAC to be deleted.  
   
-1.  Create a SMO Server object and set it to the instance that contains the DAC to be deleted.  
+1. Open a **ServerConnection** object and connect to the same instance.  
   
-2.  Open a **ServerConnection** object and connect to the same instance.  
+1. Use `add_DacActionStarted` and `add_DacActionFinished` to subscribe to the DAC upgrade events.  
   
-3.  Use **add_DacActionStarted** and **add_DacActionFinished** to subscribe to the DAC upgrade events.  
+1. Specify the DAC to delete.  
   
-4.  Specify the DAC to delete.  
+1. Use one of three examples, depending on which delete option is appropriate:  
   
-5.  Use one of these three sets of code, depending on which delete option is appropriate:  
+   - To delete the DAC registration and leave the database intact, use the `Unmanage` method.  
+   - To delete the DAC registration and detach the database, use the `Uninstall` method and specify `DetachDatabase`.  
+   - To delete the DAC registration and drop the database, use the `Uninstall` method and specify `DropDatabase`.
   
-    -   To delete the DAC registration but leave the database intact, use the **Unmanage()** method.  
+### Delete the DAC and leave the database
+
+The following example deletes a DAC named `<myApplication>` using the `Unmanage` method to delete the DAC but leave the database intact.  
   
-    -   To delete the DAC registration and detach the database, use the **Uninstall()** method and specify **DetachDatabase**.  
-  
-    -   To delete the DAC registration and drop the database, use the **Uninstall()** method and specify **DropDatabase**.  
-  
-### Example Deleting the DAC but Leaving the Database (PowerShell)  
- The following example deletes a DAC named MyApplication using the **Unmanage()** method to delete the DAC but leave the database intact.  
-  
-```  
+```powershell
 ## Set a SMO Server object to the default instance on the local computer.  
 CD SQLSERVER:\SQL\localhost\DEFAULT  
-$srv = get-item .  
+$server = Get-Item .  
   
 ## Open a Common.ServerConnection to the same instance.  
-$serverconnection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection($srv.ConnectionContext.SqlConnectionObject)  
-$serverconnection.Connect()  
-$dacstore = New-Object Microsoft.SqlServer.Management.Dac.DacStore($serverconnection)  
+$serverConnection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection($server.ConnectionContext.SqlConnectionObject)  
+$serverConnection.Connect()  
+$dacStore = New-Object Microsoft.SqlServer.Management.Dac.DacStore($serverConnection)  
   
 ## Subscribe to the DAC delete events.  
-$dacstore.add_DacActionStarted({Write-Host `n`nStarting at $(get-date) :: $_.Description})  
-$dacstore.add_DacActionFinished({Write-Host Completed at $(get-date) :: $_.Description})  
+$dacStore.add_DacActionStarted({Write-Host `n`nStarting at $(Get-Date) :: $_.Description})  
+$dacStore.add_DacActionFinished({Write-Host Completed at $(Get-Date) :: $_.Description})  
   
 ## Specify the DAC to delete.  
-$dacName  = "MyApplication"  
+$dacName  = "<myApplication>"  
   
 ## Only delete the DAC definition from msdb, the associated database remains active.  
-$dacstore.Unmanage($dacName)  
-```  
+$dacStore.Unmanage($dacName)  
+```
   
- [Delete a DAC Using PowerShell](#DeleteDACPowerShell)  
+### Delete the DAC and detach the database
+
+The following example deletes a DAC named `<myApplication>` using the `Uninstall` method to delete the DAC and detach the database.  
   
-### Example Deleting the DAC and Detaching the Database (PowerShell)  
- The following example deletes a DAC named MyApplication using the **Uninstall()** method to delete the DAC and detach the database.  
-  
-```  
+```powershell
 ## Set a SMO Server object to the default instance on the local computer.  
 CD SQLSERVER:\SQL\localhost\DEFAULT  
-$srv = get-item .  
+$server = Get-Item .  
   
 ## Open a Common.ServerConnection to the same instance.  
-$serverconnection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection($srv.ConnectionContext.SqlConnectionObject)  
-$serverconnection.Connect()  
-$dacstore = New-Object Microsoft.SqlServer.Management.Dac.DacStore($serverconnection)  
+$serverConnection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection($server.ConnectionContext.SqlConnectionObject)  
+$serverConnection.Connect()  
+$dacStore = New-Object Microsoft.SqlServer.Management.Dac.DacStore($serverConnection)  
   
 ## Subscribe to the DAC delete events.  
-$dacstore.add_DacActionStarted({Write-Host `n`nStarting at $(get-date) :: $_.Description})  
-$dacstore.add_DacActionFinished({Write-Host Completed at $(get-date) :: $_.Description})  
+$dacStore.add_DacActionStarted({Write-Host `n`nStarting at $(Get-Date) :: $_.Description})  
+$dacStore.add_DacActionFinished({Write-Host Completed at $(Get-Date) :: $_.Description})  
   
 ## Specify the DAC to delete.  
-$dacName  = "MyApplication"  
+$dacName  = "<myApplication>"  
   
 ## Delete the DAC definition from msdb and detach the associated database.  
-$dacstore.Uninstall($dacName, [Microsoft.SqlServer.Management.Dac.DacUninstallMode]::DetachDatabase)  
-```  
-  
- [Delete a DAC Using PowerShell](#DeleteDACPowerShell)  
+$dacStore.Uninstall($dacName, [Microsoft.SqlServer.Management.Dac.DacUninstallMode]::DetachDatabase)  
+```
   
-### Example Deleting the DAC and Dropping the Database (PowerShell)  
- The following example deletes a DAC named MyApplication using the **Uninstall()** method to delete the DAC and drop the database.  
+### Delete the DAC and drop the database
+
+The following example deletes a DAC named `<myApplication>` using the `Uninstall` method to delete the DAC and drop the database.  
   
-```  
+```powershell
 ## Set a SMO Server object to the default instance on the local computer.  
 CD SQLSERVER:\SQL\localhost\DEFAULT  
-$srv = get-item .  
+$server = Get-Item .  
   
 ## Open a Common.ServerConnection to the same instance.  
-$serverconnection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection($srv.ConnectionContext.SqlConnectionObject)  
-$serverconnection.Connect()  
-$dacstore = New-Object Microsoft.SqlServer.Management.Dac.DacStore($serverconnection)  
+$serverConnection = New-Object Microsoft.SqlServer.Management.Common.ServerConnection($server.ConnectionContext.SqlConnectionObject)  
+$serverConnection.Connect()  
+$dacStore = New-Object Microsoft.SqlServer.Management.Dac.DacStore($serverConnection)  
   
 ## Subscribe to the DAC delete events.  
-$dacstore.add_DacActionStarted({Write-Host `n`nStarting at $(get-date) :: $_.Description})  
-$dacstore.add_DacActionFinished({Write-Host Completed at $(get-date) :: $_.Description})  
+$dacStore.add_DacActionStarted({Write-Host `n`nStarting at $(Get-Date) :: $_.Description})  
+$dacStore.add_DacActionFinished({Write-Host Completed at $(Get-Date) :: $_.Description})  
   
 ## Specify the DAC to delete.  
-$dacName  = "MyApplication"  
+$dacName  = "<myApplication>"  
   
 ## Delete the DAC definition from msdb and drop the associated database.  
-## $dacstore.Uninstall($dacName, [Microsoft.SqlServer.Management.Dac.DacUninstallMode]::DropDatabase)  
-```  
-  
- [Delete a DAC Using PowerShell](#DeleteDACPowerShell)  
+$dacStore.Uninstall($dacName, [Microsoft.SqlServer.Management.Dac.DacUninstallMode]::DropDatabase)  
+```
   
 ## See Also  
  [Data-tier Applications](../../relational-databases/data-tier-applications/data-tier-applications.md)   
diff --git a/docs/relational-databases/polybase/polybase-troubleshoot-connectivity.md b/docs/relational-databases/polybase/polybase-troubleshoot-connectivity.md
@@ -19,7 +19,7 @@ You can use interactive diagnostics that have been built into PolyBase to help t
 
 This article serves as a guide to walk through the debugging process of such issues by leveraging these built-in diagnostics.
 
-> [!TIP}
+> [!TIP]
 > Instead of following the steps in this guide, you can choose to run the [HDFS Kerberos Tester](https://github.com/microsoft/sql-server-samples/tree/master/samples/manage/hdfs-kerberos-tester) to troubleshoot HDFS Kerberos connections for PolyBase, when you experience HDFS Kerberos failure while creating an external table in a Kerberos secured HDFS cluster.
 > This tool will assist in ruling out non-SQL Server issues, to help you concentrate on resolving HDFS Kerberos setup issues, namely identifying issues with username/password misconfigurations, and cluster Kerberos setup misconfigurations.      
 > This tool is completely independent from [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]. It is available as a Jupyter Notebook and requires Azure Data Studio.
diff --git a/docs/t-sql/language-elements/if-else-transact-sql.md b/docs/t-sql/language-elements/if-else-transact-sql.md
@@ -54,7 +54,7 @@ IF Boolean_expression
   
 ## Example  
   
-```  
+```sql
 IF DATENAME(weekday, GETDATE()) IN (N'Saturday', N'Sunday')
        SELECT 'Weekend';
 ELSE 
@@ -66,23 +66,20 @@ ELSE
 ## Examples: [!INCLUDE[ssSDWfull](../../includes/sssdwfull-md.md)] and [!INCLUDE[ssPDW](../../includes/sspdw-md.md)]  
  The following example uses `IF...ELSE` to determine which of two responses to show the user, based on the weight of an item in the `DimProduct` table.  
   
-```  
+```sql
 -- Uses AdventureWorksDW  
-  
+
 DECLARE @maxWeight float, @productKey integer  
 SET @maxWeight = 100.00  
 SET @productKey = 424  
-IF @maxWeight <= (SELECT Weight from DimProduct 
-                  WHERE ProductKey = @productKey)   
-    (SELECT @productKey AS ProductKey, EnglishDescription, Weight, 
-    'This product is too heavy to ship and is only available for pickup.' 
+IF @maxWeight <= (SELECT Weight from DimProduct WHERE ProductKey = @productKey)   
+    SELECT @productKey AS ProductKey, EnglishDescription, Weight, 'This product is too heavy to ship and is only available for pickup.' 
         AS ShippingStatus
-    FROM DimProduct WHERE ProductKey = @productKey);  
+    FROM DimProduct WHERE ProductKey = @productKey
 ELSE  
-    (SELECT @productKey AS ProductKey, EnglishDescription, Weight, 
-    'This product is available for shipping or pickup.' 
+    SELECT @productKey AS ProductKey, EnglishDescription, Weight, 'This product is available for shipping or pickup.' 
         AS ShippingStatus
-    FROM DimProduct WHERE ProductKey = @productKey);  
+    FROM DimProduct WHERE ProductKey = @productKey
 ```  
   
 ## See Also  
@@ -93,8 +90,3 @@ ELSE
  [CASE &#40;Transact-SQL&#41;](../../t-sql/language-elements/case-transact-sql.md)   
  [Control-of-Flow Language &#40;Transact-SQL&#41;](~/t-sql/language-elements/control-of-flow.md)
  [ELSE &#40;IF...ELSE&#41; &#40;Transact-SQL&#41;](../../t-sql/language-elements/else-if-else-transact-sql.md) 
-  
-  
-
-
-
diff --git a/docs/t-sql/statements/alter-database-transact-sql-set-options.md b/docs/t-sql/statements/alter-database-transact-sql-set-options.md
diff --git a/docs/t-sql/statements/alter-table-transact-sql.md b/docs/t-sql/statements/alter-table-transact-sql.md
