Skip to content

Commit 19f6fb3

Browse files
author
Gene Milener
committed
Message fixing: Adding '&preserve-view=true' to Nondefault monikers.
1 parent 211dd15 commit 19f6fb3

67 files changed

Lines changed: 164 additions & 164 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎docs/analytics-platform-system/acquire-and-configure-backup-server.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -115,9 +115,9 @@ FROM DISK = '\\10.172.14.255\backups\yearly\Invoices2013Full'
115115

116116
For more information, see:
117117

118-
- [BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016)
118+
- [BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
119119

120-
- [RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016)
120+
- [RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
121121

122122
## <a name="Security"></a>Security notices
123123
The backup server is not joined to the private domain for the appliance. It is in your own network, and there is no trust relationship between your own domain and private appliance domain.

‎docs/analytics-platform-system/backup-and-restore-overview.md‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -18,7 +18,7 @@ Describes how data backup and restore works for Parallel Data Warehouse (PDW). B
1818

1919
A PDW *database backup* is a copy of an appliance database, stored in a format so that it can be used to restore the original database to an appliance.
2020

21-
A PDW database backup is created with the [BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016) t-sql statement and formatted for use with the [RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016) statement; it is unusable for any other purpose. The backup can only be restored to an appliance with the same number or a greater number of Compute nodes.
21+
A PDW database backup is created with the [BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016&preserve-view=true) t-sql statement and formatted for use with the [RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016&preserve-view=true) statement; it is unusable for any other purpose. The backup can only be restored to an appliance with the same number or a greater number of Compute nodes.
2222

2323
<!-- MISSING LINKS
2424
The [master database](master-database.md) is a SMP SQL Server database. It is backed up with the BACKUP DATABASE statement. To restore master, use the [Restore the Master Database](configuration-manager-restore-master-database.md) page of the Configuration Manager tool.
@@ -98,7 +98,7 @@ When restoring data, the appliance detects the number of Compute nodes on the so
9898

9999
1. The database backup to be restored is available on a Windows file share on a non-appliance backup server. For best performance, this server is connected to the appliance InfiniBand network.
100100

101-
2. User submits a [RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016) tsql statement to the Control node.
101+
2. User submits a [RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016&preserve-view=true) tsql statement to the Control node.
102102

103103
- The restore is either a full restore or a header restore. The full restore restores a full backup and then optionally restores a differential backup.
104104

@@ -127,8 +127,8 @@ After the redistribution, each Compute node will contain less actual data and mo
127127
|Backup and Restore Task|Description|
128128
|---------------------------|---------------|
129129
|Prepare a server as a backup server.|[Acquire and configure a backup server](acquire-and-configure-backup-server.md)|
130-
|Backup a database.|[BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016)|
131-
|Restore a database.|[RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016)|
130+
|Backup a database.|[BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016&preserve-view=true)|
131+
|Restore a database.|[RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016&preserve-view=true)|
132132

133133
<!-- MISSING LINKS
134134

‎docs/analytics-platform-system/dwloader.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -523,7 +523,7 @@ Loaded data might require more or less space on the appliance than in the source
523523
Although **dwloader** is a transaction process and will roll back gracefully on failure, it cannot be rolled back once the bulk load has been completed successfully. To cancel an active **dwloader** process, type CTRL+C.
524524

525525
## Limitations and Restrictions
526-
The total size of all loads occurring concurrently must be smaller than LOG_SIZE for the database, and we recommend the total size of all concurrent loads is less than 50% of the LOG_SIZE. To achieve this size limitation, you can split large loads into multiple batches. For more information on LOG_SIZE, see [CREATE DATABASE](../t-sql/statements/create-database-transact-sql.md?view=aps-pdw-2016)
526+
The total size of all loads occurring concurrently must be smaller than LOG_SIZE for the database, and we recommend the total size of all concurrent loads is less than 50% of the LOG_SIZE. To achieve this size limitation, you can split large loads into multiple batches. For more information on LOG_SIZE, see [CREATE DATABASE](../t-sql/statements/create-database-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
527527

528528
When loading multiple files with one load command, all rejected rows are written to the same reject file. The reject file does not show which input file contains each rejected row.
529529

‎docs/analytics-platform-system/master-database.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -39,7 +39,7 @@ You *cannot:*
3939

4040
|Task|Description|
4141
|--------|---------------|
42-
|Create a full backup of master.|Example:<br /><br />`BACKUP DATABASE master TO backup_directory;`<br /><br />For more information, see [BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016).|
42+
|Create a full backup of master.|Example:<br /><br />`BACKUP DATABASE master TO backup_directory;`<br /><br />For more information, see [BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016&preserve-view=true).|
4343
|Restore the master database|To restore the master database, use the [Restore the Master Database](restore-the-master-database.md) page in the Configuration Manager tool.|
4444
|View database catalog information.|`SELECT * FROM master.sys.databases;`|
4545
|View system-wide login and permission information.|`SELECT * FROM master.sys.server_permissions;`<br /><br />`SELECT * FROM master.sys.server_principals;`<br /><br />`SELECT * FROM master.sys.sql_logins;`|

‎docs/analytics-platform-system/restore-database-protected-by-tde.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -54,9 +54,9 @@ RESTORE DATABASE AdventureWorksPDW2012
5454
```
5555

5656
## See Also
57-
[BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016)
57+
[BACKUP DATABASE](../t-sql/statements/backup-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
5858
[CREATE MASTER KEY](../t-sql/statements/create-master-key-transact-sql.md)
5959
[sp_pdw_add_network_credentials](../relational-databases/system-stored-procedures/sp-pdw-add-network-credentials-sql-data-warehouse.md)
6060
[sp_pdw_database_encryption](../relational-databases/system-stored-procedures/sp-pdw-database-encryption-sql-data-warehouse.md)
6161
[CREATE CERTIFICATE](../t-sql/statements/create-certificate-transact-sql.md)
62-
[RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016)
62+
[RESTORE DATABASE](../t-sql/statements/restore-statements-transact-sql.md?view=aps-pdw-2016&preserve-view=true)

‎docs/analytics-platform-system/tsql-statements.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -15,13 +15,13 @@ ms.custom: seo-dt-2019
1515
Transact-SQL (T-SQL) statements for Analytic Platform System (APS) SQL Server Parallel Data Warehouse (PDW).
1616

1717
## Data Definition Language (DDL) statements
18-
* [ALTER DATABASE](../t-sql/statements/alter-database-transact-sql.md?view=aps-pdw-2016)
18+
* [ALTER DATABASE](../t-sql/statements/alter-database-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
1919
* [ALTER INDEX](../t-sql/statements/alter-index-transact-sql.md)
2020
* [ALTER PROCEDURE](../t-sql/statements/alter-procedure-transact-sql.md)
2121
* [ALTER SCHEMA](../t-sql/statements/alter-schema-transact-sql.md)
2222
* [ALTER TABLE](../t-sql/statements/alter-table-transact-sql.md)
2323
* [CREATE COLUMNSTORE INDEX](../t-sql/statements/create-columnstore-index-transact-sql.md)
24-
* [CREATE DATABASE](../t-sql/statements/create-database-transact-sql.md?view=aps-pdw-2016)
24+
* [CREATE DATABASE](../t-sql/statements/create-database-transact-sql.md?view=aps-pdw-2016&preserve-view=true)
2525
* [CREATE DATABASE SCOPED CREDENTIAL](../t-sql/statements/create-database-scoped-credential-transact-sql.md)
2626
* [CREATE EXTERNAL DATA SOURCE](../t-sql/statements/create-external-data-source-transact-sql.md)
2727
* [CREATE EXTERNAL FILE FORMAT](../t-sql/statements/create-external-file-format-transact-sql.md)

‎docs/analytics-platform-system/whats-new-analytics-platform-system.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -39,13 +39,13 @@ Customers will now be able to alter views. See [ALTER VIEW (Transact-SQL)](../t-
3939
Release date - September 2019
4040

4141
### Alter External Data Source
42-
Customers will be able to alter external data source definition with the CU7.5 update. Customers with Hadoop name node high availability can now alter the data source to change the arguments when a failover happens. For APS, only the LOCATION, RESOURCE_MANAGER_LOCATION and CREDENTIAL can be changed. See [alter external data source](../t-sql/statements/alter-external-data-source-transact-sql.md?view=sql-server-2017) for more information.
42+
Customers will be able to alter external data source definition with the CU7.5 update. Customers with Hadoop name node high availability can now alter the data source to change the arguments when a failover happens. For APS, only the LOCATION, RESOURCE_MANAGER_LOCATION and CREDENTIAL can be changed. See [alter external data source](../t-sql/statements/alter-external-data-source-transact-sql.md?view=sql-server-2017&preserve-view=true) for more information.
4343

4444
### CDH 5.15 and 5.16 support with PolyBase
4545
PolyBase on APS with CU7.5 update now supports CDH 5.15 and 5.16 versions of Hadoop distribution from Cloudera. Use option 6 for CDH 5.x versions.
4646

4747
### Try_Convert and Try_Cast support
48-
CU7.5 APS now supports [TRY_CAST](../t-sql/functions/try-cast-transact-sql.md?view=sql-server-2017) and [TRY_CONVERT](../t-sql/functions/try-convert-transact-sql.md?view=sql-server-2017) tsql functions. Both of these functions returns a value converted to the specified data type if the convert succeeds; otherwise, returns null.
48+
CU7.5 APS now supports [TRY_CAST](../t-sql/functions/try-cast-transact-sql.md?view=sql-server-2017&preserve-view=true) and [TRY_CONVERT](../t-sql/functions/try-convert-transact-sql.md?view=sql-server-2017&preserve-view=true) tsql functions. Both of these functions returns a value converted to the specified data type if the convert succeeds; otherwise, returns null.
4949

5050
<a name="h2-aps-cu7.4"></a>
5151
## APS CU7.4

‎docs/database-engine/install-windows/install-sql-server-with-powershell-desired-state-configuration.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -39,7 +39,7 @@ In most cases, DSC is used to handle the prerequisite requirements. But for the
3939

4040
## Install the SqlServerDsc DSC resource
4141

42-
Download the [SqlServerDsc](https://www.powershellgallery.com/packages/SqlServerDsc) DSC resource from the [PowerShell Gallery](https://www.powershellgallery.com/) by using the [Install-Module](/powershell/module/powershellget/Install-Module?view=powershell-5.1) cmdlet.
42+
Download the [SqlServerDsc](https://www.powershellgallery.com/packages/SqlServerDsc) DSC resource from the [PowerShell Gallery](https://www.powershellgallery.com/) by using the [Install-Module](/powershell/module/powershellget/Install-Module?view=powershell-5.1&preserve-view=true) cmdlet.
4343

4444
> [!NOTE]
4545
> Make sure PowerShell is running **As Administrator** to install the module.
@@ -212,4 +212,4 @@ PS C:\> & sqlcmd -S $env:COMPUTERNAME
212212

213213
[Install SQL Server from the command prompt](../../database-engine/install-windows/install-sql-server-from-the-command-prompt.md)
214214

215-
[Install SQL Server by using a configuration file](../../database-engine/install-windows/install-sql-server-using-a-configuration-file.md)
215+
[Install SQL Server by using a configuration file](../../database-engine/install-windows/install-sql-server-using-a-configuration-file.md)

‎docs/dea/database-experimentation-assistant-replay-trace.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -134,7 +134,7 @@ You can get more details in the logs in %temp%\\DEA. If the problem persists, co
134134

135135
- Verify that the Distributed Replay controller service is running on the controller machine. To verify, use the Distributed Replay Management Tools (run the command `dreplay.exe status -f 1`).
136136
- If the replay is started remotely:
137-
- Confirm that the computer running DEA can successfully ping the controller. Confirm that firewall settings allow connections per the instructions on the **Configure Replay Environment** page. For more information, see the article [SQL Server Distributed Replay](../tools/distributed-replay/sql-server-distributed-replay.md?view=sql-server-2017).
137+
- Confirm that the computer running DEA can successfully ping the controller. Confirm that firewall settings allow connections per the instructions on the **Configure Replay Environment** page. For more information, see the article [SQL Server Distributed Replay](../tools/distributed-replay/sql-server-distributed-replay.md?view=sql-server-2017&preserve-view=true).
138138
- Make sure that DCOM Remote Launch and Remote Activation are allowed for the user of the Distributed Replay controller.
139139
- Make sure that DCOM Remote Access user rights are allowed for the user of the Distributed Replay controller.
140140

@@ -160,4 +160,4 @@ The issue has been addressed in the latest Cumulative Update 1 for SQL Server 20
160160

161161
## See also
162162

163-
- To create an analysis report that helps you gain insights on proposed changes, see [Create reports](database-experimentation-assistant-create-report.md).
163+
- To create an analysis report that helps you gain insights on proposed changes, see [Create reports](database-experimentation-assistant-create-report.md).

‎docs/dma/dma-assess-sql-data-estate-to-sqldb.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ ms.custom: "seo-lt-2019"
2020

2121
Migrating hundreds of SQL Server instances and thousands of databases to Azure SQL Database, our Platform as a Service (PaaS) offering, is a considerable task. To streamline the process as much as possible, you need to feel confident about your relative readiness for migration. Identifying low-hanging fruit, including the servers and databases that are fully ready or that require minimal effort to prepare for migration, eases and accelerates your efforts.
2222

23-
This article provides step-by-step instructions for leveraging the [Data Migration Assistant](./dma-overview.md?view=sql-server-2017) to summarize readiness results and surface them on the [Azure Migrate](https://portal.azure.com/?feature.customPortal=false#blade/Microsoft_Azure_Migrate/AmhResourceMenuBlade/overview) hub.
23+
This article provides step-by-step instructions for leveraging the [Data Migration Assistant](./dma-overview.md?view=sql-server-2017&preserve-view=true) to summarize readiness results and surface them on the [Azure Migrate](https://portal.azure.com/?feature.customPortal=false#blade/Microsoft_Azure_Migrate/AmhResourceMenuBlade/overview) hub.
2424

2525
>
2626
> [!VIDEO https://channel9.msdn.com/Shows/Data-Exposed/Data-Migration-Assistant/player?WT.mc_id=dataexposed-c9-niner]
@@ -177,4 +177,4 @@ After you successfully create a migration project, under **Assessment tools**, i
177177

178178
* [Data Migration Assistant (DMA)](../dma/dma-overview.md)
179179
* [Data Migration Assistant: Configuration settings](../dma/dma-configurationsettings.md)
180-
* [Data Migration Assistant: Best Practices](../dma/dma-bestpractices.md)
180+
* [Data Migration Assistant: Best Practices](../dma/dma-bestpractices.md)

0 commit comments

Comments
 (0)