SQL Azure

Rajendra Gupta
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 »
Rajendra Gupta
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 »
Rajendra Gupta
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 »
Rajendra Gupta

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 »
Rajendra Gupta
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 »
Manvendra Singh
Azure SQL database dashboard page

Understanding Backups for Azure SQL Database

November 18, 2021 by

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 and reduce the manageability efforts by using easy and smooth deployments, automatic backup, and patching, etc. We generally use this deployment for modern cloud-compatible applications or if we want to leverage hyperscale or serverless options. This article will explain Azure SQL database backups to help you understand how backups work for these databases in the background and how can we use them for our data protection and recovery requirements.

Read more »
Manvendra Singh

Getting started with Azure SQL

November 8, 2021 by

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 would be beneficial for your database workload in this article.

Read more »