Azure Synapse (formerly Azure SQL Data Warehouse)

What is Azure SQL Data Warehouse?

  • Article

Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.

2016-12-21

3,192 reads

What is Azure SQL Data Warehouse?

  • Article

Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.

2016-11-28

249 reads

Azure SQL Data Warehouse: Explaining the Architecture Through System Views

  • Article

The architecture of Azure SQL Data Warehouse isn't easy to explain briefly, but if you have some useful queries that access the management and catalog views, and diagrams that show how they relate together, you can very quickly get a feel for what is going on under the hood. By using and extending these queries that use these views, you can check on a variety waits, blocking, status, table distribution and data movement in ASDW.

2016-11-01

3,226 reads

Blogs

The End of PASS

By

I think our profession was the better for having a professional association, even if...

Platforms for Events

By

in my last post I wrote about thinking of the tools as being a...

Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop

By

There are a lot of hot phrases you’ve likely heard thrown around during various...

Read the latest Blogs

Forums

Migrating from 2008/2012 SQLserver to new server with sqlserver2019

By caz100

Anyone have a guide on how I migrate SSIS from sqlserver 2008 / 2012...

sp_execute and sp_executesql and sp_prepexec for the same statement

By scott.laird

From our software provided by a third party vendor, I am seeing the following:...

"Home PC" SQL instance

By ifthir

This may be a bit non-typical, but I am currently running SQL 2019 Developer...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers