Azure DWH part 14: PolyBase to access to Non relational data
In this article, we will learn how to work with PolyBase using Azure SQL DWH.
2020-12-25 (first published: 2017-08-21)
2,260 reads
Daniel Calbimonte
Azure DWH part 19: Backup and Restore SSAS
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
2020-05-29 (first published: 2017-10-23)
2,579 reads
Azure DWH part 18: Working with SQL Server Analysis Services
In this new article, we will learn how to create a cube extracting data from ADWH.
2020-05-22 (first published: 2017-10-09)
2,080 reads
Best Option for Working with Files in SSIS
This time we will compare different solutions to copy system folders using different SSIS tasks.
2019-11-22 (first published: 2017-05-09)
10,358 reads
Azure DWH part 20: Create External and Internal tables As Select
CTAS and CETAS are very important T-SQL features in ASDW. These features allow to create a table and fill with data based on a query.
2019-07-12 (first published: 2017-12-12)
2,917 reads
Azure DWH part 29: MicroStrategy Desktop with Azure
In this article, we will show how to connect MicroStrategy Desktop with ASDW.
2019-01-08
471 reads
Azure DWH part 28: The ASDW enemies
This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.
2018-06-26
501 reads
Azure DWH part 27: Creating your ASDW in Cloud Shell using Bash
In this article, we will show how to create an ASDW in Bash using the Cloud Shell.
2018-02-27
275 reads
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
299 reads
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
479 reads
Blogs
Daily Coping 13 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Everyone Run a SQL Saturday in 2021
By Steve Jones
With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....
Modern Data Warehouse & Reverse ETL
By James-Serra
An extension to the Modern Data Warehouse (MDW) that I have heard a bit...
Forums
Error installing SQL Server 2014 (both 32 & 64 bit versions)
During installation of SQL Express Server 2014 i have this error Title: Microsoft SQL...
Linked server to Access accdb database
Hi all We've got a linked server from SQL 2016 to an accdb...
performance tuning
Hi everyone, Any good suggestion to tune below query: --CREATE NONCLUSTERED INDEX nonclust_code...
Ask SSC