General database mail troubleshooting steps

Note: If no errors seen on the database side, it could be some problem with the outgoing STMP email server. Sources: https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-general-troubleshooting?view=sql-server-ver16

Azure Function – Change Port

Issue: http://localhost:7071 already in use by another running Azure app. Resolution: Change your current Azure Function app to run under another port. local.settings.json

Restore Database From Full/Diff/Log Backup Files

1 One2 Two3 Three4 Before full backup <FULL BACKUP>5 After full backup6 Before LOG backup 1 <LOG BACKUP 1>7 After LOG backup 18 Before DIFF backup <DIFF BACKUP>9 After DIFF backup10 Before LOG backup 2 <LOG BACKUP 2>11 After LOG backup 212 Before LOG backup 3 <LOG BACKUP 3>13 After LOG backup 3 Restore Options... » read more

The certificate chain was issued by an authority that is not trusted

Issue: Database Connection String: Encrypt=True;TrustServerCertificate=False If you recently upgraded your SQL Server Native Client 11.0 (Provider=SQLNCLI11) application to use Microsoft OLE DB Driver 19 for SQL Server (Provider=MSOLEDBSQL19), you might receive error messages that resemble the following messages: [Microsoft OLE DB Driver 19 for SQL Server]: Client unable to establish connection [Microsoft OLE DB Driver... » read more

Create Self-Signed Certificate

Open PowerShell as administrator Run the following command: C:\Users\user01> New-SelfSignedCertificate -Subject “CN=OrgCert1234” -CertStoreLocation “cert:\LocalMachine\My” Now, what we have to do is obtain the private key certificate file to be able to upload it to Azure: Press the windows key Type Manage Computer Certificates and press Enter Go to Personal (on the left), then Certificates Double-click on the... » read more

Deployment error from new Development Computer- HTTP Error 500.30 – ASP.NET Core app failed to start due to certificate authentication issue

Issue: Getting the following error message after deploying a Blazor web app from a new development computer Resolution: Update “Self Signed Certificate” to Blazor web app and web app server config. Need to create a new self signed certificate on development computer, upload to Azure web app. Then update the self signed certificate section of... » read more

Blazor App Deployment Error on New Development Computer – Failed to find a valid digest in the ‘integrity’ attribute for resource

Issue: Getting the following error when trying to deploy a Blazor Web App on a new development computer. Failed to find a valid digest in the 'integrity' attribute for resource 'https://xxxxx.azurewebsites.net/_framework/Newtonsoft.Json.dll' with computed SHA-256 integrity 'xxxxx'. The resource has been blocked. Unknown error occurred while trying to verify integrity. Uncaught (in promise) Error: A listener... » read more

Create a new local repository using TortoiseGit

In Windows folder explorer, right click on folder, TortoiseGit -> Git Create repository here… Note: Create an empty folder, clone it to DevOps project, and then add files to the empty folder. Create .gitignore file to ignore folders and files.