Using newsequentialID for GUID columns in Azure SQL DB
Dear Experts, I have this Azure SQL DB and I can see few tables that have their ID column using the uniqueidentifier column. Also, these tables have the primary key clustered defined on this ID column which is leading to heavy fragmentation. The plan…
Cosmos db Gremlin API repeat query taking more than 15 seconds to query the data
We are using COSMOS DB Gremlin API for Graph DB. We are storing contact information between two people (vertices) along with some metadata of interaction saved as edge property. A person can connect with any number of people ranging from few to 1000s of…
azure fhir api -invalid token
while trying to create patient inormation getting invalid token error,invalid audience i have created tokne usuing the belwo link https://video2.skills-academy.com/en-us/azure/healthcare-apis/access-fhir-postman-tutorial
How to flat complex json data into sql db using copy activity?
Hi Team, I have data with multiple arrays and inside multiple objects. I am using copy activity to load into database. I Have used collection reference to convert the data. But it's not helping much, out of 1000 users data ,either I get all users with…
Error in Lookup while getting distinct values
I am trying to do a look up on a table, preview data in the look up gets me the correct data when table option is chosen but when the query option is chosen and if I try to get the distinct values from the table it throws me an error
hw to ingest only files from new folder in AWS to ADLS
I have a AWS s3 bucket with 4 folders in it. Each folder has sub folders in it and each subfolder has files in it. The folder structure is like below. For each day there will be another folder with date(for ex, for next day a folder with 2020-01-03 will…
How to write Dynamic query in Azure Bulk data pool?
I want to write Dynamic query in Azure SQL Bulk data load.
Windows store for business integrate with intune
We have already integrated windows store for business with SCCM almost 1 year back. next , can now we now integrate intune with same windows store for business ? Want to understand if SCCM and intune can be integrated with single WUFB ?
![](https://techprofile.blob.core.windows.net/images/wAnczKyrJEW-0tSusWUY8A.png?8D9C64)
can the translator api handle office files?
I want to use the api to move files (.docx etc) through the translator api. Is this possible?
ModuleExceptionMessage:ColumnUniqueValuesExceeded: Number of unique values in column: ds is greater than allowed.
We are trying to train a model using the Boosted Tree Regression model and running into the "ModuleExceptionMessage:ColumnUniqueValuesExceeded: Number of unique values in column: "ds" is greater than allowed." error. This is a time…
How to deploy Azure automated machine learning model to production to generate forecast
I managed to use Azure automated machine learning to train a time series forecasting model in Azure machine learning studio. We get new data only once a month, therefore we do not think that web service is necessary for our needs. We want to deploy…
How to deploy Azure automated machine learning model to generate forecast
I managed to use Azure automated machine learning to train a time series forecasting model in Azure machine learning studio. We get new data only once a month, therefore we do not think that web service is necessary for our needs. We want to deploy…
FormRecognizer API Rate Limits
I am a lowly developer who is trying to decipher what this error message means Requests to the Analyze Layout Operation under Form Recognizer API (v2.0) have exceeded rate limit of your current FormRecognizer S0 pricing tier. Please retry after 1…
![](https://techprofile.blob.core.windows.net/images/NY6MmoXI_U--u1zSs4xwtA.png?8D8864)
Connecting a bot to Skype for over 100 users
The article https://video2.skills-academy.com/ru-ru/azure/bot-service/bot-service-channel-connect-skype?view=azure-bot-service-4.0 indicates that the publication of bots has been stopped. At the moment, are there any ways for the bot to appear in the…
Add User to group in AAD through Runbook
Folks, I have ask this question in other forum. Goal is to add user to AAD group (distribution group). Trying to run runbook (very new to this), but getting error message (as shown). here is my script. I have created automation…
![](https://techprofile.blob.core.windows.net/images/WYYotwFAAwAAAAAAAAAAAA.png?8DB142)
None of my projects (all C++) load on new computer
I recently replaced a computer. On the new computer, none of my Visual Studio projects will load (they are all C++). I receive the following error message: error : Project "" does not contain any configuration. The lack of useful…
ADF - Http as Source and Sink
Can a copy activity, copy from a http source to a http destination? In the "Supported data stores and formats' in ADF documentation, I see that http is supported only as source. Is it that http cannot be a destination ? Any detail on this will be…
Create new Vault for my existing VMs
Im having a problem with the recovery service vaults. Ive got 3 VMs in one RG and they are currently backuped in one RSVault. These RSVault have been created some time ago by my precursor and he used really weird namings. Now I created for every RG…
![](https://techprofile.blob.core.windows.net/images/84eXqZh4KEGayKJ9OOltlQ.png?8DBCF1)
powershell function
21130-pow.txt How to define a small function on the above script(line 33) to easily loop through the servers on an error using try/catch to go back and look at the server again for any errors.Any suggestions is highly appreciated
Azure Application Insights custom table
Hi , I am creating analytics report using Application Insights .In applications insights ->Logs table i need to create one custom table to push my custom data.I found one existing table "CustomEvents" instead of using this table i want to…
![](https://techprofile.blob.core.windows.net/images/419ae040258f40c5863bd6a15ec20f84.png)