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.

Install SSIS for Visual Studio 2019

https://www.mssqltips.com/sqlservertip/6481/install-sql-server-integration-services-in-visual-studio-2019/ Adding the SSIS Projects extension to the Visual Studio 2019 When Visual Studio is opened, we click on “Continue without code” to add the necessary extension: In this window, we click on “Extensions” > “Manage Extensions”: In the search bar of the opened window, we type “Integration Services” to easily locate the extension. From the appeared list we choose “SQL... » read more