MCW_List.md

contents	Azure services and related products
App modernization	- Xamarin - Web APIs - PowerApps - Flow - Azure Storage - Azure Search - Azure Redis - Azure SQL Database - Azure Active Directory - API Management
Azure Blockchain	- Blockchain Workbench - IoT Hub - Service Bus - SQL Database - Key Vault - Event Grid - Application Insights
Azure security and management	- Azure Automation - Azure Monitor - Azure Log Analytics - Change Tracking - Update Management - Security Center - Service Map - Application Insights - Virtual machines
Azure security, privacy, and compliance	- Azure Virtual Machines and Networks with Network Security Groups - Virtual Private Networks (Point to Point, Site to Site) - Azure Web Apps - Azure SQL DB and corresponding security features (Threat Detection, TDE, Column Level Encryption, etc.) - Azure Storage Encryption - SQL Server Virtual Machines - Azure IAM - Azure Monitor and Log Analytics - Power BI - Azure Security Center - Azure Key Vault Integrations - Microsoft Azure Active Directory - Microsoft Intune - Conditional Access controls
Azure Stack	- Azure Stack - Azure App Services - Azure SQL Database - Azure Virtual Machines - Azure Functions
Business continuity and disaster recovery	- Azure Site Recovery - Azure Automation - Traffic Manager - SQL Server Always on Availability Groups - Azure App Services
Big Compute	TBD
Big data and visualization	- Azure Databricks - Azure Machine Learning services - Azure Data Factory (ADF) - Azure Storage - Power BI Desktop - Azure App Service
Building a resilient IaaS architecture	- Azure VMs - Azure Portal - Azure PowerShell - Azure Storage - Azure Active Directory - Azure Web Apps - Azure Virtual Networks - SQL Server - Operations Management Suite - Azure Backup
Containers and DevOps	- Azure Kubernetes Service (AKS) - Azure Container Registry - Docker - CosmosDB (including MongoDB API)
Cognitive services and deep learning	- Azure Machine Learning services - Cognitive Services - Computer Vision API - Text Analytics API - TensorFlow - Azure Monitor - Log Analytics - Azure VMs - Azure Application Insights - Azure Security Center
Continuous delivery in VSTS and Azure	- Azure App Service - Azure SQL Database - Application Insights - Azure Resource Manager - Visual Studio Team Services
Data Platform upgrade and migration	- Azure App Services - Azure Database Migration Service (DMS) - Azure SQL Database - Azure SQL Data Warehouse - Data Migration Assistant (DMA) - SQL Server 2008 R2 and 2017 - SQL Server Management Studio (SSMS) - SQL Server Migration Assistant (SSMA) - Visual Studio 2017
Enterprise-class networking	- Azure Virtual Machines - Azure PowerShell - Azure Virtual Networks - Azure Load Balancing - Network Virtual Appliances in Azure - Azure Site to Site connectivity - Azure Site to on-premises connectivity
Enterprise-ready cloud	- Azure VMs - Azure Portal - Azure PowerShell - Azure Storage - Azure Active Directory - Azure Web Apps - Azure Virtual Networks - SQL Server - Operations Management Suite - Azure Backup
Intelligent analytics	- Azure Cognitive Services - Azure Cosmos DB - Azure Search - Azure Event Hubs - Azure App Services - Azure Functions - Azure Service Bus - Azure Storage - Azure Stream Analytics - Microsoft Bot Framework - Power BI
Intelligent vending machines	- Azure App Services - Azure Blob Storage - Azure SQL Database - Cognitive Services Face API - Data Lake Store - IoT Hub - Microsoft Machine Learning Server - Power BI Desktop - R Server cluster on HDInsight - R Tools for Visual Studio 2017 - Visual Studio 2017
Internet of Things	- Azure Data Factory - Azure IoT Hub - Azure Stream Analytics - Azure HDInsight - Azure Spark & Spark SQL - Azure Storage - Power BI
IoT for business	- Azure Data Factory - Azure IoT Hub - Azure Stream Analytics - Azure HDInsight - Azure Spark & Spark SQL - Azure Storage - Power BI
Lift and shift/Azure Resource Manager	- Azure Portal - Azure Resource Manager - Azure Virtual Machines - Azure Virtual Networks - Azure Automation - Azure Storage - Azure SQL Database - Azure ExpressRoute - Azure Application Gateway - Azure Load Balancer - IIS - SQL Server - Azure Security
Linux lift and shift	- Azure VMs - Azure Portal - Azure CLI - Azure App Services on Linux - Azure Database for MySQL - Azure Resource Manager Templates - MySQL Workbench
Media AI	- Media Services - Logic Apps - Functions - Video Indexer API - App Services
Microservices architecture	- Azure Service Fabric - Azure Resource Groups - Azure API Management - Azure API Apps - Azure Active Directory - Azure Web Apps - Azure CosmosDB - Azure Storage - Azure Load Balancer - Azure Queues - Azure Functions
Migrate EDW to Azure SQL Data Warehouse	- Azure SQL Data Warehouse - Azure Data Factory v2 - Azure Analysis Services - Azure Storage - Power BI
Mobile app innovation	TBD
Modern cloud apps	- Microsoft SQL Server - Azure SQL Database - Azure SQL Data Warehouse - Resource Groups - Azure App Service Environment - Azure API Apps - Azure Web Apps - Azure Active Directory Premium - Application Insights - Azure Storage - Azure Functions - Azure Logic Apps - Azure Data Factory
Optimized architecture	- App Service - Web Apps - API Apps - Traffic Manager - Load Balancer - SQL Database
OSS DevOps	- Using GitHub, Git tools and GitHub desktop with Azure - Azure Virtual Machines - Azure Web Apps (Linux) - Azure Storage Accounts - Azure Database for MySQL - Azure Traffic Manager - Azure CDN - Jenkins
OSS PaaS and DevOps	TBD
SAP HANA on Azure	- SAP on Azure - SAP HANA - Azure VMs - Azure Active Directory - Azure Virtual Networks - Load Balancers - Linux Clustering
SAP NetWeaver on Azure	- SAP NetWeaver on Azure - SAP NetWeaver Application Servers - Azure VMs - Azure Active Directory - Azure Virtual Networks - Load Balancers - Failover Clustering
Securing PaaS	TBD
Serverless architecture	- Azure Functions - Azure Cognitive Services - Azure Event Grid - Application Insights - AzureCosmos DB - Logic Apps
SQL Server hybrid cloud	- SQL Server (On Prem) - Azure SQL Database - Azure Site Recovery - Azure Traffic Manager - Azure Storage
Windows Server and SQL Server 2008 R2 end of support planning	- Azure Migrate - Azure Database Migration Service - Azure Cost Management - Azure TCO Calculator

