Azure SQL Data Warehouse (SQL DW) continues to introduce updates to the Azure portal to provide a seamless user experience when monitoring, managing, and integrating your data warehouse.
Support for Azure Monitor metrics
SQL DW now supports Azure Monitor which is a built-in monitoring service that consumes performance and health telemetry for your data warehouse. Azure monitor not only enables you to monitor your data warehouse within the Azure portal, but its tight integration between Azure services also enables you to monitor your entire data analytics solution within a single interface. For this release, data warehouse metrics have been enabled to enables you to identify performance bottlenecks and user activity:
Successful/Failed/Blocked by firewall connections CPU IO DWU Limit DWU Percentage DWU used
These metrics now have a one-minute frequency for near real-time visibility into resource bottlenecks of your data warehouse. There is a default retention period of 90 days for all data warehouse metrics with Azure Monitor.
Pin configured charts for your data warehouse through Azure dashboards:
Safely manage costs by pausing
The pause feature for SQL
This blog post was co-authored by James Ashley, MR and AI Architect, Microsoft MVP.
Developers sometimes get anxious when it comes to hooking up a database for their apps. However, with Azure Database for MySQL and Azure Database for PostgreSQL, quickly propping up and accessing a relational database is a piece of cake. These lightweight, open source database services provide a great way to get small apps and prototypes started with very little effort. Without any extra work on your part, you can automatically take advantage of built-in security, fault tolerance, and data protection. You also can use point-in-time restore to recover a server to an earlier state—as far back as 35 days.
Azure Database for MySQL and Azure Database for PostgreSQL will work with whatever kind of project you are creating, whether it is a Linux app running in a Docker container orchestrated by Kubernetes, a computer vision service using Python, or a simple ASP.NET website to display travel photos. If your app needs a relational database, you can easily plug one in and start writing to it with guidance from these connect & query quickstarts:
Azure Database for MySQL
This blog post was co-authored by Rajen Kishna, Senior Product Marketing Manager, Azure Marketing – App Development.
Azure, Visual Studio, Xamarin, and Visual Studio App Center give you the flexible, yet robust tools and services to build, test, deploy, and continuously improve Android and iOS apps that your users will love. Use your favorite language and tools, to tap into robust cloud services, and quickly scale to millions of users on demand.
Cloud services for mobile developers
Azure provides many services to help you build cloud-connected mobile apps, including Mobile Backend as a Service, Data, and Artificial Intelligence (outlined below), as well as services to support additional functionality, including Search, Identity, and Communication.
Mobile Backend as a Service
If you need a more complete solution, the Mobile Apps feature of Azure App Service provides you with a backend that can be written in C# or Node.js, giving you features such as
We heard feedback that the current processes for creating secure clusters were complex and time-consuming. Based on your input, we’ve added the ability to create secure clusters directly from Visual Studio. This update shipped with the latest release of the Service Fabric tooling for Visual Studio 2015 and with Visual Studio 2017 as part of the Azure workload.
One of the main features of the latest release is the experience in Visual Studio for creating a cluster from the “Publish” dialog. This feature will allow you to modify the settings for the cluster, create required supporting resources, and generate the security certificate needed to create a secure cluster all from within Visual Studio. It will also import the security certificate to your local development machine so you can publish and troubleshoot your application in the cluster. This allows you to go directly from developing your service fabric application to testing it in the cloud without having to switch context. When the cluster has been created, Visual Studio will indicate this in the Output window.
You can try out this feature yourself by following the steps in the tutorial “Deploy Your Application to a Cluster“.
Below are screenshots of the new
Azure IoT SDKs make it easy for developers to begin coding and deploy applications for Azure IoT Hub and Azure IoT Hub Device Provisioning Service. The SDKs are production quality open-sourced project with support from Microsoft. If you need support for any step of your development phase, have issues during evaluation or production deployments, we are here to help! There are multiple channels where issues and requests are surfaced. We recommend the following channels for faster turnaround:
Have a feature request for SDKs? We have a User Voice for feature requests. Create new requests, upvote existing ones and help us prioritize! Have a technical question? Ask on Stack Overflow with tag “azure-iot-hub”. We monitor Stack Overflow for questions. Stack Overflow’s high standard for answers will ensure you will get a complete, detailed answer to help others in the community. Need support? If you have an Azure subscription, you can file support requests and get assistance to help you debug. Support requests also make it possible for you to communicate confidential information that would be insecure in a public GitHub issue, such as your hub name or subscription ID. When you file a support request, please make sure you specify
Microsoft’s largest developer conference, Microsoft Build, is around the corner, and there’s still time to register. Programmers and Microsoft engineers will gather May 7–9 in Seattle, Washington, to discuss what’s next in cloud, AI, mixed reality, and more. The event will feature incredible technical sessions, inspiring speakers, and interactive workshops—as well as plenty of time to connect and celebrate.
Here’s a preview of what’s coming up at Microsoft Build:
Imagine tomorrow’s tech
Industry leaders—including many Microsoft execs and engineers—will discuss how software is transforming the world in remarkable ways. Devs at any level will learn from an incredible lineup of speakers discussing what’s new, what’s coming, and how technology is a force for good.
Discover the right solutions
Attendees will experience how the Microsoft tools and platforms they rely on can take them (and their code) even further. Microsoft Build will feature more than 350 inspiring technical sessions, workshops, and opportunities to get hands-on experience with the latest tech Microsoft has to offer. There will be ample opportunity to pick up best practices and new skills from sessions such as these:
Starting your IoT project in minutes with SaaS and preconfigured solutions. Implementing complete E2E IoT solutions from devices
In addition to Terraform already being integrated to the Azure Cloud Shell, I’m pleased to announce the availability of the new Terraform solution in the Azure Marketplace. This solution will enable teams to use shared identity, using Managed Service Identity (MSI), and shared state using Azure Storage. These features will allow you to use a consistent hosted instance of Terraform for DevOps Automation and production scenarios.
The Terraform solution configures Terraform to use Azure Storage instead of the local file system for Terraform state. This remote state implementation will lock state when one user is changing it, to allow multiple users to consistently change the state of shared environments, such as production.
The template also configures a Managed Service Identity and provides a Role Based Access Control (RBAC) script that will allow this identity to provision resources in the Azure subscription using Terraform. This eliminates the need for managing Service Principal secrets for Terraform separately in automation scenarios such as continuous deployment with Jenkins.
Azure Terraform Provider updates
Development on the Terraform Azure Provider also continues at a furious pace, we passed the 1.0 milestone last December, and version 1.3 has already shipped. As we near complete coverage of
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+
We are pleased to announce that firewall and reboot functions are now supported in all three Azure Redis Cache tiers. We have been making these previously premium-only features available to the basic and standard tiers at no additional cost. In addition, we are previewing the ability to pin your Redis instance to specific Availability Zone-enabled Azure regions.
Firewall provides added security for your Azure Redis deployment. It lets you restrict which clients can connect to your Redis cache based on their IP addresses. You can create a firewall rule for each IP address range that your Redis clients use. Once you enable firewall, by specifying at least one rule only those requests coming from IP addresses that fall into the defined IP range(s) will be accepted by Redis. Redis monitoring endpoints are excluded from firewall rules, however. This prevents accidental network disconnect due to firewall settings and ensures that monitoring will work uninterrupted.
Reboot allows you to restart one or more nodes in your Redis Cache. This function is useful particularly for simulating cache failures and testing how your application would react to them. It is a highly requested feature from User Voice. You can reboot any
This blog post is co-authored by Joachim Hafner, Cloud Solution Architect
We’re pleased to offer a free e-book for those of you who are new to Azure or in the beginning stages of planning a cloud migration: the Azure Strategy and Implementation Guide for IT Organizations. As cloud solution architects, we hear a lot of the same questions from customers who are starting to think about their cloud implementation process. This motivated us to write this e-book, which provides guidance in the form of a blueprint which customers can follow to help form their cloud strategy.
Whether you are starting with Azure or doing more general research regarding how IT teams navigate cloud implementation, this guide offers a balance of broadly applicable advice and Azure specifics for you to consider. Here is an overview of what is covered:
Chapter 1: Governance – This chapter covers the starting points, from the aspirational “digital transformation” to the important tactical steps of administration and resource naming conventions. Get an overview of topics such as envisioning, to cloud readiness, administration, and security standards and policy. Chapter 2: Architecture – This section takes a longer look at security, touches on cloud design patterns, and