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,465 reads
Daniel Calbimonte
- Skills: ssas, ssis, ssrs, Power BI, Azure
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)
13,933 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)
4,313 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
585 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
541 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
354 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
375 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
548 reads
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
2018-01-23
3,346 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
505 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers