October 2018 – Knowledgebase

Sonar Cloud and Azure DevOps – Fixing [SQ] Task failed with status FAILED

30 October, 2018 Roel van Lisdonk 0 Comments 1 category

A pull request build in Azure DevOps failed with the error: “[SQ] Task failed with status FAILED”. This was the only information given, when de build failed. Luckily, the manual build gave more information: Error:

How to connect to a localdb instance with SQL Server Management Studio 17.9

10 October, 2018 Roel van Lisdonk 0 Comments 1 category

When Microsoft Visual Studio 2017 is installed, LocalDB is installed by default. To connect SQL Server Management Studio to this instance, just use: LocalDb\MSSQLLocalDB

Fix: Calling a function with multiple parameters in PowerShell, merges all parameters in the first parameter as an array

5 October, 2018 Roel van Lisdonk 0 Comments 1 category

When you call a PowerShell function, that expects multiple parameters, with parenthesis, all parameters will be merged in the first parameter, as an array. The solution is, to call the function with named parameters.

Calling a function from another PowerShell script file in the same folder with “relative path”

5 October, 2018 Roel van Lisdonk 0 Comments 1 category

If you want to execute a function from another PowerShell script file, you can “dot-source” the file. The “.” is a special operator in PowerShell that can load another PowerShell script file en import

Fix: Power BI POST request returns a 500 Internal Server Error

5 October, 2018 Roel van Lisdonk 0 Comments 1 category

When posting to the Power BI api uri: https://api.powerbi.com/v1.0/myorg/groups in PowerShell version 5.1.17134.228, I got the error: The remote server returned an error: (500) Internal Server Error. I invoked the Power BI rest api

Month: October 2018

Sonar Cloud and Azure DevOps – Fixing [SQ] Task failed with status FAILED

How to connect to a localdb instance with SQL Server Management Studio 17.9

Fix: Calling a function with multiple parameters in PowerShell, merges all parameters in the first parameter as an array

Calling a function from another PowerShell script file in the same folder with “relative path”

Fix: Power BI POST request returns a 500 Internal Server Error