sqlnewbie17 (11/21/2015)

---

I have this powershell script as step 1 in a sql job.

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()

It creates a text extract with 4 columns as below.

ServerName ...

It is a depends answer but the likelihood...

I'm curious to know why you are using SMO's WMI class to get service information? It is much easier to just use Get-Service or win32_service:

Get-WmiObject win32_service | where {$_.DisplayName -match...

Based on version of SQL Server and if you are integrated into IIS or not.

If IIS is not being used you can simply go into the Reporting Services Configuration Manager...

I would think it would be because even if you disabled it from...

The problem you have with that script is in the way you are calling it.

Your script contains the line $instance = $args[0]. This line is is grabbing the value being...

It has come to be a more common thing to do for some reason. I have seen...

What is the error?

jonesg 74626 (11/3/2015)

---

In your article you use the term "Blade" to describe what looks to be features, plugins or modules of the portal. Why use the term "Blade", can you...

You are going to need to explicitly specify the columns most likely to deal with the conversion issue. Chrissy's script does not handle that, you can check the comments from...

I would also suggest starting here in BOL: Scripting and PowerShell with Reporting Services. The basic gist of it all is there are no native PowerShell commands to interact or...

It depends on what is your script doing, can you provide the script or an example? What version of SQL Server?

If you are not concerned with it and just to delete it all, just pipe that dir command to "Remove-Item -force".

If you need only certain files deleted then just...

You will generally design your packages with your connections parametized (SSIS 2012+) or using variables to build your connection string, which will provide your path to that file accessible in...

If remote command execution is open between the servers or computers you can use Invoke-Command:

Invoke-Command -Computer MYSERVER28 {(dir 'T:\System Volume Information').Count}