How can I sync data from a source database table without primary key to the destination database table with primary key
Hi all, If the source MS SQL SERVER 2017 database table does not have primary key but destination MS SQL SERVER 2019 database table has primary key, what is the best way or method to make both tables data in sync? Please take into consideration that…
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
Is there a tier for a Flat Monthly Fee for an Azure VPN?
Since it seems we will have to constantly create a VPN, then delete it, then recreate it again when needed since there is no way to just disable when not needed. Is there a tier for a flat fee for an Azure VPN??
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
Troubleshooting SQL Server Replication Error During Version Upgrade
How can we resolve a Replication error that occurs when trying to include certain tables in a Publication after migrating from SQL Server 2012 to SQL Server 2019? Removing the affected articles is a temporary solution, but the issue persists for 10…
Bidirectional replication between on prem SQL server and Azure sql with no primary key exist
Can you suggest possible solution for bidirectional real time sync between on prem SQL (2016) and Azure SQL with no primary key exist
How to fix build errors that I am getting currently when I convert my .NET MAUI [ sdk 6 version] to .NET 8 version?
I am currently in a process of converting my MAUI project which is in .NET 6 version to .NET 8 version. I have used Microsoft's .NET upgrade assistant extension tool for the same. After successful upgrade, when I try to build/rebuild my project, I am…
Datatime value issue
Hi, How to correct it below? tb_apply_date.Text = Datetime.Now.ToString();
Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block
Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…
Can find the Power automate SharePoint test site for module Getting Started with Power Automate Unit 4
Can anyone tell me how to access the test sharepoint site for unit 4 of the Getting started with Power Automate Module? My org doesn't let me create a new file in our sharepoint site and I can't seem to access the one that the module says is…
Can a deadlock issue be raise while running two select queries in sql server
Do we get a deadlock issue while running two select statements of two different table in sql server
Azure fundamentals launching sandbox is taking me to launch on a different organisation's
During the Azure fundamentals training I have just reached the training on Azure Accounts. At one point it starts to spin up the sandbox and despite my email address being pwc.com it is trying to go to a different pension company completely and as a…
"Remove Unused References" unavailable for UWP projects
I have enabled "Remove Unused References" but the context menu of a UWP app project does not have the option: Could anyone shed some light on this?
sql server agent alert failed
hello I have this problem with my SQL Server Agent, the service is working properly but when I make alert by some program running by SQL Server it shows that SQL Server agent is not working even if it is working, where should the problem be?
How to change the logo for SQL Server Master Data Services (MDS) in 2019
This used to be accomplished in the SQL Server Master Data Services (MDS) 2016 version by changing the logo.png file.
Microsoft Account Help
Does anyone know why I can't add a Samsung S23 to my Microsoft Account, it doesn't even show up as a linked device even though I'm signed in on edge with the phone like it says to.
The trust relationship between this workstation and the primary domain failed
Good day, I have some issue which is this error will appear when try to login the PC that has been joined the domain. The error was "The trust relationship between this workstation and the primary domain failed". I try several solution which is…
Onedrive no Server 2012 R2 Não Conecta
Onedrive no Server 2012 R2 Não Conecta, Help
Powershell script to Download All Contents ( Folder and Files ) from Sharepoint and Local to SharePoint
Hi There, Good Day. Would like to seek your assistance on how we able to transfer/download Folder with files and sub-folder, files to Local Drive from Sharepoint and Local to SharePoint. Greatly appreciate your feedback. Thank You.
Internal user and external cannot chat with each other in Teams
Hello Please i need your help on this issue. We have one of our user who is able to chat with an external user in Teams. When ever he tries to chat with the external user he get the error message below: "External user need to accept your…