Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

External Article

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

Why Data Analysts Love PostgreSQL (and You Will Too!)

By

Data analysis is all about wrangling massive datasets. To do that efficiently, you need...

How to Connect Your WordPress Site to the Fediverse

By

Make it easier for your audience to engage with you by connecting your site...

What I learned volunteering at a children's summer camp

By

 "Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

AI Sings the Blues

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Sings the Blues

Visit the forum

Question of the Day

Disabling Indexes

I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?

See possible answers