SQL Server 2016 SP1 Features

Question

SQL Server 2016 SP1 Features

Steve Jones - SSC Editor

SSC Guru

Points: 736063
More actions
December 8, 2016 at 9:27 pm

#100944

Comments posted to this topic are about the item SQL Server 2016 SP1 Features

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

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

TjhomasH6610 SSCommitted Points: 1690 More actions · Answer 1

Good question Steve, but the reference supplied specifically states that Transparent Data Encryption is not available on Standard Edition.

😀

Uwe Ricken Hall of Fame Points: 3169 More actions · Answer 2

Hi Steve,

hmm - TDE is not SE but EE.

Parikshit Savjani (MSFT): "TDE is Enterprise edition only"

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

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

According to the official resource it's indeed Enterprise only.

https://msdn.microsoft.com/en-us/library/cc645993.aspx

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

Neil Burton SSC-Insane Points: 22993 More actions · Answer 4

I got it wrong because I looked here. I think, assuming the answer is correct, a lot of people will be caught out.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Uwe Ricken Hall of Fame Points: 3169 More actions · Answer 5

Hi Koen,

NO - TDE is EE only. Extract from the official resource:

Feature | EE | SE | ..

TDE | Yes | NO |

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

Mick Fitz Hall of Fame Points: 3215 More actions · Answer 6

Good question Steve, but the reference supplied specifically states that Transparent Data Encryption is not available on Standard Edition.

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

Uwe Ricken (12/9/2016)
Hi Koen,
NO - TDE is EE only. Extract from the official resource:
Feature | EE | SE | ..
TDE | Yes | NO |

I know it's Friday. Maybe you need some coffee first 😉

According to the official resource it's indeed Enterprise only.

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

Uwe Ricken Hall of Fame Points: 3169 More actions · Answer 8

Koen Verbeeck (12/9/2016)
According to the official resource it's indeed Enterprise only.

Don't worry Koen,

forgiven - you are an expert for BI 🙂

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

far SSCertifiable Points: 6568 More actions · Answer 9

"Transparent data encryption" remains an Enterprise Edition Feature and isn't available on Standard Edition

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

paul s-306273

SSChampion

Points: 10730

December 9, 2016 at 2:33 am

#1916986

Got the point, so happy after yesterday!

radek.hruby SSCrazy Points: 2123 More actions · Answer 11

radek.hruby

SSCrazy

Points: 2123

December 9, 2016 at 2:52 am

#1916989

TDE is Enterprise only.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

Yep, many have already pointed out the error. Wishful thinking, but they have to leave something for EE other than CPU and memory limitations.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

tom.w.brannon Hall of Fame Points: 3976 More actions · Answer 13

I confused TDE with 'Always Encrypted' and got it 'right'.

Budd Hall of Fame Points: 3781 More actions · Answer 14

???

https://msdn.microsoft.com/en-us/library/cc645993.aspx

???

A Man of few words speaks too much.