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

In this new article, we will learn how to create a cube extracting data from ADWH.  Read more...

Learn how PowerShell can be used to manage files and folders in your Data Lake.  Read more...

In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.  Read more...

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

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

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

In this article, we will learn how to query a csv file stored in the Data Lake using PolyBase.  Read more...

Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.  Read more...

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

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