SQLCMD mode is a script execution mode that simulates the sqlcmd.exe environment and therefore accepts some commands that are not part of T-SQL language. Just enable SQLCMD mode in SSMS (Query menu -> SQLCMD Mode) and the query will run fine. SSMS can also be configured to automatically enable SQLCMD mode in Tools menu -> Options... » read more
Issue: All – Visual Studio has an issue where it saves SQL files as UTF-8-BOM as default, which causes errors when concatenating for our DBAs. Please follow the attached instructions to install the “Fix File Encoding” Extension for Visual Studio. This will fix the issue by saving your SQL files as UTF-8 (without BOM) by... » read more
.NET workload wasm-tools .NET wordload wasm-tools-net6 Visual Studio -> Tools -> Command Line -> Developer Command Prompt Example: ********************************************************************** ** Visual Studio 2022 Developer Command Prompt v17.9.6 ** Copyright (c) 2022 Microsoft Corporation ********************************************************************** C:\Users\xxxxx\source\repos>dotnet workload list Installed Workload Id Manifest Version Installation Source --------------------------------------------------------------------- maui-windows 8.0.7/8.0.100 VS 17.9.34728.123 maccatalyst 17.2.8004/8.0.100 VS 17.9.34728.123 ios 17.2.8004/8.0.100... » read more
In Visual Studio, you can “Unload” project from a solution. It can be useful to unload a project from a solution while resolving circular dependencies between projects or conflicts with different versions of the .NET framework between projects. In Visual Studio, the “Unload Project” option allows you to temporarily remove a project from the solution... » read more
Get Latest from Main Branch In “Git Changes” window, go to Local -> main branch Do a “Pull” to get latest changes from main branch. Switch and select Local -> user branch Hover over “main” branch, right click and select “Merge into Current Branch” Push Changes to Main Branch In “Git Changes” window, “Commit” all... » read more
Create an new folder in your root Git folder. Then use Visual Studio to “Clone a repository” an existing Dev Ops project. https://org01@dev.azure.com/org01/TestDevOps01/_git/TestDevOps01 Files local.settings.json
Error: Getting the following error when trying to run a project from Visual Studio… Can't determine project language from files Solutions: Might be missing local.settings.json file from the project folder. Copy the file from the original project. References: https://github.com/Azure/azure-functions-core-tools/issues/2050
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
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
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