In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from one table in Azure to SQL Server on-premises using SSIS.
Read more »
This blog will share with you a way to copy data from an AWS RDS SQL Server database to an Azure SQL database.
Read more »
This article explores how to rename Azure SQL Database and on-premises SQL instance database.
Read more »
This article explains Azure SQL Database Geo Restore using geo-replicated backups for disaster recovery.
Read more »
This article gives an overview and deployment steps for SQL Elastic Pool for Azure SQL database.
Read more »
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 »
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:
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 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 »
In this article, we will talk about Azure SQL. The article will compile the FAQ about this topic. The article will cover FAQ related to concepts for newbies, prices, some common features, migration and several links for references to get higher details on specific topics.
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 »
In this article, we will learn about the concept of table inheritance, and its use in Azure Database for PostgreSQL.
Read more »
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.
Read more »
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 »
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 »
In this article, we will learn how to enable multi-lingual search on data hosted in Azure SQL Databases.
Read more »
This article will explore the Copy Data tool for importing data into Azure SQL Database from a web source.
Read more »© Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy