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)
7,665 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.
2019-09-13 (first published: 2017-10-23)
1,551 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,254 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
369 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
458 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
246 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
284 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
376 reads
Azure DWH part 24: Elastic queries
This article will explain what is an elastic query and show an example.
2018-01-23
1,099 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
355 reads
Blogs
SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the...
Our SQL Server 2019 Administration Inside Out Fun Author Survey
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
Forums
How to populate Temp table from Stored Procedure
I am trying to put the result of Stored Procedure execution into Temp Table:...
Web page listing SQL code
Hi, I'm building a web page for my users that will list example SQL...
Going from Failover Cluster Instance to Availability Group with Azure Replica
So if we have a FCI on premises, and want to add Availability Group...
Ask SSC