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 »
This article talks about the next version of SQL Server which is SQL Server 2022. This will cover the latest announcement, release, and all the exciting features SQL Server 2022 offers.
Read more »
DBA may import, export regularly within a different environment. You might receive data in a specified format for importing it into database tables.
Read more »
This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »
In this article, we are going to learn in detail about Azure Time Series Insights. Microsoft Azure is one of the leading cloud providers these days. With a lot of companies adopting or migrating to the cloud these days, it has become a usual trend to convert existing technologies into cloud-based services and consume them. This not only helps the companies to reduce their cost but also in turn allows them to focus on more business-related problems rather than concentrating on infrastructure costs.
Read more »
This article uses Azure policies to check compliance of Azure SQL Databases against the backup retention period.
Read more »
This article will explore the Azure alerts configuration to audit Azure SQL Database creation, modification, and deletion activities.
Read more »
This article will explore Azure automation for scaling up Azure SQL Databases based on the CPU usage threshold.
Read more »
This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »
In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories.
Read more »
This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database.
Read more »
This article explores the Azure SQL Database Collation configuration and how to change it while importing the database from a BACPAC file.
Read more »
This article explores the Maximum Degree Of Parallelism (MAXDOP) for the Azure SQL Database.
Read more »
In this article, we will go over some of the most fundamental ways to filter data hosted in PostgreSQL.
Read more »
AutoML in Azure Machine Learning is used to build machine learning models on its own as we discussed in the previous article. Over there, we discussed what AutoML is and how to develop classification models in AutoML using Azure Machine Learning. This article will be dedicated to the discussion about building machine learning models using AutoML for Clustering and Time Series tasks.
Read more »
This article will deploy SQL Server on Azure VM using a Jupyter notebook in Azure Data Studio.
Read more »
In this article, we will learn how to create a simple PostgreSQL server on the Azure platform and learn how to use the Postgres check constraint to implement data validation.
Read more »
This article guides you for deploying your first SQL Server on Azure VM using the Azure portal.
Read more »© 2022 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy
