Tag: Azure SQL

No, it is not possible to restore a bacpac file to an existing Azure SQL database. A bacpac file is a data-tier application package that contains the schema and data…Read moreIs it possible to update the existing Azure SQL Database using bacpac?

Choosing between Azure SQL Database and Azure Virtual Machines (VMs) for a production environment with a large data size (1 TB to 2 TB) depends on several factors, including performance,…Read moreIn production Environment what is better between Azure VM and Azure SQL considering the huge data amount of 1 TB to 2 TB

I have created an Azure SQL server, setting ‘Allow Azure services and resources to access this server’ to no. I have a. ASP.Net application running as an App Service and…Read moreOn Azure, how do I find the ip address of an app service to create a firewall rule for it on Azure SQL?

Right now I am haunted by a question regarding copying data from Azure SQL to a parquet file using the azure data factory copy-activity. The Azure SQL database conains various…Read moreAzure Data Factory Copy to Parquet file uniqueidentifier

Hi, I would be migrating 1.5 TB data from on-premises (Oracle) to the Azure SQL database using the Azure Data Factory (SHIR). Question-1 -Please inform how to perform the data…Read moreData Validation after migration from the Azure Data Factory

Hi everyone, I would like to know which Azure service is recommended to migrate progressively from an old Azure SQL database to a new one ? Most of the tables…Read moreWhich Azure service is recommended to synchronize between Azure SQL databases ?

I’m attempting to improve performance of a set of views that we have on a local server, pulling data from an Azure database. Our system provider advised us to use…Read moreazure sql database – Linked Servers and Application Intent

In this 1 hour long project based course,you will learn to create an azure account and implement an azure sql database.You’ll get to know various purchasing models and select the…Read moreImplement a Relational database in Azure SQL database

I have an application built in .net 6 that runs in Azure as an App Service. It connects to a SQL Azure database to run queries, update data etc. Mostly…Read moresql server – Azure App Service connecting to SQL Azure gets all connections in pool used intermittently

let’s start saying that i have no experience with partitioned tables and i’m not quite sure how to handle index maintenance (Rebuild / Reorganize). Consider my scenario: we have 3…Read moresql server – How should I handle index maintenance on partitioned tables in Azure SQL DB?

I am using Copy activity to upsert data into my desitnation table in Azure SQL Database based on primary keys. ADF creates Interim tables in the specified schema which is…Read moreAzure Data Factory Upsert Azure SQL Database Sink

In Azure Data Factory, I have a “Stored Procedure Activity” that executes a stored procedure which updates a single row in a single table in Azure SQL Server database instance…Read moreAzure Data Factory “Stored Procedure Activity” causes SQL server deadlock error 1205

Hey, In an Azure project we are querying two remote databases and then joining them using an INNER JOIN. The query takes rather long and analysing the query plan with…Read moreCan not use Query Hints inside Azure SQL

I am trying to connect Azure SQL through Azure data factory both are hosted on different resource group. I have tried to add the IP address for SQL firewall setup…Read morehow to connect Azure SQL through Azure data factory both are hosted on different resource group

I tried to use Export option from SSMS which gives an error saying failed due to foreign key relationship. How to copy data between tables(more than 400+) of two different…Read moresql server – Copy data between tables considering foreign key relationship

Hi @Arildsen ,   To troubleshoot this issue, there are a few potential solutions to consider:   1.Check the Azure SQL database connection settings: Verify that the connection settings for the Azure…Read moreRe: Reports uploaded with terraform – not able to …

How to move Azure SQL managed instance cross tenants? I have some critical DBs hosted by Tenant_A’s SQL MI A which need to be moved to Tenant_B’s SQL MI B.…Read moremigration – How to move Azure SQL managed instance cross tenants?

When using a copy activity and SQL Server connector in ADF pipeline, there are observed differences between how ADF handles a “bulk insert” operation and how SQL Server handles “bulk…Read moreazure data factory – Are there differences in how bindings are handled when using the bulk insert feature in ADF and SQL?

I am trying to load data from Azure SQL to Snowflake. I am under the constraint to use the copy activity only. I am using a lookup table to reference…Read moreDelimiter issue – Copying Data from Azure SQL to Snowflake

Microsoft sponsored on-demand webinar Webcast Abstract Azure SQL Managed Instance is an intelligent cloud database service combining the broadest SQL Server engine compatibility with the benefits of a fully managed…Read moreModernize Your Apps with Azure SQL Managed Instance and Unlock the Benefits of the Cloud

Part of the Azure SQL family, Azure SQL Database is the intelligent, scalable, relational database service built for the cloud. It’s evergreen and always up to date, with AI-powered and…Read moreBest Data Management Software for Azure Data Share

The token-based authentication method allows middle-tier services to obtain a token from Azure AD and use it to connect to Azure SQL Database. It also enables more sophisticated scenarios, including…Read moreWhat are the advantages of using Token based authentication in Azure SQL DB? How to decide whether to choose this approach for DB connection from your application?

I have been using the Azure cognitive search to create the search index where the data source will be the azure SQL database. I have created the search index for…Read moreHow to create the field mapping in Azure cognitive search

What you need is called an “online” migration and Azure Data Migration Service (DMS) is the tool/service you need. This tutorial of the old version should help you do all…Read moreSQL Database from Azure VM to Azure SQL Server : DB Size ( 300 GB DB)

I have setup Managed Identity on my App Service and given the database access. I have a console app and used Microsoft.Data.SqlClient 3.0.1 as a nuget package that I test…Read moreHow can i connect to Azure SQL Database using Managed Identity?

Please what are the options for me in the following scenario. We have a SQL managed instance on Azure, our client has requested that they want their data (managed instance)…Read morescheduled tasks – How to sync data from Azure SQL managed instance to On-premise SQL server instance on weekly Basis

We have a Azure SQL Database (PAAS) that acts like a master database for testing new code. The goal is to set up a pipeline that creates a writeable copy…Read morebackup – Azure SQL Database – Restore options for Continuous Integration Builds

So, we have made a web application login protocol via which users can query a database on Azure SQL Server with sensitive data. Now partner-organizations want to use the same…Read moresql server – How to ensure an app builder doesn’t have acccess to database?

You can use the full SQL Server Management Studio to do the majority of the tasks. You can download the tool here: www.microsoft.com/en-gb/download/details.aspx?id=29062 To connect to your Azure SQL database,…Read moreHow to manage windows azure SQL Database