ALTER INDEX failed due to QUOTED IDENTIFIER set to OFF
Error: Resolution: Sources: https://www.sqlserver-dba.com/2012/12/sql-server-alter-index-failed-due-to-quoted-identifier-.html
Author
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
Add Source Control to SQL Database Using DevOps, RedGate, and Tortoise Git
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
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.
Add existing Visual Studio project to existing DevOps Repo.
Current Setup An existing Visual Studio project without any source control links. An existing DevOps project with default Repo Step 1 – Open up existing Visual Studio project and create a local Git Repo Create a new local Git repo for your Visual Studio solution, by right-clicking the solution name in Solution Explorer, and then selecting Create... » read more