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  
Blog
Blog
Blog
Blog
Blog
Blog
Video
Video
Podcast
Video
Blog
Blog
more...


Web Content

Azure Documentation

1. SQL Data Warehouse Documentation
2. Overview
     2.1. About SQL Data Warehouse
     2.2. Cheat sheet
3. Quickstarts
     3.1. Create and connect - portal
     3.2. Create - PowerShell
     3.3. Pause and resume compute
          3.3.1. Portal
          3.3.2. PowerShell
     3.4. Scale compute
          3.4.1. Portal
          3.4.2. PowerShell
          3.4.3. T-SQL
4. Tutorials
     4.1. 1 - Load WideWorldImporters
5. Concepts
     5.1. Service features
          5.1.1. MPP architecture
          5.1.2. Data warehouse units
          5.1.3. Scale-out, pause, resume
          5.1.4. Backup and restore
          5.1.5. Auditing
          5.1.6. Capacity limits
          5.1.7. Maintenance
          5.1.8. FAQ
     5.2. Security
          5.2.1. Overview
          5.2.2. Authentication
     5.3. Migrate to SQL Data Warehouse
          5.3.1. Overview
          5.3.2. Migrate schema
          5.3.3. Migrate code
          5.3.4. Migrate data
     5.4. Load & move data
          5.4.1. Overview
          5.4.2. Best practices
     5.5. Integrate
          5.5.1. Overview
          5.5.2. SQL Database elastic query
     5.6. Query performance
          5.6.1. Resource classes & workload management
          5.6.2. Memory & concurrency limits
          5.6.3. Columnstore compression
     5.7. Monitor
     5.8. Develop data warehouses
          5.8.1. Overview
          5.8.2. Data warehouse components
          5.8.3. Best practices
          5.8.4. Tables
               5.8.4.1. Overview
               5.8.4.2. CTAS
               5.8.4.3. Data types
               5.8.4.4. Distributed tables
               5.8.4.5. Indexes
               5.8.4.6. Identity
               5.8.4.7. Partitions
               5.8.4.8. Replicated tables
               5.8.4.9. Statistics
               5.8.4.10. Temporary
          5.8.5. Queries
               5.8.5.1. Dynamic SQL
               5.8.5.2. Group by options
               5.8.5.3. Labels
          5.8.6. T-SQL language elements
               5.8.6.1. Loops
               5.8.6.2. Stored procedures
               5.8.6.3. Transactions
               5.8.6.4. Transactions Best Practices
               5.8.6.5. User-defined schemas
               5.8.6.6. Variable assignment
               5.8.6.7. Views
     5.9. Troubleshoot
6. How-to guides
     6.1. Connect & query
          6.1.1. Overview
          6.1.2. Connection strings
          6.1.3. sqlcmd
          6.1.4. Query with SSMS
          6.1.5. Query with Visual Studio
          6.1.6. Install Visual studio
     6.2. Upgrade
     6.3. Restore
          6.3.1. Portal
          6.3.2. PowerShell
          6.3.3. REST API
     6.4. Security
          6.4.1. Enable encryption - portal
          6.4.2. Enable encryption - T-SQL
          6.4.3. Threat detection
     6.5. Load & move data
          6.5.1. New York taxi cab data
          6.5.2. Contoso public data
          6.5.3. Azure Data Lake Store
          6.5.4. Azure Databricks
          6.5.5. Data Factory
          6.5.6. SSIS
     6.6. Integrate
          6.6.1. Configure SQL Database elastic query
          6.6.2. Add an Azure Stream Analytics job
          6.6.3. Use machine learning
          6.6.4. Visualize with Power BI
     6.7. Monitor & tune
          6.7.1. Analyze your workload
     6.8. Scale out
          6.8.1. Automate compute levels
7. Reference
     7.1. T-SQL
          7.1.1. Full reference
          7.1.2. SQL DW language elements
          7.1.3. SQL DW statements
     7.2. System views
     7.3. PowerShell cmdlets
     7.4. REST APIs
8. Resources
     8.1. Azure Roadmap
     8.2. Forum
     8.3. Pricing
     8.4. Pricing calculator
     8.5. Feature requests
     8.6. Service updates
     8.7. Stack Overflow
     8.8. Support
     8.9. Videos
     8.10. Partners
          8.10.1. Business intelligence
          8.10.2. Data integration
          8.10.3. Data management

Web Pages

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
5/6/2018
ETL 2.0 - Data Engineering for developers
1:33:22
5/6/2018
Develop scalable analytical solutions with Azure Data Factory & Azure SQL Data Warehouse
1:33:22
5/3/2018
mssql-cli, an open source and cross-platform CLI for SQL Server
0:16:03
4/19/2018
Moving your Data Warehouse to the Cloud
0:20:26
3/5/2018
Introduction to Azure SQL Data Warehouse
0:01:14
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

Page 1 of 7