Azure DWH part 26: Creating your ASDW in Cloud Shell using PowerShell
In this article, we will show how to create an ASDW in PowerShell using the Cloud Shell.
2018-02-15
389 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
Azure DWH part 25: Auditing and threat detection
In this new article, we will show how to audit the Data Warehouse Activities.
2018-01-30
558 reads
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
2018-01-23
3,362 reads
Azure DWH part 23: Data Mining
SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.
2018-01-09
518 reads
Azure DWH part 22: Dynamic Management Views
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
2017-12-26
935 reads
Azure DWH part 21: Using Excel in ASDWH
This time we will show how to access to Azure SQL Data Warehouse using Excel.
2017-12-19
613 reads
8 Ways to Export SQL Results To a Text File
This tip will show eight ways to export the results of a query to a text file.
2017-10-06 (first published: 2016-10-26)
503,723 reads
Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW
In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.
2017-10-03
831 reads
Azure DWH part 16: BCP to import and export data
In Azure SQL Data Warehouse we can use BCP to export or import the data. In this article, we will show how to do it.
2017-09-26
2,235 reads
Azure DWH part 15: PolyBase and Azure Data Lake
In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.
2017-09-05
2,630 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers