Rajendra Gupta

Rajendra Gupta
Latest posts by Rajendra Gupta (see all)
Configured SQL Job

SQLPackage utility to export Azure SQL Databases

August 1, 2022 by

Azure SQL Database does not support native database backups. Therefore, you cannot use it to move from the Azure cloud to on-premises SQL Server. You can use the data-tier application BACPAC file format for exporting database schema and data from the Azure database. This BACPAC file is helpful to deploy on an Azure SQL Database, Managed Instance, and on-premises SQL Server.

Read more »
View charts

Notebook Views for SQL Notebooks in Azure Data Studio

June 15, 2022 by

We are excited to share that Notebook Views are available for SQL Notebooks in the Azure Data Studio (Currently Insiders release). This article will cover the following topics:

  • What are Notebook Views?
  • Where can you find Notebook Views?
  • How do you create a new view?
  • How do you modify an existing view?
  • Where can you see database objects in the view?
  • Where can you see table data in the view?
  • Where can you see query results in the view?
Read more »
Set up Azure Function App

Azure Functions for Azure SQL Database

March 10, 2022 by

As a Platform as a Service (PaaS) service, Azure SQL Database enables developers to deploy SQL Database in Azure Cloud without managing the infrastructure. We use SQL Server Agent to schedule jobs to run at a specific schedule in an on-prem SQL instance. However, Azure DB does not have agent functionality.

Read more »

Permissions comparison between on-premises SQL Server and Azure SQL Database

February 25, 2022 by

The database contains business, customer sensitive and confidential data. Therefore, securing the database environment is the prime responsibility of a database administrator. If you plan to host your databases in Microsoft Azure, you can choose the platform as a service solution – Azure SQL Database. The Azure SQL DB is a fully managed database service; therefore, you do not get full access to SQL Server features, databases.

Read more »
Open file in visual studio code

Deploying Azure Container Instances using YAML

January 21, 2022 by

The Azure Container Instances provides a flexible solution for implementing container-based images in Azure infrastructure quickly. It does not require building the virtual machine, installing applications like Microsoft SQL Server, or configuring the software. You can choose the container images from the libraries and build solutions. You can use non-persisted(default) and persisted storage to avoid losing container data if your container status changes to Stopped and restarted.

Read more »
three tier template

Use ARM templates to deploy Azure container instances with SQL Server Linux images

December 21, 2021 by

The Azure Resource Manager (ARM) template is a JavaScript Object Notation (JSON) file for deploying Azure resources automatically. You can use a declarative syntax to specify the resources, their configurations. Usually, if you need to deploy Azure resources, it might be a tiring experience of navigating through different services, their configurations. With the ARM templates, you no longer need to click and navigate around the portal. For example, you can use configure the template for Azure VM or Azure SQL Database deployment.

Read more »
Verify default data paths

Store SQL Server files in Persistent Storage for Azure Container Instances

December 10, 2021 by

In the articles, Deploying Azure Container Instances for SQL Server 2019 and Create Azure Container Instances for SQL Server 2019 using Azure CLI, we explored Azure Container Instances for SQL Server on Linux. These containers are stateless. Therefore, if you stop or restart container instances, you lost your data. Suppose, being a developer, you created a new container database, deployed a few tables, and stored procedures for testing purposes. You do not want to lose these objects or databases even if you destroy your container. Similarly, you also want to reuse those databases if you create a new container instance.

Read more »
Azure logical server

BCP for import and export data in Azure SQL Database

December 1, 2021 by

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, 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 »