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

Content with tag data Rss

   Items 1 to 20 of 60    Older >>
 

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 | 236 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 | 293 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 | 255 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 | 301 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 | 331 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 | 361 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 | 376 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 | 473 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 | 486 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 | 398 reads

A General Way to Maintain History Tables

You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.  Read more...
By Jefferson Elias 2017/06/30 (first published: 2015/09/28) | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 9,540 reads

Data Types

By Stanley Kapfunde 2017/06/06 | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,251 reads

The Rate of Change of Data

Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.  Read more...
By Phil Factor 2017/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

Data Types

By Stanley Kapfunde 2017/05/26 | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,182 reads

DML

By Stanley Kapfunde 2017/05/03 | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,161 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 | 751 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 | 458 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 | 539 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 | 520 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,274 reads
   Items 1 to 20 of 60    Older >>
 
Tags
azure (18)    
warehouse (17)    
sql (15)    
data mining (12)    
stairway series (8)    
microsoft (7)    
mining (4)    
server (4)    
editorial (3)    
backup (2)    
import (2)    
integration services (ssis) (2)    
polybase (2)    
search (2)    
services (2)    
studio (2)    
text (2)    
types (2)    
administration (1)    
agent (1)    
agent jobs (1)    
algorithm (1)    
analysis (1)    
analyze (1)    
automation (1)    
backup and restore (1)    
basic (1)    
bcp (1)    
big (1)    
blogs (1)    
bruteforce (1)    
certification (1)    
cetas (1)    
columns (1)    
competition (1)    
compression (1)    
ctas (1)    
data warehousing (1)    
database (1)    
database weekly (1)    
dba (1)    
delete (1)    
disaster recovery (dr) (1)    
domain (1)    
events (1)    
exam (1)    
export (1)    
factory (1)    
find (1)    
forecasting (1)    
friday poll (1)    
generate (1)    
hadoop (1)    
hdinsight (1)    
insert (1)    
lake (1)    
language (1)    
learning (1)    
linear (1)    
login (1)    
logistic (1)    
lookup (1)    
machine learning (ml) (1)    
maintenance (1)    
manipulation (1)    
mdx (1)    
merge (1)    
migration (1)    
miscellaneous (1)    
platform (1)    
powershell (1)    
privileges (1)    
processes (1)    
profiler (1)    
purge (1)    
query (1)    
recover (1)    
reference (1)    
reporting (1)    
reporting services (ssrs) (1)    
restore (1)    
security (1)    
series (1)    
sql saturday (1)    
sql server 2008 (1)    
ssas (1)    
static (1)    
string (1)    
table (1)    
task (1)    
testing (1)    
time (1)    
update (1)    
users (1)    
utility (1)    
visual (1)    
xmla (1)