It pisses me off, as well.  It does help my scheduling of "urgencies" though. 😀  I keep solid records of such abuses of the word "Urgent".  I'm also not...

I've only played lightly, and found this interesting.

Nice to see a lot of you have budget for training, though without getting/taking time off, it's less useful. Easy to get too caught up in daily work and not...

If the server is started, the DAC helps. If it fails to start, you'd need to use a different switch (-g?) to fix memory.

If you restore a database, you restore users. If the logins that link to these by SID do not exist, you have orphans.

Using sp_helprevlogin will give you a script to...

I've used it to troubleshoot, wondering if two connections had different settings. Getting a raw number and comparing them worked for me. I haven't really used this to decode settings...

If you create the logins with the same parameters, yes, this will help. sp_helprevlogin does this.

Don't know that I'd disable it, but it is only for local connections by default. You can avoid allowing remote access, but still have local access if your server gets...

OK, I played with this a bit and got this to work:

$dt = get-date -format "_yyyyMMMdd_HHmss"

Invoke-Sqlcmd -Query "SELECT * FROM [dbo].[Customer]" -ServerInstance "Plato\SQL2017" -Database "Sandbox" |
Export-Csv -Path...

94% seems low

Updated the answers, apologies. I'll try to see if I can get correct those that answered #2 to #4.

As it should be

Did you track target server memory?

Likely you're missing something. SQL Server does use all the memory it can, loading up for buffering data. If data changed, this could account for...

I think you're conflating a couple things. First, Filestream allows access to the filesystem for work with C# (or other .NET apps) and will work more efficiently. You can just...

If you have a list of servers, you could do this in PoSh or with SQLCMD as well. The hard part is finding instances on the network, as they can...