Creating a SQL Data Warehouse user with a specific resource class

In your data warehouse, you probably have multiple user groupings that perform different tasks: data loading; system tasks; querying; transformation and aggregations. Each of these groups has it’s own characteristics that can impact each other – a large data load might need a lot of memory while a user running a dashboard might not. Azure…


Adding AD Users and Security Groups to Azure SQL Data Warehouse

Azure offers you the ability to federate your corporate Active Directory to the cloud through Azure Active Directory Connect and Federation. The federation to the cloud allows you to authenticate against your Azure SQL Data Warehouse instance using your domain credentials. We often are asked how to create a user or security group in SQL…


Enabling TDE for Azure SQL Data Warehouse

Security is top of mind for everyone these days – securing your identity, securing your data. When you think about how you secure your data in the cloud you need to ensure that you understand how your data is stored and accessed. The Azure SQL Data Warehouse service utilizes Transparent Data Encryption (TDE) to encrypt your database,…

0

Loading Data to SQL Data Warehouse with the .NET SqlBulkCopy class

The Azure SQL Data Warehouse service is built on SQL Server and extends the capabilities of SQL Server for large scale relational data warehouse workloads. By leveraging SQL Server as the core relational component, customers are able to quickly take advantage of the large ecosystem of solutions and partner products to build their data story. Having…


The effects of column level compression

The Azure SQL Data Warehouse service is built on SQL Server and extends the capabilities of SQL Server for large scale relational data warehouse workloads. One of the areas of interest is how to you optimize for databases with terabytes or petabytes of data. One answer is Clustered Columnar indexes (CCI). A columnar index is…


Exporting to a single file in SQL Data Warehouse

Azure SQL Data Warehouse includes PolyBase – a technology that accesses and combines both non-relational and relational data from T-SQL . It allows you to run queries on external data in Azure blob storage and can be used for importing or exporting data. External data is exposed through a concept called an external table (see…


Scaling and scale monitoring SQL Data Warehouse via T-SQL

One of the key value propositions for the Azure SQL Data Warehouse service is the ability to re-size the compute power of the database very quickly. A common pattern is to re-size the cluster before a data load to decrease load and aggregation time, then re-size again to save costs when running report/analytic workloads. The operations…

2

Connecting a Linked Server to Azure SQL Data Warehouse

With such a diversity of components to a data workloads, it is common for customers to use SQL Server linked servers to connect to their Azure SQL Data Warehouse. Setting this up and executing queries from SQL Server to SQL DW is pretty straight forward. I’m using SQL Server 2016 RC2 (get it here) for…

2

How to determine the DWU setting for a SQL Data Warehouse

Azure SQL Data Warehouse service allows you to dynamically size the amount of compute resources within seconds. The setting for the amount of DWU (Data Warehouse Units = compute power) that is assigned can be viewed by opening the Azure Portal and viewing the database blade: The SQL team has now introduced a new DMV (sys.database_service_objectives) that…

0

Introducing Azure SQL Data Warehouse

On June 24, 2015, Microsoft launched the Azure SQL Data Warehouseservice – a new enterprise-class elastic data warehouse-as-a-service. You can read the official announcement on the Data Platform Insiders blog.

0