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...

It seems like you're talking about two things here. Not sure what temporal tables have to do with the tokens. Usually you are hashing somehow to create this token to...

Closing this. Please post at: https://www.sqlservercentral.com/forums/topic/update-start-date-using-end-date-3

These questions are not always designed to cut and paste code. They are really designed for you to think and solve on your own, without a computer. If you use...

There are checklist for every transaction I've had. A checklist to be sure everything is signed, and checklists ahead of time to be sure that all items, like title searches,...