2018-03-19 (first published: 2018-03-15)
396 reads
data
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
289 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
500 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
433 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)
3,448 reads
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,756 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,273 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
719 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
1,819 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,348 reads
Blogs
Daily Coping 1 Dec 2022
By Steve Jones
Today’s coping tip is to discover your artistic side. Design a friendly greeting card....
New Database Job – The 6 Month Plan
So, we made it through our first 90 days, things start getting tougher now...
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...
Forums
Replication Statistics
In Transactional Replication, create index and Alter index commands do not get replicated to...
The Last Valid Restore Time
Comments posted to this topic are about the item The Last Valid Restore Time
Getting started with ROUND() and Its Use Cases
Comments posted to this topic are about the item Getting started with ROUND() and...
Ask SSC