Capturing output from external commands in PowerShell

Great article on running external commands from PowerShell:

http://edgylogic.com/blog/powershell-and-external-commands-done-right/

Especially useful - information on capturing output from external commands in PowerShell:

for example:

& schtasks /END /TN $TaskName | Tee-Object -Variable scriptOutput | Out-Null Write-Host $scriptOutput

Powershell: Copy files from Network location

Copy-Item 

 -Path "Microsoft.PowerShell.Core\FileSystem::\\machine1\c$\log1.zip" 

 -Destination "c:\Logs\"

Capturing print output from SQL in PowerShell

Capturing verbose output through PowerShell object

Tabular query modes: DirectQuery vs In-Memory

Tabular query modes: DirectQuery vs In-Memory

 http://www.mssqlgirl.com/hybrid-mode-in-tabular-bi-semantic-model-part-1.html

Toggle Visibility Show As Expanded + – in SSRS

Very helpful post that describes how to set the group to be expanded by default and so that the signs are shown correctly (+ and -)

http://bicg.com.au/toggle-visibility-show-as-expanded-in-ssrs/

Connecting to SQL Server Mobile Report Publisher in SSRS 2016 RC2

I was struggling a bit with connecting to SQL Server Mobile Report Publisher in SSRS 2016 RC2. When I wanted to load data from Data Sets that are created in SSRS, I had to connect to SSRS first. I was presented with a very laconic UI, and I had to struggle with a couple of errors, without seeing any details of what was wrong.

 
Now, I eventually figured out that Server Address, apparently expects the URL of this type:

http://localhost/reports

and Username and Password are your Domain accounts and "Use secure connection" must be unchecked!

 


Only then it started working, and I was able to see my DataSets and Data Sources.