What are you protecting from? If you have the machine fail, there's no HA. If you think the db files might fail, I guess you could back up and restore...

Why replicate? I'm not sure what you want to do. The distributed transaction is less of an issue on the same server, with SELECT queries, and more with writes.

There is a lot of legacy code out there using text/image, and various other features. Large customers especially, and large vendors (think ERP, Accounting, etc.) that have legacy code they...

I do use Google photos now, and try to back up the important ones locally (and to Backblaze). I'll grab a set from my phone via USB and keep them...

Please don't run code you don't understand without working with it in production. You noted you had a test database, which is slightly better, but what if I had malicious...

Ah you BI people always cause problems.

good point. Need to submit a change for the docs and update the question to say rowstore.

I'm not sure what you mean. Do you mean change the LSN sequence? Full/diff backups don't change this. The log backups work with the LSN. The subsequent full/diffs can be...

Agree with Scott.

I usually check for NULL with parameters and skip the update if there is nothing to change.

bcp is a command line tool, so use a command line step

Are the files growing?

I assume you mean upper case? I'm not familiar with high case.

You would have to write code that does this for each table/column. There isn't a good way....

As with a SELECT, if there is no ORDER BY, you can't control which row comes first or last. In this case, you could get either row.

Scott has...

I used Docker for Windows, though I'm running Linux containers with the WSL (Windows subsystem for Linux).

For Linux, depends on  OS.  There is a docker application which...