Episode 173 - SQL Data Warehouse

by Evan Basalik April 7, 2017

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.

Ellis Hiroki Butterfield

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 Azure DocumentDB. For more information about pricing, please visit the DocumentDB Pricing webpage. With this API, users can now achieve limitless scale with support for managed sharded collections. Standard data transfer rates apply for replication data transfer between regions. To learn more about this API, please visit the Azure Blog, the What is DocumentDB: API for MongoDB? documentation webpage, or the DocumentDB: Database-as-a-Service for MongoDB Developers video.

4 TB option for P11 and P15 databases in Azure SQL Database
Pricing | SQL Database webpage
Available immediately in public preview, customers using P11 and P15 databases in Azure SQL Database can now use up to 4 TB of included storage at no additional cost. For more information about pricing, please visit the SQL Database Pricing webpage. Increasing the available storage to 4 TB for P11 and P15 is an important step toward reaching our commitment to provide more storage across all performance tiers, giving customers more flexibility when choosing the best platform to run their applications. To learn more about the 4 TB option, please visit the SQL Database options and performance: Understand what's available in each service tier documentation webpage.

DirSync and Azure AD Sync end of support on April 13, 2017
We previously offered two synchronization tools for hybrid identity implementation to extend the reach of on-premises identities to cloud services: Windows Azure Active Directory Sync (DirSync) for single forest directory implementations and Microsoft Azure Active Directory Sync (Azure AD Sync) for multi-forest and other advanced capabilities. Azure Active Directory (Azure AD) Connect now replaces these older tools for all scenarios. DirSync and Azure AD Sync are no longer being updated. They have been deprecated and will not be supported after April 13, 2017. For more information on the transition to Azure AD Connect, please visit the Upgrade Windows Azure Active Directory Sync and Azure Active Directory Sync documentation webpage.


Filed Under: Podcast


Now on Spotify! Simply search for Azure Podcast and you will find it. Also available on YouTube and Amazon Music as well! You can also try reaching us via Mastodon.  

Podcast Clients

You can find us on iTunes, Spotify, XBOX Music and in most Podcast clients on Android. Or simply use the RSS feed link above and plug it into your Podcast client.


Love this podcast? Use this flyer to socialize it with your community.


<<  September 2023  >>

View posts in large calendar

Tag cloud