TDE and Filestream

Question

Post reply

TDE and Filestream

Steve Jones - SSC Editor

SSC Guru

Points: 736063
More actions
June 28, 2011 at 10:29 pm

#243381

Comments posted to this topic are about the item TDE and Filestream
June 29, 2011 at 12:47 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 64 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

So are these incorrect:

http://msdn.microsoft.com/en-us/library/bb934049.aspx

which states:

FILESTREAM data is not encrypted even when TDE is enabled.

And:

http://msdn.microsoft.com/en-us/library/bb933993(SQL.100).aspx

FILESTREAM data is not encrypted even when transparent data encryption is enabled.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 2

Come on, Steve! Make a decision. You cannot have both 🙂

Best Regards,

Chris Büttner

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 3

Hi Ron,

these pages are correct.

Only the Answer & Explanation of this QOTD are paradox.

While the Explanation is correct, the Answer is wrong.

Best Regards,

Chris Büttner

M&M SSC-Insane Points: 21700 More actions · Answer 4

M&M

SSC-Insane

Points: 21700

June 29, 2011 at 12:00 am

#1345641

We will get our points back for sure 🙂

M&M

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Whoops, apparently it is backwards-day today 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

dawryn SSCertifiable Points: 5475 More actions · Answer 6

This post from yesterday's QOTD comes even more appropriate :Whistling:

Carlton Leach (6/28/2011)
Have you been drinking Steve? :hehe:

Christian Buettner-167247 (6/28/2011)
Only the Answer & Explanation of this QOTD are paradox.

:w00t::hehe::Wow:

Ant-Green SSC Guru Points: 113498 More actions · Answer 7

Glad I am not the only one questioning this, was pretty sure that filestream wasn't encrypted

cesarabreu SSC Journeyman Points: 99 More actions · Answer 8

cesarabreu

SSC Journeyman

Points: 99

June 29, 2011 at 1:44 am

#1345693

Me too

Parky_M Mr or Mrs. 500 Points: 585 More actions · Answer 9

I agree that the correct answer should be 'No' as the explanation confirms this but the correct answer doesn't.

:unsure: At first I thought I misread the question but after reading it several times I am convinced the correct answer should be 'No'.

khelloufsofiane 6183 SSC Eights! Points: 942 More actions · Answer 10

Hello,

The question was "is the FILESTREAM data encrypted?"

and my avswer was No, Doesn't that mean the FILESTREAM Data is not encrypted ????? !!!!!!!!!!!!

.

paul s-306273 SSChampion Points: 10730 More actions · Answer 11

I'm not surprised at the number of posts so early in the day.

I thought I had the correct answer...

Mike McQuillan SSCertifiable Points: 5999 More actions · Answer 12

Same here, I confidently clicked "No" and was shocked to be told "Yes"!

Further shock ensued when I read the explanation and the "No" answer was confirmed...

Mike.

murray-906152 SSCarpal Tunnel Points: 4965 More actions · Answer 13

Unusual to had two dud QotD's in a row ...

At least there is very little point arguing about / discussing today's QotD.