SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Daniel Calbimonte

SQLServerCentral.com profile

   Items 1 to 20 of 94    Older >>
 

Azure DWH part 28: The ASDW enemies

This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse.  Read more...
Rating: |  Discuss |   Briefcase | 374 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.  Read more...
By Daniel Calbimonte 2018/02/27 | Source: SQLServerCentral.com | Category: bash
Rating: |  Discuss |   Briefcase | 210 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.  Read more...
By Daniel Calbimonte 2018/02/15 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 259 reads

Azure DWH part 25: Auditing and threat detection

In this new article, we will show how to audit the Data Warehouse Activities.  Read more...
By Daniel Calbimonte 2018/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 228 reads

Azure DWH part 24: Elastic queries

This article will explain what is an elastic query and show an example.  Read more...
By Daniel Calbimonte 2018/01/23 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 468 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.  Read more...
By Daniel Calbimonte 2018/01/09 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 282 reads

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.  Read more...
Rating: |  Discuss |   Briefcase | 220 reads

Azure DWH part 21: Using Excel in ASDWH

This time we will show how to access to Azure SQL Data Warehouse using Excel.  Read more...
Rating: |  Discuss |   Briefcase | 308 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.  Read more...
By Daniel Calbimonte 2017/12/12 | Source: SQLServerCentral.com | Category: ctas
Rating: |  Discuss |   Briefcase | 329 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.  Read more...
By Daniel Calbimonte 2017/10/23 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 286 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.  Read more...
By Daniel Calbimonte 2017/10/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 332 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.  Read more...
By Daniel Calbimonte 2017/10/03 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 377 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.  Read more...
By Daniel Calbimonte 2017/09/26 | Source: SQLServerCentral.com | Category: bcp
Rating: |  Discuss |   Briefcase | 394 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.  Read more...
By Daniel Calbimonte 2017/09/05 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 450 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.   Read more...
By Daniel Calbimonte 2017/08/21 | Source: SQLServerCentral.com | Category: polybase
Rating: |  Discuss |   Briefcase | 526 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  Read more...
By Daniel Calbimonte 2017/08/01 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 528 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.  Read more...
By Daniel Calbimonte 2017/07/25 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 447 reads

Azure DWH part 11: Data Warehouse Migration Utility

There is a new utility to import data from SQL Server on premises or Azure SQL to Azure SQL Data Warehouse (ASDW)  Read more...
Rating: |  Discuss |   Briefcase | 380 reads

Azure DWH part 10: WPF and Azure SQL Data Warehouse

In this article, we will show how to create a WPF application and show how to insert data to ASDW.  Read more...
Rating: |  Discuss |   Briefcase | 533 reads

Azure DWH part 9: Azure PHP and ASDW

In this new Azure Data Warehouse article, we will show how to insert data and retrieve it using PHP.  Read more...
By Daniel Calbimonte 2017/05/22 | Source: SQLServerCentral.com | Category: php
Rating: |  Discuss |   Briefcase | 487 reads
   Items 1 to 20 of 94    Older >>