This article will show how to deploy the Hyperscale (Citus) server group of Azure Database for PostgreSQL and explore its configuration options.
Read more »
Azure
Recommender Systems for Customer Reviews
July 29, 2021Introduction
Until now, we have discussed several topics in Text Analytics in Azure Machine Learning in many aspects from the last couple of articles and in this article, we will be discussing the Recommender Systems for Customer Reviews.
Read more »
DDL triggers in Azure SQL Database
July 28, 2021This article explores database DDL triggers for auditing Data Definition Language (DDL) on Azure SQL Database.
Read more »
An overview of Azure Cognitive Services
July 26, 2021Microsoft 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 »
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 »
Latent Dirichlet Allocation in Text Analytics
July 8, 2021Introduction
Until now, we have discussed a few topics in Analytics in Azure Machine Learning many aspects in the last couple of articles, we will be discussing the Latent Dirichlet Allocation in Text Analytics in this article.
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 »
Learn NoSQL in Azure: Getting started with DocumentDB SQL API
July 7, 2021This article is a part of the series Learn NoSQL in Azure where we will learn about the DocumentDB SQL API in detail. Azure Cosmos DB is a serverless NoSQL database service provided by Azure that is highly available, globally distributed, and responds within the minimum latency. Due to these features, it is a perfect fit for building modern-day applications using the DocumentDB or SQL API of Azure Cosmos DB.
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 »
Use Kusto Query Language to solve a data problem
July 5, 2021Introduction
In the previous article Azure Data Explorer and the Kusto Query Language, we saw how the Microsoft Azure Data Explorer works, and we learned about the Kusto query language (KQL). We’ll build on this here in part two, we’ll learn more about KQL, and we’ll use KQL to solve a real-world data problem.
Read more »
Filter based Feature Selection in Text Analytics
July 1, 2021Introduction
As we are well into the discussions of Text Analytics in Azure Machine Learning from the last couple of articles, we will be discussing the Filter based Feature Selection in Text Analytics and how we can build a prediction model from the Filter Based Feature Selection in order to perform text classification.
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 »
Learn NoSQL in Azure: Diving Deeper into Azure Cosmos DB
June 25, 2021This article is a part of the series – Learn NoSQL in Azure where we explore Azure Cosmos DB as a part of the non-relational database system used widely for a variety of applications. Azure Cosmos DB is a part of Microsoft’s serverless databases on Azure which is highly scalable and distributed across all locations that run on Azure. It is offered as a platform as a service (PAAS) from Azure and you can develop databases that have a very high throughput and very low latency. Using Azure Cosmos DB, customers can replicate their data across multiple locations across the globe and also across multiple locations within the same region. This makes Cosmos DB a highly available database service with almost 99.999% availability for reads and writes for multi-region modes and almost 99.99% availability for single-region modes.
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 Data Explorer and the Kusto Query Language
June 21, 2021Introduction
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.
Read more »
Learn NoSQL in Azure: An overview of Azure Cosmos DB
June 16, 2021In 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.
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 »
Using the DB Snapshot Creator Extension in Azure Data Studio
June 8, 2021This article talks about the steps required to add and use the DB Snapshot Creator extension in Azure Data Studio.
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 »