I have a query which first performs joins inside cte and then based on cte join with other table and perform group by with some aggregations and get the top 15 records. WITH join_table as ( SELECT pl.yearmonth, pl.pdid, pl.OrderId,…
I am not sure if I am doing something wrong or cosmos db has a bug in the UI. We are storing a LONG (INT64) value in the database, it seems it is stored correctly, but it is shown wrong…
I have setup Virtual network and required subnets in a resource group. I have created a VNET secured VM, a Bastion subnet and Bastion service. Bastion service is attached with a public IP address. I am trying to open my…
I need to enable Network Policy (Route Table) for private endpoints in Azure. I've got a working Azure policy (shown below for reference), however this targets all subnets. Whilst this isn't really an issue (as the setting only applies to…
Azure has started giving me the following error: Unsupported token. Unable to initialize the authorization context. I get this from the UI when ever I try to make a change to my application. For example, if I try to add…
I've been using Microsoft's Computer Vision OCR to extract text from various types of images - but have seem to hit a bump in the road with Seven Segment font. It sometimes can pick up on them, but it mostly…
For SQL Server based login in Synapse Serverless, as soon as I run these two things: use master GO Create Login JustTest WITH PASSWORD='Whatever' use somedatabase Create User JustTest from login JustTest Now, JustTest can run any OPENROWSET query on…
I am trying to include serilog in my Azure function App project (.net 6), My Startup.cs public override void Configure(IFunctionsHostBuilder builder) { Log.Logger = new LoggerConfiguration() .WriteTo.Console() .WriteTo.AzureAnalytics(workspaceId: "xxxxxxxxxxxxxxxxxxxxxxx", authenticationId: "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx") .CreateLogger(); builder.Services.AddLogging(lb => lb.AddSerilog(Log.Logger,true)); ConfigureServices(builder.Services); } private void ConfigureServices(IServiceCollection…
I am trying to rename a file in Azure File Share using the Azure python SDK. But the problem I'm facing is, it removes the file instead of renaming it. with directory_client.get_file_client(file_name=project_from_db.project_name) as rename_client: rename_client.rename_file(new_name=new_data['project_name']) Is anything wrong here?
I am using the Azure Message Bus to communicate with my microservices. I am able to send the message under the topic Account Updated from service A. However, the message is not being read by another service called B. I…