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
377 reads
Daniel Calbimonte
Azure DWH part 22: Dynamic Management Views
The DMV are very effective and important to administer ASDWH. In this article we will show some important DMVs.
2017-12-26
436 reads
Azure DWH part 21: Using Excel in ASDWH
This time we will show how to access to Azure SQL Data Warehouse using Excel.
2017-12-19
411 reads
8 Ways to Export SQL Results To a Text File
This tip will show eight ways to export the results of a query to a text file.
2017-10-06 (first published: 2016-10-26)
153,230 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
602 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,064 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
1,539 reads
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.
2017-08-21
1,463 reads
Azure DWH part 13: Load data using Data Platform Studio
In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse
2017-08-01
649 reads
Azure DWH part 12: Permissions, roles, logins and users
In this article we will show some common roles and queries related to Azure SQL Data Warehouse.
2017-07-25
2,540 reads
Blogs
Fun Fact: AWS RDS and system_health
Did you know that the system_health Extended Event session was running in your RDS...
Daily Coping 2 Jun 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
TSQL Tuesday #127 Invite – Non SQL Tips and tricks
How about for this months TSQL Tuesday let’s do another month of tips and...
Forums
SSIS How to split a single string into multiple columns using Derived Column
Hello, In my source Column having comma separated with text qualifier(“), I would need...
Licensing Audit Advice
Comments posted to this topic are about the item Licensing Audit Advice
Getting the Mean
Comments posted to this topic are about the item Getting the Mean
Ask SSC