Azure

Learn about options for ingestion and processing within Azure Data Lakehouse using Data Factory, Databricks, Logic Apps, Stream Analytics and more.

In this article we cover various methods to export an Azure SQL Database so that it can restored and used somewhere else.

Learn about the Azure SQL DB purchasing model and how to change from DTU to vCore or vice versa.

Learn methods and applications to create and support your Data Lakehouse ELT design, development, scheduling, and monitoring of pipelines in Azure.

In this article we look at how to setup transparent data encryption for SQL Server data files stored in Azure storage, but keeping the TDE keys local.

The article covers Azure data resource and what it does at a surface level to help you get started with all of the data services Azure has to offer.

In this article we will explore how to get started with Azure Purview and then explore some of the features within Purview Studio.

This article explore things to consider when designing an Azure Data Lake Storage Gen2 account such as data lake layers, zones, files, and security.

Setup Azure SQL Data Sync to synchronize and replicate data from various locations including Azure SQL Database, cloud and on-premises databases.

Learn how to create an Azure VM image that can be used to quickly deploy new Azure VMs that are preconfigured based on your image settings.

Learn how to create templates in Azure to quickly deploy new VMs based on pre-defined templates you create or templates that exist in the Azure Marketplace.

In this article we look at how to upload and download files from Azure Storage using SQL Server Integration Services.

In this article we continue the series on how to build a Windows Failover Cluster for SQL Server on Azure using Storage Spaces Direct.

In this first part of this series we look at how to build a SQL Server Failover Cluster on Azure using Storage Spaces Direct for the storage.

The following article will demonstrate how to turn a Databricks notebook into a Databricks Job and then execute that job through an API call.

Learn the five steps to perform Azure resource reporting with Power BI in order to embed the reports in dashboards for stakeholders.

In this article we look at how we can use an Azure SQL managed instance to host Reporting Services report server databases.

In this tip we look at how to setup a scheduled purge job to delete data from an Azure SQL Database using Elastic Jobs.

This article will deep dive into the cluster creation UI and enable the reader to build the right cluster for Azure Databricks.

In this article I cover some best practices for provisioning a Modern Data and Analytics Platform using the Az.Blueprint cmdlet in PowerShell.

In this article we look at how we can apply pivot transformations to Spark streaming data frames.

Learn how to setup Azure Log Analytics to collect information about different Azure resources for monitoring performance related issues.

Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.

In this article we take a look at setting up and configuring MySQL to run on Azure along with some performance metrics for this database platform running on Azure.