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,468 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,937 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
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Plan your 2026
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers