This article for the Always On Availability Groups series will show how to configure SQL Server Always On Availability Groups between Windows and Linux SQL instances.Read more »
- Configure cross-platform SQL Server Always On Availability Groups - August 10, 2022
- SQLPackage utility to export Azure SQL Databases - August 1, 2022
- Azure SQL Interview Questions and Answers - July 13, 2022
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 »
Interested in becoming an Azure SQL DBA but don’t know how to start? This article prepares you for the Azure SQL DBA interview by providing reference material links.Read more »
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?
This article will talk about the SQL WHERE statement.Read more »
This article explores the database-level roles in the Azure SQL Database.Read more »
This article is for discussing fixed server roles in Azure SQL Database Server.Read more »
This article explains SQL Server Dedicated Administrator Connections and how you can use it for Azure SQL Database.Read more »
The article Configure IP firewall rules for Azure SQL Databases, discuss the configuring server and database IP firewall rules for Azure databases. In this article, we will explore setting applicable to Azure databases that control connectivity to the database.Read more »
The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the database infrastructure.Read more »
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 »
Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure Data Studio, or applications for query data.Read more »
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 »
This article explores an alternative solution for SSDT using Azure Data Studio for both Windows and Linux SQL Server.Read more »
This article introduces and explores the Jupyter books in the Azure Data Studio.Read more »
This article explores the process of table partitioning in Azure SQL Database and explains how it differs from on-premises SQL Server.Read more »
This article explores the scalar UDF performance issues and improvements in Azure SQL Database using UDF Inlining.Read more »
This article will walk you through the process of creating, importing a customized SQL Server image into Azure Container Registry and finally deploying an Azure Container instance using it.Read more »
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 »
This article will explore AWS RDS SQL Server with Amazon RDS Custom as a managed database service for applications that require an operating system and database customization.Read more »
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 »
This article explores Azure CLI scripts for deploying Azure Container Instances with SQL Server 2019 image.Read more »
This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal.Read more »
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 »