The guys have a great chat with Ellis Butterfield, a PM in the Azure team, on the nuts and bolts behind the SQL Data Warehouse service. Media file: http://azpodcast.blob.core.windows.net/episodes/Episode173.mp3 Other updates: Azure MFA cloud based protection for on-premises VPNs is now in public preview! Azure MFA provides a hybrid multifactor authentication solution for Windows 10 VPN. Using a first-party auth extension, an on-premises NPS server provides the primary auth, forwarding RADIUS-encrusted REST calls to an Azure MFA tenant for the secondary authentication. Azure Service Bus: Hybrid Connections feature of Azure Relay generally available Pricing | Service Bus webpage The Azure Relay Hybrid Connections feature in Azure Service Bus is generally available. For more information about pricing, please visit the Service Bus Pricing webpage. Hybrid Connections lets you use open standards like HTTPS and WebSockets to securely connect resources sitting behind a firewall on-premises with other cloud-based services or assets. To learn more about this service, please visit the Service Bus webpage. Azure HDInsight available in additional regions Pricing | HDInsight webpage Azure HDInsight is now available in the West US 2 region, and Azure HDInsight for Linux is also now available in the Central India region. For more information about pricing, please visit the HDInsight Pricing webpage. HDInsight is a fully managed cloud Hadoop offering that provides open-source analytic clusters for Spark, Hive, MapReduce, HBase, Storm, Kafka, and R Server, backed by a 99.9 percent service-level agreement (SLA). To learn more about this service, please visit the HDInsight webpage. Azure Advisor generally available Now generally available, Azure Advisor will continue to offer access to Advisor recommendations at no additional cost. Advisor analyzes your resource configuration and usage, and then recommends solutions that can help you improve high availability, security, performance, and cost-effectiveness of your Azure resources. To learn more about this service, please visit the Advisor webpage. To begin using it, please visit the Azure portal. L-Series instances in Azure Virtual Machines generally available, price reduced Pricing | Virtual Machines webpage L-Series instances in Azure Virtual Machines are now generally available in the following regions: East US 2, West US, Southeast Asia, Australia East, Canada Central, and Canada East. Effective with subscription cycles starting on or after April 1, 2017, prices are reduced up to 69 percent on the now generally available L-Series instances in Virtual Machines. These price reductions vary by region and are applicable in all regions where L-Series Virtual Machines are available today. For more information about pricing, please visit the Virtual Machines Pricing webpage. To learn more about this service, please visit the Virtual Machines webpage. Azure DocumentDB: Aggregate support, Emulator in Docker, and Azure Search integration Pricing | DocumentDB webpage Azure DocumentDB now supports aggregates at global scale in public preview. DocumentDB has also reduced the number of request units (RUs) charged for queries by 20 percent, to serve more queries per second for the same price. For more information about pricing, please visit the DocumentDB Pricing webpage. The DocumentDB query engine has built-in support for SQL aggregate operators COUNT, MIN, MAX, AVG, and SUM. For more information, please visit the Aggregate Functions section of the SQL query and SQL syntax in DocumentDB documentation webpage and the Use the Azure DocumentDB Emulator for development and testing documentation webpage, and for information about Azure Search integration, visit the Azure Blog. Azure DocumentDB: API for MongoDB generally available Pricing | DocumentDB webpage The API for MongoDB is now generally available, inheriting the same 99.99 percent financially backed service-level agreement (SLA) as