SQL Server is, by default, case insensitive; however, it is possible to create a case-sensitive SQL Server database and even to make specific table columns case sensitive. The way to determine if a database or database object is to check its “COLLATION” property and look for “CI” or “CS” in the result. CI = Case Insensitive... » read more
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
Error: Resolution: Sources: https://www.sqlserver-dba.com/2012/12/sql-server-alter-index-failed-due-to-quoted-identifier-.html
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
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
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
The following needs to be setup and installed … Microsoft DevOps site Tortoise Git RedGate Source Control Steps Create new project in DevOps. “Git Clone” to directory using Tortoise Git. Link to local Git repository using Red Gate Source Control for SSMS. Edits Make edits to database object. Commit changes via Red Gate Source Control... » read more
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
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
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