Deploying Azure Container Instances for SQL Server 2019

December 3, 2021 by Rajendra Gupta

This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal.

Centralizing data validation with domains in Azure Database for PostgreSQL

December 2, 2021 by Gauri Mahajan

In 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.

BCP for import and export data in Azure SQL Database

December 1, 2021 by Rajendra Gupta

The 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, […]

Table Inheritance in Azure Database for PostgreSQL

November 30, 2021 by Gauri Mahajan

In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL.

How to restore an Azure SQL Database

November 30, 2021 by Manvendra Singh

I 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 […]

Migrate encrypted columns data from on-premises to Azure SQL Database

November 29, 2021 by Rajendra Gupta

Azure 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.

Using tables as templates in Azure Database for PostgreSQL

November 26, 2021 by Gauri Mahajan

In 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.

Managing Retention period of Azure SQL Database Backup

November 24, 2021 by Manvendra Singh

Azure 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, […]

Understanding Backups for Azure SQL Database

November 18, 2021 by Manvendra Singh

Azure SQL database is Database as a Service offering under the PaaS model in the Azure cloud. It is a fully managed SQL Server database engine that uses the latest stable version of SQL Server enterprise edition. This database service offers rich functionalities to increase the availability with the help of in-built high availability capability […]

Importing Azure Cosmos DB data in Azure Search

November 16, 2021 by Gauri Mahajan

In this article, we will learn how to configure the Azure Search instance to import data from Azure Cosmos DB.

Parameterized SQL Notebooks in Azure Data Studio

November 10, 2021 by Rajendra Gupta

This article will explore Parameterized SQL notebooks in Azure Data Studio.

Getting started with Azure SQL

November 8, 2021 by Manvendra Singh

This article will help you understand Azure SQL and its deployment options available in the Azure cloud. This article would be helpful to you if you are planning to migrate your SQL Server workloads to Azure cloud or want to provision a SQL database for your new application development. You will learn which deployment option […]