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

Content with tag data Rss

   Items 1 to 20 of 57    Older >>
 

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 | 250 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 | 301 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 | 343 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 | 345 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 | 450 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 | 461 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 | 380 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,527 reads

Data Types

By Stanley Kapfunde 2017/06/06 | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,242 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,172 reads

DML

By Stanley Kapfunde 2017/05/03 | Category: data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,152 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 | 736 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 | 445 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 | 515 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 | 487 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,186 reads

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2017/01/20 (first published: 2012/11/12) | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 52,520 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 | 1,789 reads

Data Mining Part 40: Big Data and Microsoft Data Mining

This article will introduce about big data and HDInsight and Hadoop.  Read more...
By Daniel Calbimonte 2016/05/10 | Source: SQLServerCentral.com | Category: big
Rating: |  Discuss |   Briefcase | 1,072 reads
   Items 1 to 20 of 57    Older >>
 
Tags
azure (16)    
warehouse (15)    
sql (13)    
data mining (12)    
stairway series (8)    
microsoft (7)    
server (4)    
editorial (3)    
mining (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)    
columns (1)    
competition (1)    
compression (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)