In this article, we will learn how to work with PolyBase using Azure SQL DWH.   Read more...

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...

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...

In this article we will load data from a SQL Server on-premises to Azure SQL Data Warehouse  Read more...

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.  Read more...

This article will talk about preparing a runbook in Azure to schedule the report of space usage of databases in Azure environment  Read more...

In this article, see how to created shared functions using C# assemblies in U-SQL.  Read more...

Learn how U-SQL leverages C# to support flexible scalar functions in your scripts.  Read more...

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...

In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.  Read more...

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...

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...

In this article, we will show how to create reports in ASDW using SSRS  Read more...

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...

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...

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse  Read more...

We met SQL.ARRAY in the last step. Now say hello to SQL.MAP, which can store pairs of values.  Read more...

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...

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...

We will teach how to create a new SQL Azure Data Warehouse using Powershell  Read more...