Azure SQL Data Warehouse (ASDW)

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

External Article

Getting started with Azure SQL Data Warehouse

  • Article

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.

2016-05-02

3,466 reads

Technical Article

RE: Deletion of SQL Logins

  • Reply

I suppose that you first deleted the accounts from active directory and then try to delete them from SQL Server?If so:Try to get hold on to the SUID of these deleted users. The suid is kept in the database.To avoid this kind of trouble:Make a active directory group, where each account from active directory is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-16

Technical Article

SQL Query to Create View

  • Topic

Sorry if I put this in the wrong category.  This is my first visit. I have the following SQL I created but I am missing something.  I am combining 5 table to 1 view.  In the table addrline it might contain 1, 2 or more lines for one person with the same column name "text" having […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-04

7 reads

Technical Article

RE: Best Practices for Database Design

  • Reply

Why prefix views with a 'v'? Tables and views are identical as far as clients are concerned -- there is no reason to muddle your data model with that prefix. Also, please define "reference". At what point does a "reference" table cease being for a reference? Can a non-reference table become a reference? Will you […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-04-05

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers