Mastering Cloud Development using Microsoft Azure by Roberto Freato & Marco Parenzan

Author:Roberto Freato & Marco Parenzan [Freato, Roberto]
Language: eng
Format: azw3
Publisher: Packt Publishing
Published: 2016-06-28T04:00:00+00:00

The creation process of a SQL Data Warehouse (SQLDW) database is straightforward, and we do not cover it in this section (more information at https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-get-started-provision/). While SQLDW is a fully featured service, we do not investigate many of the features it provides. Instead, we just complete the previous scenario by adding a table and copying data into it.

Tip

There are some major differences between Azure SQL Database and Azure SQL Data Warehouse. In the latter, table features are limited, since SQLDW does not support primary keys, foreign keys, check/unique constraints, computed/sparse columns, and so on. Even the data types are limited to everyone except geometry, geography, hierarchy, id, image, text, ntext, (n)varchar(max) (to be used as (n)varchar(4000) instead), numeric, sql_variant, sysname, table, timestamp (to be used as datetime2), uniqueidentifier, XML, and UDTs.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.