Four new built-in functions in Azure Stream Analytics address common scenarios:
REPLACE replaces all occurrences of a specified string value within another string value.
COALESCE evaluates a list of arguments and returns the value of the first expression that is not NULL.
ROUND returns a numeric value rounded to the specified length or precision.
CROSS JOIN joins reference data with an event stream.
Azure Stream Analytics now offers full support for the WKT geospatial format, to open up new possibilities and opportunities for developers.
In addition, Stream Analytics has added support for geospatial indexing of reference data. This provides faster processing to support, for example, larger-scale fleet management and connected cars. The transition from geographic to geometry-based calculations will deliver geo-projected results to users.
Users of Azure Stream Analytics can now run their real-time pipelines with authentication based on Managed Service Identity while writing to Azure Data Lake Storage Gen 1. This will help users provision long-running jobs, because they no longer need to deal with password expiration.
The serial console for Azure Virtual Machines now enables you to reboot your VM from within the console experience. This ability will help you if you want to reboot a stuck VM or enter the boot menu of your VM. In addition, we've added two new fonts that you can choose from: Inconsolata and PT Mono.
On 2/6, a security update to the Ubuntu xenial rssh package was made available via public Ubuntu package sources. The updated version (2.3.4-4+deb8u1build0.16.04.1) introduced a fault in Service Fabric's ImageBuilder process. This process is used when provisioning applications and the cluster runtime in Service Fabric. Ubuntu based Service Fabric nodes will be unable to do core management operations unless the dependent package is downgraded to the previous version (2.3.4-4). Guidance in Context.
We have been making continuous enhancements to Azure DevOps Projects and in the latest deployment now available to all customers, we have added support for Azure Cosmos DB and Azure Functions as target destinations for your application. This builds on the existing Azure App Service, Azure SQL Database, and Azure Kubernetes Service (AKS) support.