It's early days, but it's also all about marketing. Getting awareness of events or surveys is hard. I'd encourage you to share and send this to your colleagues and friends,...

I'm curious how many DBAs here actually have a say in cloud vs on-prem.  My previous company was a fortune 500 and I was on a team of DBAs. ...

Rod,

Cloud native: https://aws.amazon.com/what-is/cloud-native/#:~:text=The%20term%20cloud%20native%20refers,container%20orchestrators%2C%20and%20auto%20scaling.

Often involves containerizing, and thinking in terms of always transiting a multi-layer network, not a LAN. That often means ensuring you have retries, timeouts, more tenuous connections. Often...

Above, and cert type has to be right. I have been able to use a self-signed, but that isn't secure unless you drop it on every machine. What you really...

In EC2, it's the same as if you were doing this on-premises with any SQL Server instance in a VM.

There are requirements for the cert, and the config is...

You can do that to remove filestream.  The data then lives in the db.

If you migrate to a new architecture where you want links and files, you need to stream...

that's incorrect. It's not links to files. It's streamed a file into a hidden/inaccessable place in the file system that can be read back from t-sql and a win32 api....

What type of SQL Server on AWS? EC2? RDS? You need to be clear on the setup in the cloud.

We've given you straight answers, but I don't think you understand Filestream, so they don't make sense. You have to invest a bit to understand how this works to learn...

sorry, varbinary(max), not varchar. Too used to typing that.

The data is stored in the NTFS filesystem, but you can access it through T-SQL as with any other data. You don't...

I assume you have t-sql access to filestream data, as shown here: https://learn.microsoft.com/en-us/sql/relational-databases/blob/access-filestream-data-with-transact-sql?view=sql-server-ver16

If you don't want that data in filestream, create another column or table with a varchar(max) column...

Your code looks incorrect at the top.

Short answer: Index on column1 for the tables, as this will lower the amount of data you search.

Longer answer, please provide better DDL and...

Thanks, I have quite a few Spectre recommendations and not a lot of other strong ones.  I think I may aim for one of those with 32GB, when I find...

Robin, do you mean the Spectre keyboard is better than the Dell or vice versa? I have liked the Spectre, though not the trackpad. I find the left/right click to...