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

The “ZipDeployTask” task was not given a value for the required parameter “DeploymentPassword”.

Error: Get the following error when trying to Publish a Azure Function project to Azure site… The “ZipDeployTask” task was not given a value for the required parameter “DeploymentPassword”. Fix: 1. Right click my project and select Publish.2. Select the appropriate publishing profile.3. In the Summary section bellow select the “Edit Password” button (indicated by... » read more

VS Code (Visual Studio Code)

https://code.visualstudio.com/ Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. It comes with built-in support for JavaScript, TypeScript and Node.js and has a rich ecosystem of extensions for other languages and runtimes (such as C++, C#, Java, Python, PHP, Go,... » read more

Visual Studio Keyboard Shortcut

Key Action F5 Build Crtl + K + C Comment Line Crtl + K + U Uncomment Line Crtl + M + O Collapse All Crtl + Scroll Up Zoom In Ctrl + Scroll Down Zoom Out Printable Sheet Click to get our printable keyboard shortcut cheatsheet for Visual Studio Sources: https://docs.microsoft.com/en-us/visualstudio/ide/default-keyboard-shortcuts-in-visual-studio?view=vs-2019

Manage User Secret

File Location (For Local Development Environment) C:\Users\user01\AppData\Roaming\Microsoft\UserSecrets\e13a4f3c-0111-4fcc-bba1-11d7e67a1b6d\secrets.json Example Note: Need to create the same entry in configuration when deploying application to Azure. Each project will have a user secret file. Change the name of the project will create a new user secret file.