In this article, we will learn how to create an Azure Blob Storage account and understand all the different configuration options and their impact on the blobs stored in the account.
Read more »
Azure
Create Azure Container Instances for SQL Server 2019 using Azure CLI
December 8, 2021This article explores Azure CLI scripts for deploying Azure Container Instances with SQL Server 2019 image.
Read more »
Deploying Azure Container Instances for SQL Server 2019
December 3, 2021This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal.
Read more »
Centralizing data validation with domains in Azure Database for PostgreSQL
December 2, 2021In this article, we will learn how to work with domains in Azure Database for PostgreSQL and learn how to use it with tables to centralize the constraints logic that would be applied across tables.
Read more »
BCP for import and export data in Azure SQL Database
December 1, 2021The Bulk Copy Program (BCP) utility can move bulk data between SQL Server instances. You can export SQL Server data into BCP files. You can also use them for moving data from on-premises SQL Server instances to Azure SQL Database. The BCP files do not contain schema or the format information of your data. Therefore, you cannot use it as a database migration tool. However, it is adequate to import or export many rows. However, you need to create the table or use a format file to import data into a table.
Read more »
Table Inheritance in Azure Database for PostgreSQL
November 30, 2021In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL.
Read more »
How to restore an Azure SQL Database
November 30, 2021I will explain how to restore an Azure SQL database in case you need to recover some data, or somebody has deleted your database in this article. Databases restore is the common activity a DBA performs in his day-to-day activities to meet various business requirements. We should also perform regular restores to ensure our backups are healthy and restorable in case of any emergency. Here, I will create an Azure SQL database named TestDB along with a table Employee inside this database and then recover them by restoring its automatic backups.
Read more »
Migrate encrypted columns data from on-premises to Azure SQL Database
November 29, 2021Azure SQL Database is a cloud database hosted on Microsoft’s Azure platform. It is an enterprise-grade database service that supports a wide range of advanced features, and it can be used to store and process data. Customers can migrate data from an on-premises SQL Server without downtime and minimal disruption.
Read more »
Using tables as templates in Azure Database for PostgreSQL
November 26, 2021In this article, we will learn how to create a new instance of Azure Database for PostgreSQL as well as understand how to use existing tables as templates while creating new tables.
Read more »
Managing Retention period of Azure SQL Database Backup
November 24, 2021Azure SQL Database is a fully managed SQL Server database engine based on the latest stable version of SQL Server enterprise edition. This is Database as a Service offering under the PaaS model in the Azure cloud. It offers in-built high availability capability and reduces the manageability efforts by automating administration activities like backups, patching, etc. Backups are managed automatically by Azure for all PaaS database deployments. This article will explain one of the configuration item retention periods of Azure SQL database backups.
Read more »
Importing Azure Cosmos DB data in Azure Search
November 16, 2021In this article, we will learn how to configure the Azure Search instance to import data from Azure Cosmos DB.
Read more »
Parameterized SQL Notebooks in Azure Data Studio
November 10, 2021This article will explore Parameterized SQL notebooks in Azure Data Studio.
Read more »
Searching multi-lingual data in Azure SQL Databases
November 8, 2021In this article, we will learn how to enable multi-lingual search on data hosted in Azure SQL Databases.
Read more »
Copy Data tool to import data into Azure SQL Database from web sources
November 8, 2021This article will explore the Copy Data tool for importing data into Azure SQL Database from a web source.
Read more »
Creating an Azure Search service instance for Azure Cosmos DB
November 4, 2021In this article, we will learn how to create an instance of Azure Search service and attach it to an instance of Azure Cosmos DB.
Read more »
Discovering data assets with glossary terms in Azure Purview
October 29, 2021This article will show how to catalog data assets and then tag business glossaries at the attribute level of data assets in Azure Purview.
Read more »
Copy Data tool to export data from Azure SQL Database into Azure Storage
October 29, 2021DBA may import, export regularly within a different environment. You might receive data in a specified format for importing it into database tables.
Read more »
Defining Business Glossary with Azure Purview
October 27, 2021In this article, we will explore Azure Purview capability and understand it with a practical walkthrough.
Read more »
Automatic Index advisor in Azure SQL database
October 26, 2021This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »
Creating metadata-driven data pipelines using Azure Data Factory
October 25, 2021In this article, we will learn how to build metadata-driven pipelines using Azure Data Factory.
Read more »
High Availability in Azure Database for PostgreSQL
October 21, 2021In this article, we will learn about the high availability features recently introduced in Azure Database for PostgreSQL.
Read more »
Visualizing data with dashboards in Azure Databricks
October 18, 2021In this article, we will learn how to create dashboards using the data that is typically processed using notebooks in Azure Databricks.
Read more »
Populating Delta Lake Tables in Azure Databricks with Azure Data Factory
October 13, 2021In this article, we will learn how to populate delta lake tables into Azure Databricks from Azure SQL Database using Azure Data Factory.
Read more »
Creating Delta Lake Tables in Azure Databricks
October 11, 2021In this article, we will learn how to create a delta table format in Azure Databricks.
Read more »
Introduction to Azure Time Series Insights
October 7, 2021In this article, we are going to learn in detail about Azure Time Series Insights. Microsoft Azure is one of the leading cloud providers these days. With a lot of companies adopting or migrating to the cloud these days, it has become a usual trend to convert existing technologies into cloud-based services and consume them. This not only helps the companies to reduce their cost but also in turn allows them to focus on more business-related problems rather than concentrating on infrastructure costs.
Read more »