%3CLINGO-SUB%20id%3D%22lingo-sub-336134%22%20slang%3D%22en-US%22%3EAzure%20IoT%20News.%20New%20Azure%20Features%2C%20Love%20Letters%2C%20New%20Looks%20and%20New%20Tools!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-336134%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Feb%2018%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CI%3E%20Authored%20by%20Peter%20Laker%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%20Data%20ingress%20and%20analysis%20has%20become%20one%20of%20the%20newest%20and%20fastest%20growing%20areas%20of%20interest%20for%20any%20company%20wanting%20to%20better%20understand%20or%20take%20control%20of%20their%20Things.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Microsoft%20are%20leading%20this%20sector%20with%20some%20of%20the%20most%20advanced%20and%20cost%20effective%20tools%20and%20services%2C%20like%20Event%20Hub%2C%20IoT%20Hub%2C%20Stream%20Analytics%2C%20Power%20BI%2C%20Machine%20Logic%2C%20Azure%20Functions%2C%20Logic%20Apps%20and%20Automation%20Run%20books.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Last%20month%20saw%20the%20announcement%26nbsp%3Bof%20the%20new%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-gb%2Fblog%2Ft-sql-query-editor-in-browser-azure-portal%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESQL%20Database%20Query%20Editor%20%3C%2FA%3E%2C%20now%20available%20in%20Azure%20Portal!%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73384i8796DF5D31EC5373%22%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EYou'll%20find%20it%20in%20the%20tools%20section%20of%20your%20Azure%20SQL%20database%2C%20or%20as%20a%20new%20tile%20in%20SQL%20Data%20Warehouse.%20I%20so%20very%20much%20love%20this%20feature%2C%20as%20I%20don't%20have%20to%20spin%20up%20an%20SQL%20client%20just%20to%20make%20a%20tweak%20or%20check%20a%20stat.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Also%20in%20the%20news%2C%20you%20can%20now%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-gb%2Fblog%2Fazure-email-invoices%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eget%26nbsp%3Bdetailed%20invoice%20%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-gb%2Fblog%2Fazure-email-invoices%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Es%20emailed%20to%20you%20%3C%2FA%3E%2C%20instead%20of%20having%20to%20log%20into%20the%20portal.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73385iFF4B9DBE36C537AA%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20February%20bought%20news%20of%20an%20update%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fazuremarketplace.microsoft.com%2Fen-us%2Fmarketplace%2Fapps%3Fpage%3D1%26amp%3Bsrc%3Dblogazure%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Marketplace%20%3C%2FA%3E.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73386i0A943A434637DB8F%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20The%20site%20is%20much%20more%20interactive%20now%20and%20provides%20an%20easy%20interface%20for%20browsing%20and%20finding%20a%20product%20that%20suits%20your%20requirements.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20There%20is%20a%20lot%20more%20detail%20now%2C%20for%20each%20product%20and%20the%20%22Azure%20Marketplace%20Test%20Drives%22%20feature%20lets%20you%20try%20before%20you%20buy!%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20month%20also%20saw%20the%20announcement%20of%20the%20new%20OPEN%20SOURCE%20%3CSTRONG%3EEvent%20Hubs%20.NET%20Standard%20client%2C%20on%20Git%20Hub%20%3C%2FSTRONG%3E!%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73388iAD7243F46AE5D6A6%22%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3ENo%20more%20do%20you%20need%20to%20install%20the%20entire%20Service%20Bus%20package%20if%20all%20you%20want%20is%20to%20talk%20to%20your%20animals.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.nuget.org%2Fpackages%2FMicrosoft.Azure.EventHubs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft.Azure.EventHubs%20%3C%2FA%3Eis%20a%20stand-alone%20library%20for%20just%20Event%20Hub%20users%20and%20%3CA%20href%3D%22https%3A%2F%2Fwww.nuget.org%2Fpackages%2FMicrosoft.Azure.EventHubs.Processor%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft.Azure.EventHubs.Processor%20%3C%2FA%3Eis%20a%20replacement%20for%20the%20original%20%3CA%20href%3D%22https%3A%2F%2Fwww.nuget.org%2Fpackages%2FMicrosoft.Azure.ServiceBus.EventProcessorHost%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft.Azure.ServiceBus.EventProcessorHost%20%3C%2FA%3Elibrary.%20This%20is%20a%20logical%20move%20as%20Event%20Hub%20and%20IoT%20Hub%20are%20becoming%20so%20popular%20in%20their%20own%20right.%20Get%20started%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fevent-hubs%2Fevent-hubs-dotnet-standard-getstarted-send%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSTRONG%3EHERE%20%3C%2FSTRONG%3E%3C%2FA%3E.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20But%20my%20favourite%20arrival%20this%20month%20so%20far%20has%20to%20be%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fstream-analytics%2Fstream-analytics-tools-for-visual-studio%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Stream%20Analytics%20Tool%20for%20Visual%20Studio%20%3C%2FA%3E.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20With%20this%20addition%20to%20Visual%20Studio%2C%20you%20can%20finally%20take%20control%20of%20your%20live%20streaming%20analytics%20in%20a%20more%20controlled%20environment.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73390iAADA079B401817F9%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20You%20can%20also%20export%20your%20Stream%20Analytics%20jobs%20from%20Azure%20into%20a%20new%20project%20and%20take%20better%20control%20within%20your%20project%20structure%2C%20rather%20than%20just%20dealing%20with%20ARM%20templates.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20We%20can%20now%20also%20add%20our%20own%20custom%20code%20into%20the%20processing%20stream%2C%20with%20Azure%20ML%20AND%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2Fstream-analytics-javascript-user-defined-functions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ENOW%20JAVASCRIPT%20%3C%2FA%3E!!%20%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20just%20about%20anything%20you%20wanted%20to%20do%20before%2C%20you%20can%20do%20now!%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fstream-analytics%2Fstream-analytics-tools-for-visual-studio%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-gb%2Fazure%2Fstream-analytics%2Fstream-analytics-tools-for-visual-studio%20%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20reading!%20%3CBR%20%2F%3E%3CBR%20%2F%3EPete%20Laker%20(Azure%20MVP)%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73392i710F0F00F297C3AD%22%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F73393i4255E3A3C03875B9%22%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-336134%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Feb%2018%2C%202017%20Authored%20by%20Peter%20LakerData%20ingress%20and%20analysis%20has%20become%20one%20of%20the%20newest%20and%20fastest%20growing%20areas%20of%20interest%20for%20any%20company%20wanting%20to%20better%20understand%20or%20take%20control%20of%20their%20Things.%3C%2FLINGO-TEASER%3E
First published on MSDN on Feb 18, 2017

