I'm working in a simple ETL for our budget on MS Azure Data Factory. This pipeline takes a source from an Excel and has a Sink on MS Azure SQL Database. Already done the integration and it works, but i'm…
I want to copy an Azure SQL DB table exactly from a source DB to a destination DB. I currently have a "Copy data" activity that works great for upserting the data. But I also want to delete any records…
We run a SaaS which puts data in other people's SQL Azure databases. These databases are 3rd-party and out of our control - we asked only that they whitelist our IP addresses. Recently, we added our app to a VNet…
I have a table named Report_Table in Azure SQL. It has more than one hundred columns. I will give an example with 3 columns like: +--------+----------+------+ | job_id | rep_pm | done | +--------+----------+------+ | 46 | a002 | a…
I'm looking for a reliable strategy that will allow me to relate a performance problem that the Azure portal has highlighted, back to some query in the C# .NET 7 / EF Core 7 app that has generated that query.…
I am running an incremental process for multiple tables where I am using old watermark, new watermark, copy activity, and a stored procedure to update the watermark value. One of my table succeeds when I run the pipeline, for eg…
I'm testing Azure SQL Database with the Serverless feature. I would like to understand if the SQL Database went into Auto-Pause mode yesterday and for how long. I asked to ChatGPT to give me a hint about what code I…
I am trying to UPDATE target table but in source table I have duplicate data. I am trying in Azure SQL Server database. All will be ok with HASHBYTES but if I remove HASHBYTES it will raise an error: drop…
I have designed a PurchaseOrder table - with partioning on CreatedDate column - In Visual Studion Data Tool as follow: CREATE TABLE [dbo].[PurchaseOrder] ( [IdGlobal] UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), [IdLocal] BIGINT NOT NULL, [CreatedDate] DATE DEFAULT (getdate()) NOT NULL,…
I am trying to connect Azure SQL with AKS using managed Identity but this doesnt seems to work. I have been checking numerous blogs and I am as confused as I started. I am using aad-pod-identity: https://github.com/Azure/aad-pod-identity https://blog.seblab.be/posts/configure-aad-pod-ientity-on-aks/ https://medium.com/devopsturkiye/azure-kubernetes-service-aks-mimarisinde-aad-pod-identity-943effa54a39 https://medium.com/devopsturkiye/azure-kubernetes-service-aks-mimarisinde-aad-pod-identity-943effa54a39…