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

Preparation is tough, though I think for many people the tradeoff is reduced stress. At least, once you've presented a few times.

Always love seeing new presenters at events, and I...

My employer standardizes on Dell for everything.  Aside from the "Dell Tax" the only complaints I've ever had with them are a spat of bad batteries 5-6 years ago...

Steve, I also have an HP Spectre laptop, which is about 5 years ago. (I'd love to know how you were able to determine the age of your laptop.)...