Authored by Peter Laker


Data ingress and analysis has become one of the newest and fastest growing areas of interest for any company wanting to better understand or take control of their Things.



Microsoft are leading this sector with some of the most advanced and cost effective tools and services, like Event Hub, IoT Hub, Stream Analytics, Power BI, Machine Logic, Azure Functions, Logic Apps and Automation Run books.



Last month saw the announcement of the new SQL Database Query Editor , now available in Azure Portal!



You'll find it in the tools section of your Azure SQL database, or as a new tile in SQL Data Warehouse. I so very much love this feature, as I don't have to spin up an SQL client just to make a tweak or check a stat.



Also in the news, you can now get detailed invoice s emailed to you , instead of having to log into the portal.





February bought news of an update to the Azure Marketplace .



The site is much more interactive now and provides an easy interface for browsing and finding a product that suits your requirements.

There is a lot more detail now, for each product and the "Azure Marketplace Test Drives" feature lets you try before you buy!



This month also saw the announcement of the new OPEN SOURCE Event Hubs .NET Standard client, on Git Hub !



No more do you need to install the entire Service Bus package if all you want is to talk to your animals.

Microsoft.Azure.EventHubs is a stand-alone library for just Event Hub users and Microsoft.Azure.EventHubs.Processor is a replacement for the original Microsoft.Azure.ServiceBus.EventProcessorHost library. This is a logical move as Event Hub and IoT Hub are becoming so popular in their own right. Get started HERE .



But my favourite arrival this month so far has to be Azure Stream Analytics Tool for Visual Studio .

With this addition to Visual Studio, you can finally take control of your live streaming analytics in a more controlled environment.



You can also export your Stream Analytics jobs from Azure into a new project and take better control within your project structure, rather than just dealing with ARM templates.

We can now also add our own custom code into the processing stream, with Azure ML AND NOW JAVASCRIPT !!

So just about anything you wanted to do before, you can do now!

https://docs.microsoft.com/en-gb/azure/stream-analytics/stream-analytics-tools-for-visual-studio...



Thanks for reading!

Pete Laker (Azure MVP)