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 85    Older >>
 

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 | 241 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 | 290 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 | 317 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 | 352 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 | 361 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 | 459 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 | 471 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 | 387 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 | 331 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 | 500 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 | 442 reads

Azure DWH Part 8: Accessing Azure SQL Data Warehouse with C#

In this new article, we will learn how to access to our Azure DWH tables using C#.  Read more...
Rating: |  Discuss |   Briefcase | 454 reads

Comparing and Synchronizing Two Folders with Azure

In this article, we will compare two folders using PowerShell, the command prompt and other tools.  Read more...
By Daniel Calbimonte 2017/05/30 | Source: SQLServerCentral.com | Category: compare
Rating: |  Discuss |   Briefcase | 284 reads

Best option for working with Files in SSIS

This time we will compare different solutions to copy system folders using different SSIS tasks.  Read more...
Rating: |  Discuss |   Briefcase | 1,619 reads

Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS

In this article, we will show how to create reports in ASDW using SSRS  Read more...
By Daniel Calbimonte 2017/03/27 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 741 reads

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...
By Daniel Calbimonte 2017/03/20 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 453 reads

Azure DWH Part 5: How to work with the command line in Azure SQL DW

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse  Read more...
By Daniel Calbimonte 2017/03/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 522 reads

Azure DWH part 4: How to import data to Azure DWH using SSIS

In this article, we will use SSIS to import a CSV file to Azure SQL Data Warehouse.  Read more...
Rating: |  Discuss |   Briefcase | 852 reads

Azure DWH part 2: Get Started with Azure Data Warehouse

In this article, we will learn how to use Visual Studio to query Azure SQL Data Warehouse tables and how to create a new table.  Read more...
By Daniel Calbimonte 2017/01/25 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 1,222 reads

Azure SQL Data Warehouse with PowerShell

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...
By Daniel Calbimonte 2017/01/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 506 reads
   Items 1 to 20 of 85    Older >>