Interactive Queries From Azure

Kevin Feasel



Arun Sirpal shows a query editor is now available with Azure SQL Database from the Azure portal:

This is in public preview and you can do the following:

  • Query dynamic management views for real-time workload insights (Which is what I will be doing).

  • Issue ad-hoc queries.

  • Manage your user authentication.

Read on for more information.

Related Posts

Corrupting Managed Instances

Brent Ozar has found a bug with Azure SQL Database Managed Instances: Corruption happens. It’s just a fact of life – storage is gonna fail. Microsoft’s SLAs for storage only give you 3-4 9’s, and there’s nothing in there about never losing your data. Nothing against Azure, either – I’ve lost entire VMs in AWS due to […]

Read More

Data Lake Permissions

Melissa Coates has started a multi-part series on Azure Data Lake permissions.  She’s put up the first three parts already.  Part 1 covers the types of permissions available as well as some official documentation: (1) RBAC permissions to the ADLS account itself, for the purpose of managing the resource. RBAC = Role-based access control. RBAC are […]

Read More


January 2017
« Dec Feb »