We are pleased to announce the general availability of Clustered and NonClustered Columnstore indexes for Standard databases in the S3 and above pricing tiers. These features will enable a number of new and valuable scenarios:
Functional dev/test for columnstore based applications, without needing to pay for Premium tier databases for testing purposes. (Of course performance testing should always be done at the target performance configuration.) Deploying applications with columnstore-based storage which do not have the mission critical performance and availability requirements found in Premium tier database requirements. Application vendors can now develop an application which leverages columnstore functionality and deploy it on both Standard and Premium performance tiers. Columnstore advantages
Columnstore indexes are designed to be extremely efficient for queries which do scans and aggregations across millions and billions of rows of data. They are fundamentally different structures, which physically group data by column, rather than by row. In OLTP-style workloads, queries typically access one, or a few rows at a time, making traditional index structures the most efficient access path. For analytic queries, organizing data by column means that we only need to read the data for those columns involved in a query, and other columns never need be
To celebrate PlayFab’s first year at GDC as part of the Microsoft family, we are launching a special offer for developers featuring more than $2,500 worth of PlayFab, App Center, and Azure services free for up to a year.
This promotion is limited to the first 1,000 registrants and ends on May 31, 2018, so visit the promotion page now to claim the services.
What can I do with these free services?
Build, test, and monetize your next hit mobile game with a complete toolset across PlayFab, App Center, and Azure:
Use PlayFab services to build your game faster– then engage, retain, and monetize players through LiveOps tools.
Access all core PlayFab services up to 100,000 MAU, including player authentication, data storage, real-time analytics, optional data warehousing, segmentation tools, tournaments and leaderboards, remote config, triggered actions, and more. Build with the same services that power 80 million monthly active players across 1,200+ games. App Center
Use App Center to test your iOS and Android games on thousands of real devices in the cloud, distribute to beta testers, and monitor real-world usage with crash and analytics data.
Test on 3,300+ real iOS and Android devices in the cloud, with 440+
Today, I am excited to announce the general availability (GA) of Azure Database for MySQL and Azure Database for PostgreSQL. The GA milestone means that, starting today, these services are bringing the community versions of MySQL and PostgreSQL with built-in high availability, a 99.99% availability SLA, elastic scaling for performance, and industry leading security and compliance to Azure.
Since we started the preview of MySQL and PostgreSQL on Azure in May 2017, we have accomplished a lot, increasing compute scale up to 32 vCores, offering a new Memory Optimized tier, ability to scale storage on-line independent of compute without impact to application performance, allowing greater flexibility in backup storage options, and achieving industry compliance with ISO, SOC, and HIPAA. We will be compliant with the General Data Protection Regulation (GDPR) when enforcement begins on May 25, 2018. In addition, with availability in 22 regions worldwide, these services are truly global. The reach of the services remains a key focus for us, and we continue to work on providing availability across all 40+ Azure regions, which we expect to deliver in coming months. In the video below, my colleague Sunil Kamath shares some of the key benefits of adopting Azure database
Gaining insights to customer traffic is imperative in providing a best in class user experience. With Traffic View, a new capability in Azure Traffic Manager, you can get rich information and powerful visualization that captures a heatmap of users’ experience. This allows you to understand traffic patterns globally and zoom in on specific geographic locations.
Improve performance by leveraging Traffic View
Today, we are happy to announce the general availability (GA) of Traffic View, announced in public preview last fall. Since then we have received enthusiastic adoption and feedback. Insights provided by Traffic View include geographic location of your user base, latency experienced from these locations, and volume of traffic. These insights can then be used to optimize placement of your workloads in various Azure regions. You can use the visualizations provided through the Azure portal or you can download the raw data to do custom analysis with Power BI or similar tools.
To provide finer granularity, Traffic View can now be enabled at a profile level rather than subscription level. Starting this week, as we rollout the changes, you will have to re-enable Traffic View for the profiles you need. Traffic View will be charged starting May 1,
We see strong customer interest in the Blockchain solutions that are available on the Azure Marketplace. As customers build production Blockchain scenarios, we understand that network reliability and health monitoring become increasingly important. Today, we are excited to announce significant enhancements to our Ethereum on Azure offering. These improvements are the first of a series of releases designed to enable production-ready consortium Blockchain networks suited for enterprise scenarios.
Through our customer engagements, we have identified and rolled out the following improvements:
High availability of Blockchain network presence: As a participant on a decentralized network, your nodes’ presence in the consensus process is critical towards achieving a fair and secure network. To ensure high-availability, we’ve incorporated cross-region Azure VM Scale Sets (Azure VMSS) and Azure Managed Disks. In the case that a node goes down, Azure VMSS will automatically recover the node, and join it back to the Ethereum network. As active nodes may change over time, we take care of maintaining an accurate boot-node list, allowing other members to join the network. Simplified deployment experience: Choosing the right network topology for your scenario can be difficult. We’ve invested significant effort into consolidating the various Ethereum network topologies into one experience, which allows
Today, we are excited to announce the support for backup of large disk VMs and set of improvements aimed at reducing the time taken for backup and restore. These set of improvements and large disk support is based on a new VM backup stack and are available for both managed and unmanaged disks. You can seamlessly upgrade to this new stack without any impact to your on-going backup jobs and there is no change to how you setup backup or restore.
This announcement combines multiple feature improvements:
Large disk support – Now you can backup VMs with disk sizes up to 4TB(4095GB), both managed and unmanaged. Instant recovery point – A recovery point is available as soon as the snapshot is done as part of the backup job. This eliminates the need to wait to trigger restore till data transfer phase of the backup is completed. This is particularly useful in scenarios where you want to apply a patch. Now you can go ahead with the patch once the snapshot phase is done and you can use the local snapshot to revert back if the patch goes bad. This is analogous to checkpoint solution offered by Hyper-V or VMware with
Spring fans, we are excited to announce full support of Spring Boot 2.0 on the Spring Boot Starters for Azure, already available on Spring Initializr. Plus, with new Java and Spring extensions for Visual Studio Code you can build production-ready apps and easily deploy them to the cloud.
Integrate Azure services with Spring Boot 2.0 apps
Spring Initializr enables developers to handle the dependency management and make the bootstrapping process for Spring projects much easier. Today, we’re announcing that the Azure Starters have been updated to support Spring Boot 2.0, so you can easily integrate cloud services with your application.
All of the Azure Spring Boot Starters are available on Spring Initializr:
Azure Support: Provides support for the Azure services below, plus all other services currently available via Spring Boot Starters. Azure Active Directory: Enterprise grade authentication using Azure Active Directory, integrated with Spring Security. Azure Key Vault: Manage application secrets using Azure Key Vault, providing Spring value annotation support. Azure Storage: Integration with Azure Storage, including object storage, queues, tables, and more.
You can create a Spring Boot 2.0 project on Spring Initializr, then search for “Azure” to find the Azure modules:
Spring and Java extensions with Visual
Today, we are excited to announce the general availability of Azure Storage Service Encryption with customer managed keys integrated with Azure Key Vault for Azure Blob and File Storage. Azure customers already benefit from Storage Service Encryption for Azure Blob and File Storage using Microsoft managed keys.
Storage Service Encryption with customer managed keys uses Azure Key Vault that provides highly available and scalable secure storage for RSA cryptographic keys backed by FIPS 140-2 Level 2 validated Hardware Security Modules (HSMs). Key Vault streamlines the key management process and enables customers to maintain full control of keys used to encrypt data, manage, and audit their key usage.
This is one of the most requested features by enterprise customers looking to protect sensitive data as part of their regulatory or compliance needs, HIPAA and BAA compliant.
Customers can generate/import their RSA key to Azure Key Vault and use it with Storage Service Encryption. Azure Storage handles the encryption and decryption in a fully transparent fashion using envelope encryption in which data is encrypted using an AES 256 based key, which is in turn protected using the customer managed key stored in Azure Key Vault.
Customers can rotate their key in
We are delighted to announce the public preview of SQL Information Protection, introducing advanced capabilities built into Azure SQL Database for discovering, classifying, labeling, and protecting the sensitive data in your databases. Similar capabilities are also being introduced for on-premises SQL Server via SQL Server Management Studio.
Discovering and classifying your most sensitive data, including business, financial, healthcare, and PII, can play a pivotal role in your organizational information protection stature. It can serve as infrastructure for:
Helping meet data privacy standards and regulatory compliance requirements, such as GDPR. Data-centric security scenarios, such as monitoring (auditing) and alerting on anomalous access to sensitive data. Controlling access to and hardening the security of databases containing highly sensitive data. What is SQL Information Protection?
SQL Information Protection (SQL IP) introduces a set of advanced services and new SQL capabilities, forming a new information protection paradigm in SQL aimed at protecting the data, not just the database:
Discovery and recommendations – The classification engine scans your database and identifies columns containing potentially sensitive data. It then provides you an easy way to review and apply the appropriate classification recommendations via the Azure portal. Labeling – Sensitivity classification labels can be persistently tagged on
Integrating geography and location information with AI brings a powerful new dimension to understanding the world around us. This has a wide range of applications in a variety of segments, including commercial, governmental, academic or not-for-profit. Geospatial AI provides robust tools for gathering, managing, analyzing and predicting from geographic and location-based data, and powerful visualization that can enable unique insights into the significance of such data.
Available today, Microsoft and Esri will be offering the GeoAI Data Science Virtual Machine (DSVM) as part of our Data Science Virtual Machine/Deep Learning Virtual Machine family of products on Azure. This is a result of a collaboration between the two companies and will bring AI, cloud technology and infrastructure, geospatial analytics and visualization together to help create more powerful and intelligent applications.
At the heart of the GeoAI Virtual Machine is ArcGIS Pro, Esri’s next-gen 64-bit desktop geographic information system (GIS) that provides professional 2D and 3D mapping in an intuitive user interface. ArcGIS Pro is a big step forward in advancing visualization, analytics, image processing, data management and integration.
ArcGIS Pro is installed in a Data Science Virtual Machine (DSVM) image from Microsoft. The DSVM is a popular experimentation and modeling