Azure

Azure Data Explorer and the Kusto Query Language

June 21, 2021 by Frank Solomon

Introduction

Microsoft Azure Data Explorer handles and analyzes petabyte-masses of structured and unstructured data. In Azure Data Explorer, users lever the Kusto query language (KQL) for their data analysis work. This article, part one of a two-part article, will introduce KQL. This article will also describe a free Microsoft online interactive resource that allows for hands-on Kusto exploration and learning. Part two will describe more aspects of KQL, and use those aspects to solve a real-world data problem.

Learn NoSQL in Azure: An overview of Azure Cosmos DB

June 16, 2021 by Aveek Das

In this article, we are going to learn Azure Cosmos DB. This article is a part of the series “Learn NoSQL in Azure”, where we will explore all the different types of non-relational databases that are supported in Azure at the moment. Azure is one of the most popular public cloud platforms that has a big market share all over the world. Cosmos DB is a part of the Databases section in Azure that allows customers to create and use NoSQL or non-relational databases and consume these at scale. You can leverage Cosmos DB to build highly scalable and robust cloud-based applications that support modern big data workloads. Let us understand more about what a NoSQL database is all about and how it is different from a relational database. Although this article focuses on the NoSQL related to Azure, it is to be known that other open-source projects support NoSQL databases like Apache Cassandra, etc. However, these topics are out of the scope of this article and we will focus on Azure mostly.

Azure Automation: Azure Logic Apps for face recognition and insert its data into Azure SQL Database

June 15, 2021 by Rajendra Gupta

Today, we will implement an Azure Logic App for face recognition and insert its data into an Azure SQL database.

Integrating Azure Purview with Azure Synapse Analytics

June 14, 2021 by Gauri Mahajan

In this article, we will learn how to integrate Azure Purview and Azure Synapse Analytics capabilities to access data catalog assets hosted in Purview from Azure Synapse.

Using the DB Snapshot Creator Extension in Azure Data Studio

June 8, 2021 by Haroon Ashraf

This article talks about the steps required to add and use the DB Snapshot Creator extension in Azure Data Studio.

Cataloging AWS S3 datasets with Azure Purview

June 2, 2021 by Gauri Mahajan

In this article, we will learn how to configure Azure Purview to catalog data hosted in AWS S3.

Azure Automation: Export Azure SQL database data to CSV files using Azure Logic Apps

June 1, 2021 by Rajendra Gupta

This article uses Azure automation techniques for sending query results as a CSV file attachment in Azure SQL Database by using Azure logic apps.

Accessing Azure Database for PostgreSQL using pgAdmin

May 26, 2021 by Gauri Mahajan

In this article, we will show how to connect to instances of Azure Database for PostgreSQL servers using the pgAdmin tool installed locally on a user’s workstation.

Azure Automation: Publish LinkedIn posts and tweets automatically using Azure Logic Apps

May 25, 2021 by Rajendra Gupta

This article implements Azure Automation logic for automatically publishing a LinkedIn post and Twitter’s Tweet using the simplified Azure Logic App.

Querying JSON documents in Azure Cosmos DB using the SQL API

May 21, 2021 by Gauri Mahajan

In this article, we will look briefly at the Azure Cosmos DB service and how you can query JSON documents to store, retrieve and process data using the SQL Application Programming Interface (API).

Declarative Database Development in Azure Data Studio

May 19, 2021 by Haroon Ashraf

This article is all about declarative database development using Azure Data Studio for both beginners and professionals who are new to it.

Azure Automation: Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage

May 17, 2021 by Rajendra Gupta

This article uses Azure Automation techniques to import data into Azure SQL Database from Azure Storage container.

Azure Database for PostgreSQL Cost Optimization

May 14, 2021 by Gauri Mahajan

This article will walk you through the process to optimize the cost of Azure Database for PostgreSQL.

Azure Automation: Analyzing Twitter sentiments using Azure Logic Apps

May 14, 2021 by Rajendra Gupta

This article configures Azure Automation for Analyzing Twitter sentiments using Azure Logic Apps and stores them into Azure SQL Database.

Azure Machine Learning: Named Entity Recognition in Text Analytics

May 13, 2021 by Dinesh Asanka

Introduction

After starting our discussions into Text Analytics in Azure Machine Learning from the last article, we will be discussing the Named Entity Recognition control in Azure Machine Learning in this article.

Getting started with Azure Database for PostgreSQL

May 13, 2021 by Gauri Mahajan

This article will get you started with Azure Database for PostgreSQL and understand various options offered by this.

Azure Automation: Auto-scaling Azure SQL database with Azure Logic Apps

May 12, 2021 by Rajendra Gupta

Azure SQL Database supports DTU-based and vCores based purchasing models for deploying your databases in the Azure managed service.

Azure Automation: Building approval-based automated workflows using Azure Logic Apps

May 11, 2021 by Rajendra Gupta

In the Azure Automation article, Azure Automation: Automate data loading from email attachments using Azure Logic Apps, we did the following tasks:

Azure Automation: Automate data loading from email attachments using Azure Logic Apps

May 11, 2021 by Rajendra Gupta

This article will explore Azure automation for automatic data loading into Azure SQL Databases using the Azure Logic App.

Generating Azure SQL Database Classification and Sensitivity reports

May 5, 2021 by Gauri Mahajan

This article will show how to use Azure SQL Database to classify and tag data with sensitivity labels to generate reports out of it.

Azure Automation: Export Azure SQL Database to Blob Storage in a BACPAC file

May 5, 2021 by Rajendra Gupta

Azure SQL Database supports exporting schema and data in a compressed format BACPAC. We can store this BACPAC file into an Azure storage account. Later, this BACPAC file can help restore the Azure SQL database, and Azure managed SQL instance or on-premises SQL Server.

How to use SQL Server DACPAC extensions in Azure Data Studio

April 29, 2021 by Haroon Ashraf

This article is focused on installing and using SQL Server DACPAC Extension in Azure Data Studio.

Azure Automation: Create database copies of Azure SQL Database

April 27, 2021 by Rajendra Gupta

This article will explore Azure automation for creating a new Azure SQL Database copy.

Azure Automation: Automate Azure SQL Database indexes and statistics maintenance

April 27, 2021 by Rajendra Gupta

Azure SQL Database is a PaaS solution for migrating your on-premises databases to the Azure cloud infrastructure. It is a managed service and Azure manages the infrastructure, database availability, backup restore, and compute resources.

Language Detection in Azure Machine Learning with basic Text Analytics Techniques

April 26, 2021 by Dinesh Asanka

After discussing a wide range of aspects in Azure Machine Learning, now it is time to move into a new area, Text Analytics and we have dedicated this article to Language Detection in Azure Machine Learning for Text Analytics.