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

Content with tag Azure Rss

<< Newer    Items 21 to 40 of 181    Older >>
 

How SQL Monitor Monitors Azure-based SQL Server Failover Cluster Instances

This article will show you how to set up SQL Monitor to monitor Azure-based clustered instances right alongside your on-premise clusters.  Read more...
By 2018/01/10 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,235 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

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,776 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 | 305 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,842 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 | 321 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 | 283 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 | 814 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,134 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,605 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 | 328 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 | 483 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

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,040 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 | 390 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 | 558 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 | 439 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 | 635 reads

EXPLAINING things

By Steve Jones 2017/08/29 | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 928 reads
<< Newer    Items 21 to 40 of 181    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)    
json (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)