Learning Guide: Azure Data Solution Architecture Resources

Learning Guide: Azure Data Solution Architecture Resources

set of curated resources that will get you started. The resources are split into a number of sections that roughly follow the order of your design decisions.   With the wide variety of possible architectures, this post concentrates on a data reporting and analytics style of solution.

How to use Azure Data Factory V2 Sliding Windows

How to use Azure Data Factory V2 Sliding Windows

This article reviews the process of using Azure Data Factory V2 sliding windows triggers to archive fact data from SQL Azure DB. This process will automatically export records to Azure Data Lake into CSV files over a recurring period, providing a historical archive which will be available to various routines such as Azure Machine Learning, U-SQL Data Lake Analytics or other big data style workloads.

How To Automate SQL Azure Stored Procedures Using Runbooks and Email

How To Automate SQL Azure Stored Procedures Using Runbooks and Email

Minimize the impact on SQL Automation workflows when migrating to SQL Azure by automating stored procedures using Runbooks and E-mail.  This step by step tutorial and walkthrough will review a solution to provide scheduling via Azure Runbooks with integrated O365 email alerts.