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

Content with tags Azure, SQL Rss

   Items 1 to 17 of 17   
 

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 | 207 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 | 224 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 | 279 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 | 323 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 | 329 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 | 372 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 | 391 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 | 523 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 | 524 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 | 776 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 | 476 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 | 580 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 | 561 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,384 reads

Azure DWH part 1:Common questions about Azure SQL Data Warehouse

This article compiles some common questions and answers about Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2016/12/28 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 2,280 reads

A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database

In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.  Read more...
By Daniel Calbimonte 2016/08/22 | Source: SQLServerCentral.com | Category: command
Rating: |  Discuss |   Briefcase | 761 reads

Backup Strategy in Azure SQL?

Everybody says that the backup process in Azure SQL is very easy. Is that true? In this new article, we will show how to do it.  Read more...
By Daniel Calbimonte 2016/08/08 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 820 reads
   Items 1 to 17 of 17   
 
Tags
data (15)    
warehouse (15)    
import (2)    
server (2)    
services (2)    
studio (2)    
analysis (1)    
audit (1)    
backup (1)    
bash (1)    
bcp (1)    
cetas (1)    
cloud (1)    
command (1)    
ctas (1)    
database (1)    
export (1)    
factory (1)    
interface (1)    
line (1)    
mining (1)    
platform (1)    
point (1)    
polybase (1)    
powershell (1)    
recover (1)    
reporting (1)    
reporting services (ssrs) (1)    
restore (1)    
shell (1)    
threat (1)    
visual (1)