Backup/Restore and collation update in Azure Synapse
We have one requirement that to change the collation of Azure SQL serverless database in Azure Synapse Analytics to default collation. So I have 2 questions, 1. How to take backup and restore Azure SQL serverless database in synapse. 2. How to update…
Is this the correct way to set Software update deployment schedule
The text slightly confusing me.
Out of Office unable to send automatic reply
I have set up automatic replies in Out of Office, but when other users within the organization send me messages, they still cannot receive automatic replies and request help.
How to consume an azure devops API without PAT
Hi, I'm able to programmatically (C#) call an azure devops API to get all the area paths in my organization. I'm using a PAT that I created. However, this PAT will expiry and don't want to generate new ones every time they expire, even though it can be…
CosmosDB Analytical store delete changes in sql sink
Hi I am trying to capture delete changes from Azure cosmosdb analytical store using change data capture in Azure datafactory, Source is Cosmosdb, sink is Azure sql database. In between I am flattening my file using dataflow. My insert, update is…
Teams Spellchecker has wrong language
Teams new spellchecker checks in English instead of the Dutch language. In the other office applicaties the spellchecker is in dutch en in the windows settings everything is dutch to. Exept for Onenote the spellchecker is also in english and i cant set a…
New Profile with email account
When I create a new profile in the control panel and then add an account, I keep being prompted to enter a password. I confirm that the password is correct and I can log in on the web version.
How to configure VNET DNS resolution for two different linked domains at the same time?
Hi, We have a domain on-prem which is connected via VPN tunnel to a Virtual Network Gateway in Azure, linked to this is a Virtual network and this is also peered to a number of other vnets but along with it there is another different domain in there. I…
How to get an azure function app using powershell to loop through JSON
I am having trouble getting my azure function app to work. The powershell works OK locally, but not in the function app. I am trying to loop through the JSON and remove SYSTEMCOLUMNS_ and then I want to return $data back as JSON Input { …
What is business hitech?
I am Marki Taylor working for businesshitech as PR consultant. With more than 6 years experience in PR and Digital Industry, helping teams to achieve goals by streamlining the process.
UPDATE fields
Hello, This works when using insert into: Using command As New OleDbCommand("INSERT INTO Table (Column1) VALUES (?)", connection) command.Parameters.AddWithValue("@param1", field1) command.ExecuteNonQuery() …
I am having trouble unlinking my GitHub account from Microsoft App Center
Hi there, Is it possible to unlink my github account from Microsoft App Center? I wish to download software onto my mobile via the Microsoft "personal, company or school' option here. https://appcenter.ms/create-account. Currently I am unable to do…
an internal state error has occurred the remote session will be disconnected your computer might be low on memory using Pulse RDP Terminal Service client
How do I fix my remote session when I get this message "an internal state error has occurred the remote session will be disconnected your computer might be low on memory" using Pulse RDP Terminal Service client?
OleDbCommand Parameters
Hello I'm going to use parameterized queries for all my Access OleDb commands and got 2 questions: Use Parameters.Add or Parameters.AddWithValue? The documentation won't clarify the pros and cons of each one. If I choose Parameters.Add how to map the…
powershell to get all users and their managers recursively
I am looking to pull all Active Directory users and their managers all the way up to the chain. I get how to do get-aduser -filter * -properties * | select name, manager export-csv -path "csv path" I also get: $Users = Get-ADUser -filter *…
How to let a group of users to access Salesforce Enterprise Application which is being configured for SSO using Microsoft Entra Id.
I'm a beginner at Microsoft Entra ID, but I have successfully configured SSO for Salesforce Application. Now I can make the Microsoft entity user to login Salesforce with the help of Microsoft account credentials instead of Salesforce…
how to connect to mysql to insert data using SharePoint 2019
Hi, i am using SharePoint 2019 on prem. Solution Required: How to connect to mysql databases ( on prem ) to insert data into mysql db. Thanks
NVME disks are not appearing in windows VM after it is attached at the VMware side; it appears after a reboot; sometime not even after reboot.
Hi Team , NVME disks are not appearing in windows VM after it is attached at the VMware side; it appears after a reboot; sometime not even after reboot. I checked in the vm edit settings on vmware side.. hard disk is attached properly via nvme…
How do I create a dynamic SQL query for Cosmos DB using Azure Data Factory?
I am doing a simple data flow where I have a source from a cosmos db container, I want to get the latest data that is greater than a _ts value that I store in a variable (SELECT * FROM c WHERE c_ts > @variables('LastRunDateTS')). How can I pass this…
I cannot transfer the billing ownership of my Azure subscription that runs a tenant. How can I fix this?
I cannot transfer the billing ownership of my Azure subscription that runs a tenant. Trying to transfer the billing ownership immediately ends up in an error. Can you help me to transfer the billing ownership of my subscription to my tenant.