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

Content with tag Azure Rss

   Items 1 to 20 of 132    Older >>
 

Azure Networking for SQL Server DBAs

The network is important to any DBA because so much performance is dependent on I/O, because of the importance of security, and ensuring that everyone get the right access. DBAs generally need not become experts in Azure networks, but it helps to understand the concepts and language. If you are running a SQL Server Virtual Machine in Azure, then VNets, Subnets, Network Security Groups, VNet peering and VPN gateways are all worth knowing about in order to to keep SQL Servers running smoothly.  Read more...
By Additional Articles 2017/05/23 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 2,066 reads

Azure Machine Learning - Your first experiment

In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.  Read more...
By Daniel Calbimonte 2017/05/05 (first published: 2016/06/14) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 3,995 reads

Azure Load Balancers and SQL Server

Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in Azure, whether it is for AlwaysOn Availaiblity Groups, Failover Clustered Instances, or any other highly-available solution. Azure load balancing works out the location of the availability group, and routes traffic there. The load balancer detects a failure, and routes traffic to the new primary replica. Joshua Feierman gives an overview of what is required.  Read more...
By Additional Articles 2017/05/02 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 3,217 reads

How to setup a tabular data model in SSAS Azure

Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.  Read more...
By Additional Articles 2017/04/26 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,032 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 | 668 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 | 391 reads

Managing Azure SQL Database Recovery

Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.  Read more...
By Additional Articles 2017/03/14 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,751 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 | 436 reads

Stairway to U-SQL Level 13: SQL.MAP

We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.  Read more...
By Mike McQuillan 2017/03/01 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 927 reads

Introduction to SAP HANA on Azure

Microsoft and SAP share a long history of working together on a variety of interoperability solutions, including SAP Fiori and Office 365. In recent years, this trend has been exemplified by advancements in support for SAP-based solutions on Microsoft Azure. Marcin Policht provides an overview, focusing in particular on support for SAP HANA on Azure.  Read more...
By Additional Articles 2017/02/17 | Source: Database Journal | Category: sap hana
Rating: (not yet rated)  Rate this |   Briefcase | 3,498 reads

How to Build Your First SQL Server Virtual Lab in Windows Azure

If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.  Read more...
By Additional Articles 2017/02/13 | Source: SimpleTalk | Category: azure
Rating:  Rate this |   Briefcase | 4,705 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 | 447 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 | 952 reads

Stairway to U-SQL Level 12: SQL.ARRAY and CROSS APPLY EXPLODE

U-SQL introduces two new data types - SQL.ARRAY and SQL.MAP. Here, we look at what we can do with SQL.ARRAY and the CROSS APPLY EXPLODE expression.  Read more...
By Mike McQuillan 2017/01/11 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,480 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,192 reads

Stairway to U-SQL Level 11: Stored Procedures

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.  Read more...
By Mike McQuillan 2016/11/16 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,424 reads

Automatically upload SQL Server Database Backups to Azure with Integration Services

Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.  Read more...
By Additional Articles 2016/10/18 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 3,655 reads

Stairway to U-SQL Level 10: Table-Valued Functions and UDTs

Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.  Read more...
By Mike McQuillan 2016/10/12 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,679 reads

Stairway to U-SQL Level 9: Views and C# Expressions

Learn how U-SQL views can hide complexity and use C# expressions, providing powerful ways to format and return your data.  Read more...
By Mike McQuillan 2016/10/05 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,095 reads

Stairway to U-SQL Level 8: Joining Tables in U-SQL

U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.  Read more...
By Mike McQuillan 2016/09/14 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,583 reads
   Items 1 to 20 of 132    Older >>
 
Tags
u-sql (13)    
cloud (10)    
data lake (10)    
azure sql database (8)    
big data (8)    
blogs (8)    
data (8)    
sql (8)    
cloud computing (7)    
powershell (7)    
warehouse (6)    
vm (5)    
windows azure sql database (5)    
cloud services (4)    
editorial (4)    
migration (4)    
poll (4)    
stairway series (4)    
administration (3)    
backup (3)    
backup and restore (3)    
database weekly (3)    
azure data factory (2)    
data lakes (2)    
iaas (2)    
learning (2)    
paas (2)    
partitioning (2)    
sql data warehouse (2)    
sql server 2014 (2)    
ssds (2)    
visual studio (2)    
active directory (1)    
adf (1)    
adventureworks (1)    
amazonrds (1)    
ams (1)    
architecture (1)    
automation (1)    
aws (1)    
azure data lake (1)    
azure iaas vm (1)    
azure sql data warehouse (asdw) (1)    
azure storage (1)    
azure stream analytics (1)    
backups (1)    
bacpac (1)    
blob storage (1)    
books (1)    
c# (1)    
certification (1)    
command (1)    
consultancy (1)    
cors (1)    
dac (1)    
data mining (1)    
data storage (1)    
data tier application (1)    
data warehouse (1)    
database (1)    
database copy (1)    
diagnostics (1)    
differential (1)    
disaster recovery (dr) (1)    
documentdb (1)    
elastic database jobs (1)    
elastic database pools (1)    
event hubs (1)    
expressions (1)    
extended properties (1)    
friday poll (1)    
full recovery mode (1)    
getting started (1)    
high availability (ha) (1)    
indexes (1)    
integration services (ssis) (1)    
interface (1)    
introduction (1)    
joins (1)    
line (1)    
load balancing (1)    
loading patterns (1)    
machine (1)    
machine learning (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 tuning (1)    
php (1)    
point (1)    
point-in-time restore (1)    
queues (1)    
recover (1)    
reporting (1)    
reporting services (ssrs) (1)    
restore (1)    
sap (1)    
sap hana (1)    
scale (1)    
schemas (1)    
security (1)    
server (1)    
services (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 server integration services (ssis) (1)    
sql.array (1)    
sql.map (1)    
storage (1)    
storage analytics (1)    
storage queues (1)    
stored procedure (1)    
studio (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)    
t-sql (1)    
tvf (1)    
udt (1)    
user defined type (1)    
user groups (1)    
usql (1)    
views (1)    
visual (1)