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

Content with tag Azure Rss

<< Newer    Items 21 to 40 of 180    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 | 277 reads

New Azure SQL Database Standard Tier Sizes

Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.  Read more...
By Additional Articles 2017/12/22 | Source: SQLPerformance.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,691 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 | 304 reads

How to use Azure SQL Database features and settings

Vitor Montalvao explains how to work with the basic configuration settings for a SQL Azure database from the Microsoft Azure portal itself.  Read more...
By Additional Articles 2017/12/15 | Source: MSSQLTips.com | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 3,770 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 | 319 reads

Should We Move to Azure?

This week Steve Jones asks about moving to the cloud and how interesting that might be to the community?  Read more...
By Steve Jones 2017/11/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 223 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 | 281 reads

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...
By Paul Brewer 2017/10/19 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 812 reads

SQL Server AlwaysOn Availability Groups Using an Azure Template

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.  Read more...
By Additional Articles 2017/10/18 | Source: MSSQLTips.com | Category: availability group (ag)
Rating: (not yet rated)  Rate this |   Briefcase | 3,058 reads

Network Configuration of SQL Server Always On Availability Groups in Azure

Implementing SQL Server Failover Clustering in Azure virtual machines differs in several aspects from its on-premises implementations. These differences reflect some of the unique characteristics of the storage and network infrastructure services in the Microsoft cloud environment. In this article, Marcin Policht looks at the networking aspects of clustered deployments of SQL Server 2016 in Azure.  Read more...
By Additional Articles 2017/10/11 | Source: Database Journal | Category: always on
Rating: (not yet rated)  Rate this |   Briefcase | 2,536 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 | 327 reads

Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell

Learn how PowerShell can be used to manage files and folders in your Data Lake.  Read more...
By Mike McQuillan 2017/10/04 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 479 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 | 369 reads

Implementing SQL Server Failover Clustering in Azure

Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.  Read more...
By Additional Articles 2017/09/29 | Source: Database Journal | Category: failover
Rating: (not yet rated)  Rate this |   Briefcase | 3,018 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 | 387 reads

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.  Read more...
By Mike McQuillan 2017/09/20 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 552 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 | 436 reads

Stairway to U-SQL Level 16: The Azure Data Lake Catalog

Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.  Read more...
By Mike McQuillan 2017/08/30 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 628 reads

EXPLAINING things

By Steve Jones 2017/08/29 | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 925 reads

Implementing Azure SQL Data Sync in the Azure Portal

Azure SQL Data Sync, which has been lingering in the Preview mode since its introduction seven years ago, no longer requires the use of the Azure classic portal; you can finally access it by using the current Azure portal. Marcin Policht steps you through the process of implementing Azure SQL Data Sync using this interface.  Read more...
By Additional Articles 2017/08/28 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,755 reads
<< Newer    Items 21 to 40 of 180    Older >>
 
Tags
u-sql (21)    
data (20)    
warehouse (18)    
sql (17)    
data lake (16)    
azure sql database (14)    
cloud (13)    
big data (12)    
powershell (12)    
blogs (8)    
stairway series (8)    
cloud computing (7)    
vm (6)    
editorial (5)    
migration (5)    
windows azure sql database (5)    
backup (4)    
cloud services (4)    
poll (4)    
administration (3)    
azure data factory (3)    
azure data lake (3)    
azure sql data warehouse (asdw) (3)    
backup and restore (3)    
c# (3)    
database (3)    
database weekly (3)    
automation (2)    
availability group (ag) (2)    
azure sql data sync (2)    
cosmosdb (2)    
data lakes (2)    
export (2)    
iaas (2)    
import (2)    
integration services (ssis) (2)    
learning (2)    
machine learning (ml) (2)    
mining (2)    
paas (2)    
partitioning (2)    
polybase (2)    
restore (2)    
scalar functions (2)    
security (2)    
server (2)    
services (2)    
sql data warehouse (2)    
sql server 2014 (2)    
ssds (2)    
studio (2)    
t-sql (2)    
visual studio (2)    
active directory (1)    
adf (1)    
adventureworks (1)    
always on (1)    
amazonrds (1)    
ams (1)    
analysis (1)    
architecture (1)    
audit (1)    
aws (1)    
azure iaas vm (1)    
azure sql managed instance (1)    
azure storage (1)    
azure stream analytics (1)    
backups (1)    
bacpac (1)    
bash (1)    
bcp (1)    
blob storage (1)    
books (1)    
catalog (1)    
certification (1)    
cetas (1)    
command (1)    
consultancy (1)    
cors (1)    
credentials (1)    
ctas (1)    
dac (1)    
data mining (1)    
data source (1)    
data storage (1)    
data tier application (1)    
data warehouse (1)    
database copy (1)    
diagnostics (1)    
differential (1)    
disaster recovery (dr) (1)    
dtu (1)    
elastic database jobs (1)    
elastic database pools (1)    
elastic query (1)    
event hubs (1)    
excel (1)    
explain (1)    
expressions (1)    
extended properties (1)    
external data (1)    
factory (1)    
failover (1)    
friday poll (1)    
full recovery mode (1)    
getting started (1)    
hdinsight (1)    
hekaton (1)    
high availability (ha) (1)    
indexing (1)    
interface (1)    
introduction (1)    
joins (1)    
kafka (1)    
lake (1)    
line (1)    
load balancing (1)    
loading patterns (1)    
login (1)    
maintenance plans (1)    
management studio (ssms) (1)    
metadata (1)    
microsoft (1)    
microsoft azure (1)    
networking (1)    
oracle (1)    
ordnance survey os data (1)    
partition scheme (1)    
performance (1)    
performance tuning (1)    
php (1)    
platform (1)    
point (1)    
point-in-time restore (1)    
privileges (1)    
queues (1)    
r statistics (1)    
recover (1)    
redgate (1)    
reporting (1)    
reporting services (ssrs) (1)    
runbook (1)    
sap (1)    
sap hana (1)    
scale (1)    
schemas (1)    
sharepoint 2010 (1)    
shell (1)    
sql dw (1)    
sql monitor (1)    
sql server (1)    
sql server 2012 (1)    
sql server 2016 (1)    
sql server analysis services (ssas) (1)    
sql server data services (1)    
sql.array (1)    
sql.map (1)    
ssas (1)    
storage (1)    
storage analytics (1)    
storage queues (1)    
stored procedure (1)    
survey (1)    
sys.database_files (1)    
sysadmin (1)    
table storage (1)    
tables (1)    
table-valued function (1)    
telemetry (1)    
testing (1)    
threat (1)    
transaction log (1)    
transparent data encryption (tde) (1)    
tvf (1)    
udt (1)    
user defined type (1)    
user groups (1)    
users (1)    
usql (1)    
views (1)    
visual (1)