MCW_List.ps1

$outfile = "C:\temp\MCW-List.md"
[System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls12
$ret = (Invoke-WebRequest -uri "https://github.com/Microsoft/MCW" -UseBasicParsing).links | 
where {$_.href -like "https://github.com/Microsoft/MCW-*" -and $_.href -ne "https://github.com/Microsoft/MCW-workshop-topic-name" -and $_.href -ne "https://github.com/Microsoft/MCW-Template-Cloud-Workshop"}

$md = New-Object System.Text.StringBuilder

[void]$md.Append(@"
| contents | Azure services and related products |
|:---|:---|`n
"@
)

$builder = New-Object System.Text.StringBuilder

foreach ($line in $ret){
    $contents = (Invoke-WebRequest -Uri ($line.href.Replace("github.com", "raw.githubusercontent.com") + "/master/README.md")).RawContent.Split("`n") 
    if(($contents | Select-String "## Azure services and related products") -eq $null){
        [void]$builder.Append("TBD")
    }
    else{
        for ($i = ($contents | Select-String "## Azure services and related products").LineNumber;$contents.Length;$i++){
            if($contents[$i].StartsWith("#") -or $i -ge $contents.Length -1){
                break;
            }

            if ($contents[$i].Trim() -ne ""){
                if($builder.Length -gt 1){
                    [void]$builder.Append("<br>")
                }
                [void]$builder.Append($contents[$i])
            }
        }
    }
    [void]$md.Append(("|[{0}]({1})|{2}|`n" -f 
        $line.outerHTML.Substring($line.outerHTML.IndexOf(">") + 1, $line.outerHTML.Length - $line.outerHTML.IndexOf(">") -5),
        $line.href,
        $builder.ToString()
        )
    )
    [void]$builder.Clear()
}

$md.ToString() | Out-File -Encoding default -FilePath $outfile