SQL Data Warehouse

Official Documentation

Service Description

With SQL Data Warehouse, Data Warehouse solutions can be set up flexibly and their resources can be adapted to the specific data evaluation requirements. Compute and storage services can be scaled independently of one another, allowing the compute resources to be extended, reduced, or suspended while retaining the storage systems (for relational data or non-relational Blob storage).

Getting Started

  1. 9/28/2016, Video, 1:03:40
    Learn how SQL Data Warehouse can help you succeed with a complex hybrid architecture or deployment in Microsoft Azure. Deep views on integration with Azure services such as...
  2. 9/26/2017, Video, 1:14:36
    Did you know that *almost everything* tastes better with pesto? That’s especially true when you are dining on data with a high-carb, Petabyte scale, cloud data warehouse...
  3. 9/28/2017, Video, 1:12:13
    Microsoft Azure provides a broad range of services for working with data. Using these services well requires knowing at least a little bit about all of them. In this session,...



Latest Content

Subscribe to News about SQL Data Warehouse

Title  
Video
Blog
Blog
Blog
Blog
Video
Blog
Blog
Blog
Video
Video
Podcast
more...


Azure Documentation

1. Overview
     1.1. About SQL Data Warehouse
     1.2. Cheat sheet
2. Quickstarts
     2.1. Create and connect - portal
3. Tutorials
     3.1. 1 - Load data from blob
4. Concepts
     4.1. Service features
          4.1.1. MPP architecture
          4.1.2. Performance tiers
          4.1.3. Data warehouse units
          4.1.4. Data warehouse backups
          4.1.5. Auditing
          4.1.6. Capacity limits
          4.1.7. FAQ
     4.2. Security
          4.2.1. Overview
          4.2.2. Authentication
     4.3. Migrate to SQL Data Warehouse
          4.3.1. Overview
          4.3.2. Migrate schema
          4.3.3. Migrate code
          4.3.4. Migrate data
     4.4. Load & move data
          4.4.1. Overview
          4.4.2. Best practices
     4.5. Integrate
          4.5.1. Overview
          4.5.2. SQL Database elastic query
     4.6. Monitor & tune
          4.6.1. Guidelines
          4.6.2. Columnstore compression
          4.6.3. Monitor
          4.6.4. Troubleshoot
     4.7. Develop data warehouses
          4.7.1. Overview
          4.7.2. Data warehouse components
          4.7.3. Tables
               4.7.3.1. Overview
               4.7.3.2. CTAS
               4.7.3.3. Data types
               4.7.3.4. Distributed tables
               4.7.3.5. Indexes
               4.7.3.6. Identity
               4.7.3.7. Partitions
               4.7.3.8. Replicated tables
               4.7.3.9. Statistics
               4.7.3.10. Temporary
          4.7.4. Queries
               4.7.4.1. Dynamic SQL
               4.7.4.2. Group by options
               4.7.4.3. Labels
          4.7.5. T-SQL language elements
               4.7.5.1. Loops
               4.7.5.2. Stored procedures
               4.7.5.3. Transactions
               4.7.5.4. Transactions Best Practices
               4.7.5.5. User-defined schemas
               4.7.5.6. Variable assignment
               4.7.5.7. Views
5. How-to guides
     5.1. Service features
          5.1.1. Restore a data warehouse - portal
          5.1.2. Restore a data warehouse - PowerShell
          5.1.3. Restore a data warehouse - REST API
     5.2. Security
          5.2.1. Enable encryption - portal
          5.2.2. Enable encryption - T-SQL
          5.2.3. Threat detection
     5.3. Load & move data
          5.3.1. Contoso public data
          5.3.2. Azure Data Lake Store
          5.3.3. BCP
          5.3.4. Data Factory
          5.3.5. AzCopy
          5.3.6. RedGate
          5.3.7. SSIS
     5.4. Integrate
          5.4.1. Configure SQL Database elastic query
          5.4.2. Add an Azure Stream Analytics job
          5.4.3. Use machine learning
          5.4.4. Visualize with Power BI
     5.5. Monitor & tune
          5.5.1. Analyze your workload
     5.6. Scale out
          5.6.1. Manage compute - portal
          5.6.2. Manage compute - PowerShell
          5.6.3. Manage compute - REST API
          5.6.4. Automate compute levels
6. Reference
     6.1. T-SQL
          6.1.1. Full reference
          6.1.2. SQL DW language elements
          6.1.3. SQL DW statements
     6.2. System views
     6.3. PowerShell cmdlets
7. Resources
     7.1. Azure Roadmap
     7.2. Forum
     7.3. Pricing
     7.4. Pricing calculator
     7.5. Feature requests
     7.6. Service updates
     7.7. Stack Overflow
     7.8. Support
     7.9. Videos
     7.10. Partners
          7.10.1. Business intelligence
          7.10.2. Data integration
          7.10.3. Data management

Web Content

Content Type
Build 2016 Workshops: Azure Data Services Lab

Online Training Content

Date Title
5/24/2017 Delivering a Data Warehouse in the Cloud
12/11/2015 Deliver an Elastic Data Warehouse as a Service

Tools

Tool Description
Scale Azure SQL Data Warehouse Scale Azure SQL Data WarehouseThis is a simple runbook that will allow you to scale your Azure SQL Data Warehouse.Depending on your goals with Azure SQL Data Warehouse, at time it is important to scale up and down depending the incoming workload or amount of data. In Automation,
Resume Azure SQL Data Warehouse Resume Azure SQL Data WarehouseThis is a simple runbook that will allow you to resume a Azure SQL Data Warehouse.Resuming as part of a ETL/ELT Data WorkflowWe commonly get asked if there is some way that an Azure SQL Data Warehouse can be resumed on a schedule. Using this, you ca

Videos

Date Title Length
1/8/2018 Azure SQL Data Warehouse compute optimized performance tier 0:08:58
11/26/2017 Cloud Tech 10 - 27th November 2017 - Jenkins with ACI, SQL DW with Functions and more! 0:08:45
11/17/2017 Optimize for compute: New Azure SQL Data Warehouse performance tier | T140 0:08:12
11/17/2017 Use Azure Databricks Notebooks for high-performance data pipelines | T165 0:09:38
11/15/2017 Use Azure Databricks Notebooks for high-performance data pipelines 0:09:37
11/15/2017 Optimize for compute: New Azure SQL Data Warehouse performance tier 0:08:11
11/15/2017 Hub-and-spoke data warehouses 0:09:42
11/15/2017 Introduction to Azure Databricks 0:03:38
11/15/2017 A lap around SQL Operations Studio, a new cross-platform SQL Server tool 0:11:05
11/14/2017 Azure Friday: Azure Analysis Services Visual Model Editor 0:10:13

Page 1 of 7