Azure DNS Name Servers, are they shared with the public?
I'm studying for the AZ-104, and got wondering about Azure DNS Zones and who can access the name servers. I created a DNS Zone (not a private DNS Zone) called testzonesg.com, and created one A record called "host". The assigned name servers for…
Unable to find package 'Microsoft.Azure.SqlDatabase.ElasticScale.Service.SplitMerge'
It is related to "Deploy a split-merge service to move data between sharded databases" I followed the steps in the "Download the Split-Merge packages" (very beginning) and tried to execute the command nuget install…
Writing an UPDATE SQL query in Azure Data Factory
I'm relatively new to ADF. We currently have a pipeline running that reads data from 5 separate csv files in blob storage, copies them to tables in Azure SQL database, and then calls 4 separate SQL server stored procedures which update, clean, and…
Force execution of SQL Server - Azure ARC Migration Assessments
Hello, I'd like to test the Migration tool on Azure Arc, but I'm unable to proceed because the "Migration Assessment" is scheduled for Sunday. Is there a way to force this task? It seems that the "Best Practices Assessment" is not…
Unable to connect to Azure SQL database via Power BI
Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured…
Azure Data Share specific column selection during Data Share creation from Provider
As part of one of my migration project requirements, my source team has agreed to share their data using Azure Data Share. But, they are not willing to share the PII data over Azure Data Share. Does Azure Data share supports selection of specific columns…
ADF Pipeline using Global parameter fails when triggered but succeed when debugged
I'm working with ADF, using global parameters, and facing the issue. It works fine if I debug the pipeline. But, if I trigger the pipeline (manual or scheduled), it fails saying the property doesn't exist and it shows the name of the global parameter I'm…
py4j.security.Py4JSecurityException
Hello I am trying to run spark XGBoostRegression model on Databricks cluster with Databricks runtime: 14.3 LTS. I am getting the following error: Py4JError: An error occurred while calling o547.resourceProfileManager. Trace:…
Spark_Ambiguous_Executor_MaxExecutorFailures
Hi I'm running a scheduled multiple run notebook using the below configuration, but I keep getting the below error DAG = { "activities": [ { "name": "Notebook", "path":…
Microsoft Database Migration Assistant - Can I save a data migration project
I can save and reload a database assessment with MS Database Migration Assistant, but can I save a migration project? If so, then how do I do that?
403 Forbidden - Request forbidden by administrative rules
I work in the UK. On Microsoft Azure/Microsoft Entra ID, my colleagues who are Member users have their user location set to the UK. Even for those that work for our company who live in the US, Canada and India. When 2 of my colleagues went to China they…
Why create compute is taking long time?
I am trying create a compute for my workspaces i tried every combination still it is not working
Using Conditional Formatting/ Formula to Compare Two Dates
I am trying to compare two dates in a large data sheet as a Success or Failure depending on the Ship Date. For example, on the first line, the Ship Date is 2/29/2024 which is after the due date (-1 of 2/26/2024), making it a failure. The Expected…
How to ingest data in ADX using python script
I am using free trial and trying to ingest data into ADX using python SDK but facing this issue An error occurred: Principal 'msauser=1:live.com:00037FFE6E855292' is not authorized to perform operation 'Ingest' on 'any database'.
Unable to Open Python Files in VisualStudio 2022
An error occurred in 'Miscellaneous Files' while attempting to open 'statisfinapp.py' System.Runtime.InteropServices.COMException (0x80041FEB): Exception from HRESULT: 0x80041FEB at…
Configuring sql user permission to INSERT only via stored procedure in Synapse dedicated pool
We currently have a client with External users set up via AAD and each group has access to a certain schema with grant permission to select, insert, delete and update on their dedicated SQL pool. Our client would like to revoke explicit insert, delete…
What permissions are needed for an Azure Runbook to execute the SQL command CREATE USER FROM EXTERNAL PROVIDER
I have an automation account that creates an Azure SQL database and attempts to provision a user from Microsoft Entra Id with access to the database My automation account is configured with a system assigned managed entity and a user assigned Managed…
How to write "az cli" script to deploy WebApp in Github
Please help me write a script to deploy a blazor server web application whose C# source is in a Github repo. My first choice is "azure CLI" commands inside a "ps1" file. Attempt #1 Here is my first attempt after having successfully…
Graph Match operator error when project is not specified
I'm going through examples here: https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/graph-match-operator I'm attempting to use an anonymous node and edge combinations to get all matching nodes with the pattern ()--[]--() which to my…
Windows 11 22H2 - Can't use saved credential
After upgrade Windows 11 22H2 I Can't use saved credential (Windows Defender Credential Guard does not allow using saved credentials). Before it works.