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

Steve, you owe it to yourself to check out Framework.  You can get all sorts of snap in adapters to give your laptop complete flexibility when on the road. ...

Thanks, I'll check it out. I see a 15", which...

Steve, I really think you owe it to yourself to get a new laptop after five years.  It is always a hassle to get the conversion done, but worth...