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

Content with tag Azure Rss

   Items 1 to 20 of 155    Older >>
 

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 | 218 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 | 241 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 | 733 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...
Rating: (not yet rated)  Rate this |   Briefcase | 2,513 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: alwayson
Rating: (not yet rated)  Rate this |   Briefcase | 1,991 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 | 285 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: (not yet rated) |  Discuss |   Briefcase | 413 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 | 316 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 | 2,528 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

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 | 472 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 | 360 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 | 530 reads

EXPLAINING things

By Steve Jones 2017/08/29 | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 885 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,390 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 | 458 reads

Monitoring Azure Cloud and Hybrid Environments

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible.  Read more...
By Additional Articles 2017/08/16 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,460 reads

Introduction to Azure SQL Data Sync

The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly. There are however, some exceptions. The most prominent example in this category is likely Azure SQL Data Sync, which has remained in Preview since its introduction 7 years ago. Fortunately, there are signs that this service might be finally reaching production-ready state. In thius article, Martin Policht will introduce its main characteristics.  Read more...
By Additional Articles 2017/08/11 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 4,027 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
   Items 1 to 20 of 155    Older >>
 
Tags
u-sql (18)    
data (16)    
warehouse (14)    
data lake (13)    
sql (13)    
cloud (12)    
big data (11)    
azure sql database (10)    
blogs (8)    
powershell (8)    
stairway series (8)    
cloud computing (7)    
vm (5)    
windows azure sql database (5)    
backup (4)    
cloud services (4)    
editorial (4)    
migration (4)    
poll (4)    
administration (3)    
azure data lake (3)    
backup and restore (3)    
c# (3)    
database weekly (3)    
alwayson availability groups (2)    
automation (2)    
azure data factory (2)    
azure sql data sync (2)    
data lakes (2)    
database (2)    
iaas (2)    
import (2)    
integration services (ssis) (2)    
learning (2)    
machine learning (ml) (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)    
alwayson (1)    
amazonrds (1)    
ams (1)    
analysis (1)    
architecture (1)    
aws (1)    
azure iaas vm (1)    
azure sql data warehouse (asdw) (1)    
azure storage (1)    
azure stream analytics (1)    
backups (1)    
bacpac (1)    
bcp (1)    
blob storage (1)    
books (1)    
catalog (1)    
certification (1)    
command (1)    
consultancy (1)    
cors (1)    
cosmosdb (1)    
dac (1)    
data mining (1)    
data storage (1)    
data tier application (1)    
data warehouse (1)    
database copy (1)    
diagnostics (1)    
differential (1)    
disaster recovery (dr) (1)    
elastic database jobs (1)    
elastic database pools (1)    
event hubs (1)    
explain (1)    
export (1)    
expressions (1)    
extended properties (1)    
factory (1)    
failover (1)    
friday poll (1)    
full recovery mode (1)    
getting started (1)    
hekaton (1)    
high availability (ha) (1)    
indexes (1)    
interface (1)    
introduction (1)    
joins (1)    
lake (1)    
line (1)    
load balancing (1)    
loading patterns (1)    
login (1)    
maintenance plans (1)    
management studio (ssms) (1)    
microsoft (1)    
microsoft azure (1)    
mining (1)    
networking (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)    
reporting (1)    
reporting services (ssrs) (1)    
runbook (1)    
sap (1)    
sap hana (1)    
scale (1)    
schemas (1)    
sharepoint 2010 (1)    
sql dw (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)    
table storage (1)    
tables (1)    
table-valued function (1)    
telemetry (1)    
testing (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)