Some time ago, Redgate created the free Microsoft Azure storage tool, Azure Explorer. It’s a neat solution that lets users manage all of their Azure blobs in one place, reliably upload and download them through its responsive UI, transfer them between storage accounts, and easily search and filter blobs.

1. Azure Explorer Visual Studio
2. Azure Data Explorer
3. Storage Explorer Azure
4. Azure Explorer Download Microsoft

While it sat outside Redgate’s portfolio of database development and management solutions, in a kind of niche of its own, it was a popular download. Without a development team behind it to take it further, however, it was languishing and we didn’t feel good about that.

Azure Data Explorer Endpoint Enter your Cluster URL, AppID, AppKey and TenantID in the Service connection appropriate Fields (Authentication Token Field should be left empty) To create a new service connection go to project settings page (the gear icon in the lower lefthand side).

Step in Monza Cloud

Monza Cloud are the people behind AzStudio, a tool that speeds up the development of Microsoft Azure applications and typically reduces development time by 40-60%. They have deep experience in delivering solutions around cloud-centric application development and addressing the unique needs of cloud-centric DevOps challenges. The kind of experience that a tool like Azure Explorer requires in order for it to be developed further.

So to ensure the future of the tool, they’ve taken over the upkeep and updates of Azure Explorer, which can now be freely downloaded from MonzaCloud.com/Azure-Cloud-Explorer/.

It’s good news for everyone. Users can still rely on it to easily browse and manipulate their Azure blob storage. We’re happy at Redgate that a tool we developed will continue to help people. And the team at Monza Cloud have plans to expand the scope of Azure Explorer with new features and integrations with the rich suite of options that AzStudio provides.

So, if you’d like an easier way to handle the scale demands of production-sized cloud datasets, download Azure Explorer from the Monza Cloud website.

• Microsoft is radically simplifying cloud dev and ops in first-of-its-kind Azure Preview portal at portal.azure.com.
• Get Started with Accessing Azure Data Explorer using Apache Spark for Azure Synapse Analytics - Microsoft 8 April 2021, Channel 9. Azure Data Explorer gets new engine, numerous enhancements and Synapse integration 14 October 2020, ZDNet. AMD EPYC Processors Power Microsoft Azure Data Explorer, Offers Users 30 Percent Better Performance.
• The Azure IoT explorer is a graphical tool for interacting with and devices connected to your IoT hub. This article focuses on using the tool to test your IoT Plug and Play devices. After installing the tool on your local machine, you can use it to connect to a hub.
• Email, phone, or Skype. Can’t access your account?

Tools in this post

Azure Explorer

A free storage tool for Microsoft Azure.

Also in Blog

What’s Redgate’s plan for PASS?

My blog post from February 1 explains that Redgate took the opportunity to purchase the assets of PASS with the main goal of supporting the community.

The PASS association ran for 21 years bringing...

Also in Software development

Healthcare IT responds to pandemic with increased focus on database monitoring and the cloud

Every year, Redgate’s State of Database Monitoring Report reveals how businesses and organizations are monitoring their database estates. Are they using in-house or third-party monitoring tools? Who...

Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. It helps you handle the many data streams emitted by modern software, so you can collect, store, and analyze data. Azure Data Explorer is ideal for analyzing large volumes of diverse data from any data source, such as websites, applications, IoT devices, and more. This data is used for diagnostics, monitoring, reporting, machine learning, and additional analytics capabilities. Azure Data Explorer makes it simple to ingest this data and enables you to do complex ad hoc queries on the data in seconds.

What makes Azure Data Explorer unique?

• Scales quickly to terabytes of data, in minutes, allowing rapid iterations of data exploration to discover relevant insights.

• Offers an innovative query language, optimized for high-performance data analytics.

• Supports analysis of high volumes of heterogeneous data (structured and unstructured).

• Provides the ability to build and deploy exactly what you need by combining with other services to supply an encompassing, powerful, and interactive data analytics solution.

Data warehousing workflow

Azure Data Explorer integrates with other major services to provide an end-to-end solution that includes data collection, ingestion, storage, indexing, querying, and visualization. It has a pivotal role in the data warehousing flow by executing the EXPLORE step of the flow on terabytes of diverse raw data.

Azure Data Explorer supports several ingestion methods, including connectors to common services like Event Hub, programmatic ingestion using SDKs, such as .NET and Python, and direct access to the engine for exploration purposes. Azure Data Explorer integrates with analytics and modeling services for additional analysis and visualization of data.

Azure Data Explorer flow

The following diagram shows the different aspects of working with Azure Data Explorer.

Work in Azure Data Explorer generally follows this pattern:

1. Create database: Create a cluster and then create one or more databases in that cluster. Quickstart: Create an Azure Data Explorer cluster and database

2. Ingest data: Load data into database tables so that you can run queries against it. Quickstart: Ingest data from Event Hub into Azure Data Explorer

3. Query database: Use our web application to run, review, and share queries and results. It's available in the Azure portal and as a stand-alone application. You can also send queries programmatically (using an SDK) or to a REST API endpoint. Quickstart: Query data in Azure Data Explorer

Query experience

Azure Explorer Visual Studio

A query in Azure Data Explorer is a read-only request to process data and return the results of this processing, without modifying the data or metadata. You continue refining your queries until you've completed your analysis. Azure Data Explorer makes this process easy because of its fast ad hoc query experience.

Azure Data Explorer handles large amounts of structured, semi-structured (JSON-like nested types) and unstructured (free-text) data equally well. It allows you to search for specific text terms, locate particular events, and perform metric-style calculations on structured data. Azure Data Explorer bridges the worlds of unstructured text logs and structured numbers and dimensions by extracting values in runtime from free-form text fields. Data exploration is simplified by combining fast text indexing, column store, and time series operations.

Azure Data Explorer capabilities are extended by other services built on its powerful query language, including Azure Monitor logs, Application Insights, Time Series Insights, and Microsoft Defender for Endpoint.

How to provide feedback

Azure Data Explorer

We would be thrilled to hear your feedback about Azure Data Explorer and its query language at:

Storage Explorer Azure

• Ask questions

Azure Explorer Download Microsoft

Next steps