SQL Stored procedure is continually reparsed and recompiled, causing significant delay in response
Our organization has a stored procedure, that seems to always be recompiled and reparsed nearly every execution, adding upwards of 14 seconds to overall execution time. The procedure is frequently but irregularly run, so it becomes common for users to…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
difference between PL-200 and PL200-T00 certifications
Hello, I am preparing for the PL-200 exam for the functional consultant role, but I found two certifications with similar names - PL-200 and PL-200T00. What is the difference between those two? Which one should be studied to apply for functional…
Setup ASR Appliance (Configuration Server) on Window 2022
Hi I would like to know if its possible to install Configuration Server for Azure Site Recovery (in VMware) on vSphere with window 2022 as the OS. thank you
Downgrading Premium Storage to Standard Without Migration
Hi, In our Azure subscription, we have a Premium Storage Account that is significantly increasing our costs. We've recently determined that we don't need this tier and have already moved our workloads to another storage service. Now, we'd like to…
Not Receiving Authentication Codes When Switching Directories
I recently changed my phone and have already set up my account on the authenticator app. However, I’m not receiving the code when I switch to other directories. Could you guys help me resolve this?
Issue reactivating M365 Developer Program account
My M365 developer Program subscription expired on Dec 30, 2023 and all users and data were deleted on Feb 28, 2024. I am trying to reactive my subscription and still seeing the expired subscription. I tried deleting my profile but still get shown same…
Winsat.exe formal fails returning error 21 in memory assessment
Dear all, we´re running into an issue that shows up during our OS deployment sequence. Calling "Winsat.exe formal" as SYSTEM returns unspecified error 21 on only a very specific System configuration, a Dell Precision 5860 Tower Workstation with…
Incremental refresh for azure synapse with sql serverless pool
Hello I have cosmos collection with updatedDate time filed in epochtime stamp format. I have enabled azure synapse for this with serverless sql pool. I want to do the incremental import on this. I followed the steps as mentioned in…
SQL Server Error: 10060.
Unable to connect to my managed instance. My public endpoint is enabled. Error I'm getting when I try to login via SSMS. I added an inbound security rule that is higher than the "deny_all_inbound" rule. My rule port is set to 3342, protocol…
Function on Column used in Index - need optimization advice
First, is this the proper forum for MS SQL tsql questions? Why am I seeing only 114 questions? OK, so we have a table ods_DDAHIS which has a TransDate column that is numeric in format YYYYMMDD. There is an index on ods_DDAHIS.Transdate. Then view…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
How to apply an Intune app protection policy for specific devices
We have a large number of shared desk phones running Android version 9 (latest version from the vendor). Any of our users can login into the shared devices, to complicate matters we also have a BYO Intune app protection policy applied to all users that…
How can I download edited notebooks after my subscription has expired?
Dear Community, I hope this message finds you well. I am reaching out regarding my Azure for Students subscription, which has recently expired. Unfortunately, I had been working on some critical code and notebooks within Azure Machine Learning Studio,…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
Unable to deploy to machine learning workspace online endpoint
I am unable to deploy/update my online endpoints through in my machine learning workspace. The workspace has its VNET managed by Azure and I'm getting errors related to the subnet. I've ensured that the workspace has the Network Contributor role on the…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
Azure B2C: Seamless migration custom policy POST request to API not passing the correct body?
I'm configuring a custom policy for seamless migration. I've already done the pre-migration with the temporary password. The flow is: When a user Signs in, It will check if extension_isMigrated is false. If extension_isMigrated == false, then it will…
Unable to log in to Azure Language Studio
I am unable to log in to Azure Language Studio using my account. The error message displayed is: “This username may be incorrect. Make sure you typed it correctly. Otherwise, contact your admin.” However, this account has successfully logged in before…
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ? I would like to write a query to get which CU is installed on my sql servers managed with Azure Arc. I don't find the exact product version. For instance,…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
'Unknown model: chatgpt' error in Azure AI Foundry's chat playground
A Deepseek R1 model has been deployed in the chat playground, and custom data was added in Azure AI Search. When attempting to add the Azure AI search index to the model via the "Add your data" option in the chat playground, the following error…
![](https://techprofile.blob.core.windows.net/images/UVyLn-Xlr0apNce5TRX1RA.png?8DBA3B)
Allocating DB costs
My desktop app (in development) is using an Azure SQL DB to store shared content. I want to allocate costs for storage and compute time for each client based on their usage. I think I understand how I can calcualte the storage costs, but am not sure…
B2C tenant throws DirectoryUniquenessException when adding a user with unique email.
Hi and thank you in advance. Trying to create a user in a B2C tenant throws a Microsoft.Online.DirectoryServices.DirectoryUniquenessException, I have verified that the email is not part of the directory. What else can I do or how do I find the…
Sharepointで共有しているファイルやページを誰がいつ見たのか一覧データを出力する方法を教えてください
Sharepoint 上のページやファイルに誰がいつアクセスしたのかを管理したいと思っています。 ページごとの閲覧者情報を得るための方法を教えてください