Microsoft Azure has been a leading cloud service provider over the past few years. In this article, we are going to look into an overview of various cognitive services offered by Azure. In simple English, the word ‘Cognitive’ means to involve in intellectual activities, such as thinking or reasoning. Similarly, Azure Cognitive Services are also related to intelligence related to the computer and the way humans behave with these computers. For example, these services allow humans to interact with the machines as if they have the intellectual ability to talk, think and respond to events accordingly.
Read more »SQL Azure
Getting started with Azure Database for PostgreSQL – Flexible server
July 14, 2021This article will walk you through the process to create a Flexible server model of Azure Database for PostgreSQL and learn the unique features offered by it.
Read more »Azure SQL Database Maintenance Window
July 7, 2021Azure SQL Database and SQL Managed instance are Microsoft offerings for PaaS SQL Server in cloud infrastructure. In the case of a traditional on-premises SQL Server, at certain times, we require database system downtime to perform specific operations such as hardware upgrades, OS and SQL Server patching. In a critical production database system, it is challenging to get downtime and schedule these activities.
Read more »Data Wrangling with Power Query in Azure Data Factory
July 6, 2021This article will help you get started with Power Query in Azure Data Factory to perform Data Wrangling.
Read more »Restore Transparent Data Encryption (TDE) enabled Azure SQL Database
June 30, 2021This article will restore a Transparent Data Encrypted Azure SQL Database into an on-premise SQL Server. Further, we will also create a copy of the Azure database on the same server.
Read more »Consuming datasets from Azure SQL Database in Azure Machine Learning
June 29, 2021This article will show how to source data from Azure SQL Database into Azure Machine Learning.
Read more »TDE customer-managed keys in Azure SQL Database
June 24, 2021Azure SQL Database is a Platform-as-a-Service (PaaS) solution that offers managed database service. Azure DB provides many features such as automatic database tuning, vulnerability assessment, automated patching, performance tuning, alerts. It provides a 99.995% availability SLA for the Zone redundant database in the business-critical service tier.
Read more »Creating and Cataloging SQL pools in Azure SQL Server
June 22, 2021This article will walk you through creating a new SQL pool within an existing Azure SQL Server as well as catalog the same using the Azure Purview service.
Read more »Query Store Hints in Azure SQL Database
June 22, 2021This article explores the recently announced preview feature of Azure SQL Database – Query Store Hints.
Read more »Azure Automation: Azure Logic Apps for face recognition and insert its data into Azure SQL Database
June 15, 2021Today, we will implement an Azure Logic App for face recognition and insert its data into an Azure SQL database.
Read more »Integrating Azure Purview with Azure Synapse Analytics
June 14, 2021In 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.
Read more »Azure Automation: Translate documents into different languages using Cognitive Services with Azure Logic Apps
June 9, 2021Suppose you write a technical blog in the English language for your website. You have good followers in a country where the primary language is not English. You want to translate the document content in their native language for a wider reach.
Read more »Cataloging AWS S3 datasets with Azure Purview
June 2, 2021In this article, we will learn how to configure Azure Purview to catalog data hosted in AWS S3.
Read more »Azure Automation: Export Azure SQL database data to CSV files using Azure Logic Apps
June 1, 2021This article uses Azure automation techniques for sending query results as a CSV file attachment in Azure SQL Database by using Azure logic apps.
Read more »Accessing Azure Database for PostgreSQL using pgAdmin
May 26, 2021In 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.
Read more »Azure Automation: Publish LinkedIn posts and tweets automatically using Azure Logic Apps
May 25, 2021This article implements Azure Automation logic for automatically publishing a LinkedIn post and Twitter’s Tweet using the simplified Azure Logic App.
Read more »Querying JSON documents in Azure Cosmos DB using the SQL API
May 21, 2021In 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).
Read more »Declarative Database Development in Azure Data Studio
May 19, 2021This article is all about declarative database development using Azure Data Studio for both beginners and professionals who are new to it.
Read more »Azure Automation: Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage
May 17, 2021This article uses Azure Automation techniques to import data into Azure SQL Database from Azure Storage container.
Read more »Azure Database for PostgreSQL Cost Optimization
May 14, 2021This article will walk you through the process to optimize the cost of Azure Database for PostgreSQL.
Read more »Azure Automation: Analyzing Twitter sentiments using Azure Logic Apps
May 14, 2021This article configures Azure Automation for Analyzing Twitter sentiments using Azure Logic Apps and stores them into Azure SQL Database.
Read more »Getting started with Azure Database for PostgreSQL
May 13, 2021This article will get you started with Azure Database for PostgreSQL and understand various options offered by this.
Read more »Azure Automation: Auto-scaling Azure SQL database with Azure Logic Apps
May 12, 2021Azure SQL Database supports DTU-based and vCores based purchasing models for deploying your databases in the Azure managed service.
Read more »Azure Automation: Building approval-based automated workflows using Azure Logic Apps
May 11, 2021In the Azure Automation article, Azure Automation: Automate data loading from email attachments using Azure Logic Apps, we did the following tasks:
Read more »Azure Automation: Automate data loading from email attachments using Azure Logic Apps
May 11, 2021This article will explore Azure automation for automatic data loading into Azure SQL Databases using the Azure Logic App.
Read more »