Azure Data & Analytics is a category of cloud-based services offered by Microsoft Azure. Various tools enable organizations to store, process, analyze, and visualize their data in the cloud. These services include Azure SQL Database, Azure Cosmos DB, Azure Data Lake Storage, Excel Online, Azure Machine Learning Studio, and Power BI.
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.
One of the biggest questions you will be asked as you investigate moving workloads to the cloud is, How Much is this going to cost? This article will review a process, resources and questions you need to answer to provide realistic cost estimates to get more out of the Azure Pricing Calculator
There is an odd error when trying to install SQL Server Data Tools (SSDT), either as a stand-alone, or adding to an instance of Visual Studio. I had the same setup failure, no matter what configuration I was using.
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.
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.
I added R to my toolkit and have had great success using it on many projects, for not only discovery but also for visualizations. R provides many packages and functions that let you perform data discovery over a data set.
