About this release What's new Architecture Parallel Data Warehouse overview Hardware components Hardware configurations Processing and storage capacity High availability Backup and loading hardware Overview Acquire and configure a loading server Loading server capacity planning worksheet Acquire and configure a backup server Backup server capacity planning worksheet Configure InfiniBand network adapters Query Monitoring active queries Load Overview Create staging database Load with Integration Services Create an Integration Services script task that uses the PDW destination adapter Data type conversion rules for dwloader Load data with INSERT dwloader Command-line Loading Tool Monitor loads Database administration Backup and restore Overview Restore a database protected by TDE PDW permissions Grant permissions Error messages Locking behavior Remote table copy Configure an external Windows system to receive remote table copies using InfiniBand Configure an external SMP SQL Server to receive remote table copies Configure SQL Server PDW for remote table copies System databases Reserved database names tempdb database master database User sessions Workload management Workload management tasks Security Transparent Data Encryption Provision a certificate Appliance mangement tasks Appliance installation and configuration overview Information to obtain from your IHV Hardware installation Connect to appliance nodes Antivirus software Appliance configuration PDW and appliance fabric physical components Launch the Configuration Manager Appliance topology Password reset Appliance time zone configuration Appliance network configuration PDW topology PDW certificate provisioning PDW firewall configuration PDW services status Instant file initialization configuration Restore the master database Set admin password for logging on to AD nodes in Directory Services Restore Mode (DSRM) Configure Windows Server Update Services Configure PolyBase connectivity to external data Use a DNS forwarder to resolve non-appliance DNS names Create an APS Domain administrator Send telemetry feedback to Microsoft Software servicing Download and apply Microsoft updates Uninstall Microsoft updates Apply Analytics Platform System hotfixes Uninstall Analytic Platform System hotfixes Power the APS appliance on or off Appliance monitoring Monitor the appliance by using the Admin Console Monitor the appliance by using system views Monitor the appliance by using System Center Operations Manager Install the SCOM management packs Import the SCOM management pack for PDW Configure SCOM to monitor Analytics Platform System Monitor appliance health state Track appliance alerts View capacity utilization Determine polling frequency Determine which cluster node failed Understanding Admin Console alerts Reference T-SQL language elements T-SQL statements T-SQL system views