SQL Browser is on for all nodes. Instances are all named. Users normally go through apps, never direct connect. We found through testing that the port number was required, even...

Thanks Johan. Specifically, I was referring to SQL aliases. I assumed they would need to be on all servers, so I added them to all nodes. We are using CNAMES...

Thanks Steve. That was my next step. I was going to do some testing, to see what happens, but you beat me to it.  I just thought if someone already...

I have sized most of the others, to the anticipated size.  The largest one, that I am trying to reduce, has no free space, and if I use the emptyfile,...

I have multiple file groups, primary, data, index, and lob. I am trying to balance the data across all of the individual files. I am not doing the primary just yet....

Attached is what I use. The attached code executes from a SQL Server agent job. You will need to add your own instance list processing, and update the smtp...

Is there a firewall or proxy issue? I have never had an issue with SSMS, but other products I try to update are blocked by our internal security.

Leonard

As far as I know, there isn't any way to do this. There are some job variables, within the SQL job that can be used, but probably not what...

Yep. That's how I collect data to monitor db growth, get missing backups etc. No need to execute SQL in many cases.

Leonard

As I said, this was just some code I threw together, and didn't test. You need to add this:

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null

That command is actually being deprecated, but I don't like...

Attached is code that I use to get missing backups, and email the report. This may give you some additional ideas.

Leonard

I don't have exactly what you need, but I have several pieces of code, that do some of these. For example, I have code to format to html and send...

Here is some code I use. Hope it helps.

$Drives = Get-WmiObject -Class Win32_Volume -ComputerName $InstanceName -Filter "DriveType = 3" | Where-Object { $_.Name -notlike "\\?\Volume*" } | Sort-Object Caption ...

ok, I'm an idiot. Just realized the ask was for adding a role, not a member to a role. That one we didn't automate.

There are a lot of reasons for doing this through Powershell. We have automated quite a few things, including creating or duplicating a login. Being able to do add...