Azure DevOps Services

Microsoft have announced new Azure DevOps services than span the breadth of the development lifecycle to help developers ship software faster and with higher quality. Azure DevOps includes:

Azure Pipelines

CI/CD that works with any language, platform, and cloud. Connect to GitHub or any Git repository and deploy continuously. 

Azure Boards

Powerful work tracking with Kanban boards, backlogs, team dashboards, and custom reporting. 

Azure Artifacts

Maven, npm, and NuGet package feeds from public and private sources. 

Azure Repos

Unlimited cloud-hosted private Git repos for your project. Collaborative pull requests, advanced file management, and more. 

Azure Test Plans

All in one planned and exploratory testing solution. 

Cheat sheet for Azure SQL Data Warehouse

The data warehouse design process is summarised in this diagram.

The cheat sheet provides a useful way demonstrate best practices when building Azure SQL Data Warehouse solutions. The various links within the cheat sheet provide more information.

Azure SQL Data Warehouse Workload Patterns and Anti-Patterns

Azure Data Lake Store

Data migration

Data loading

Extract, Load, and Transform (ELT) process.

Replicated tables 

Distributed tables

Indexes

Partitions

Statistics

Resource classes and concurrency

Manage compute resources. 

Typical architectures that take advantage of SQL Data Warehouse

Implementing Microsoft Azure Infrastructure Solutions

Here are a whole set of links to kick start your learning of Microsoft Azure services. 

Introduction video

Changes to computer thinking - Stephen Fry explains cloud computing 

Two Portals

• ASM Classic (Azure Service Manager) 
• ARM New portal (Azure Resource Manager) 

Tools

• Microsoft Azure Storage Explorer
• Azure PowerShell cmdlets

Free EBooks

• Microsoft Azure Essentials: Fundamentals of Azure via Microsoft Press
• Building Cloud Apps with Microsoft Azure via Microsoft Press

Reading to enable the creation of an end to end solution

• Resource Manager Deployment Model
• VPN Gateway how to point to site recovery portal
• Virtual Machines
• Virtual Machines scale sets overview
• Backup configure vault
• Site recovery hyper v site to Azure
• Storage introduction
• What is PaSS
• Traffic Manager Overview
• SQL Database PaSS vs SQL Server
• SQL Database elastic pool
• Cloud Services
• Cloud services how to scale portal
• Active directory what is
• Automation
• Security Centre Introduction
• Log Analytics Overview
• Dev Test Lab
• Virtual Machines Windows Migration Classic Resources Manager

Other Learning Resources: 

• Microsoft Azure Fundamentals via MVA 
• Establish Microsoft Azure IaaS Technical Fundamentals via MVA 
• Dive Deep into Networking Storage and Disaster Recovery Scenarios via MVA 
• Optimize Workload Architecture and Administration Capabilities Within Azure via MVA 
• Azure Friday videos –short videos hosted by Scott Hanselman.  
• Channel9 Microsoft Azure videos –videos on Channel9 
• Microsoft online Azure courses openedx courses