#Azure and #MSOMS notable updates week 49/17


Azure SQL Data Warehouse supports the latest preview release of SQL Operations Studio. SQL Operations Studio is a free, lightweight tool for modern database development and operations

And finally on January 8, 2018 the old Azure portal will see the end of its journey, now all the features have been migrated to the new Ibiza portal.

Azure Functions Runtime preview 2 released.

Azure App Service has updated the PHP stacks to the latest available versions

cloud-init gets to Azure. cloud-init is a configuration tool to configure your linux systems during deployment.

Azure Application Architecture Guide published. Just downloaded on my Kindle and giving it a try.

New azure VM sizes announced:

  • Lv2-Series for storage intensive workloads
  • B-Series are now GA, these are the shared core VMs for workloads subject to sporadic burst in CPU usage
  • M-Series  for big guys with up to 4TB of RAM (yer of RAM) per VM.

Azure SQL DB now fully supports ## temp tables or “database scoped global temporary tables”, to recap these are the new engine features announced in the last week or so:

  • Resumable Online Index Rebuild
  • Database Scoped Temporary Tables and
  • Database Catalog Collation

Open Service Broker for Azure is now in preview. Now I didn’t know of this API, but it is promising interoperability between clouds and even if the Azure offer is currently limited to 10 or so services, Microsoft is committed “to support most others over the next year”.

The Azure IoT Hub Device Provisioning Service is now generally available.


Azure Automation Runbooks are now an allowed action type in Azure monitoring action groups. This is another step in the long journey to give Azure a well integrated alerting platform that should be able to leverage Azure Automation and Log Analytics and address not only workloads running on Azure but on any cloud platform.


This post is a dive in the past where ISAM databases were the standard and SQL databases were considered awfully slow and NOSQL wasn’t even an idea :-). Plus it gives you some insights in the ESE database anatomy. I know I’m getting old.

Capture a network trace on Windows using powershell and nothing more




  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: