Logging Azure Function
Is there a way to view logging of my Azure Function App without the use of Application Insights? Can I write the logging of my Function app to a separate file that I can view? (edit) If so, how? Edit:…
Azure SQL DB not updating varchar length
I created a table using the following SQL command: CREATE TABLE [my-azure-db].dbo.MyTable ( Id int IDENTITY(1,1) NOT NULL, Name nvarchar(32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, ); When I check the table with DBeaver, it looks like this: Therefore, I tried to…
Azure – AADSTS9002331: Application is configured for use by Microsoft Account users only. Please use the /consumers endpoint to serve this request
So I registered an app for Personal account only. Then, I generated a sample blazor project with Visual Studio and set up the redirect url https://localhost:7213/signin-oidc. When I start the projects, it correctly redirects me to the /signin-oidc endpoint and…
Azure API Management – subscription key not being enforced
I have an Azure Function that I'm managing via Azure APIM. I have created a subsciption key for it, however it's not being enforced. I've tested accessing it without the subscription key and it can still get a response. Any…
azure amortized cost usagestart and usageend date error while passing it as variable
I am trying to pull azure amortized cost at subscription level but when I pass usage_start_date and usage_end_date in hardcoded way I am able to pull data : Example : "https://management.azure.com/subscriptions/"+subs+"/providers/Microsoft.Consumption/usageDetail?$filter=properties/usageStart eq '2022-05-01' and properties/usageEnd eq '2022-05-31'&metric=AmortizedCost&api-version=2021-10-01" But when I…
Azure Cognitive Search – how to rank child objects by relevancy
Let's say I have a product catalog index like below, where I have a list of products that have an array of individual sku child objects. I want to be able to perform a search that returns the matching product…
Can PowerBI inherit RLS from Azure Synapse SQL?
I have a Azure Synapse SQL table which contains a list of companies. I have created an access matrix, security predicate and policy to filter data presented based on the user. Create FUNCTION spf.rls_securitypredicate_dimcompany(@Companycode AS nvarchar(50)) RETURNS TABLE WITH SCHEMABINDING…
C#.net Core 6.0 web app connecting to Snowflake from Azure using RSA key in file
I need to connect my .Net Core 6.0 web app from Azure to snowflake. I have RSA key stored locally and in the connection string it is referenced: SnowflakeDbCon": "account=**************;authenticator=snowflake_jwt;user=xxxxxxxx;private_key_file=c:Keysrsa_key.p8;private_key_pwd=yyyyyyyyy;db=dbbbbbbb;schema=MY_SCHEMA;" Code: builder.Services.AddScoped(_=> new SnowflakeDbConnection { ConnectionString = builder.Configuration.GetConnectionString("SnowflakeDbCon") }); This…
Azure Cache Redis Slow Performance rather than DB query
We have implemented Azure Cache Redis for our project. But the problem is Azure Cache query performance is slower than db query. For a query while Redis response average is 115ms the db query average is 60ms. For another query…
Azure – How to deploy App Service with managed SSL certificate using ARM
I want create an Azure App Service with a custom hostname binding and a managed SSL certificate. When I create a single Bicep-template, the certificate resource can only be deployed if the hostname binding is already created. But to create…