TDE and In-Memory OLTP

  • psingla

    Hall of Fame

    Points: 3840

    Comments posted to this topic are about the item TDE and In-Memory OLTP

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • patricklambin

    SSCrazy Eights

    Points: 9964

    TDE and In-Memory OLTP are far to be my favorite topics ( truly I am a beginner ) and I have to admit that if I provided the good answers , it is only because I attended a session about this topic during the Paris SQL Server days last year. As I have a good remembrance , I got easily one point . Anyway , thanks for the person who succeeded to explain fully and plainly this "hard" topic.

  • This was removed by the editor as SPAM

  • edwardwill

    SSCertifiable

    Points: 5131

    An interesting question, but slightly spoiled by the format of the answers (select three from five, where two pairs were mutually exclusive, meaning that the singleton must perforce be one of the true answers)

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, Pramod, interesting one. I was sure of two except the filegroup one and had to check on that.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • david.gugg

    SSCertifiable

    Points: 5693

    Wait, so if the memory optimized filegroup is not encrypted, does that mean the data is vulnerable? Should in-memory OLTP tables not be used with sensitive data?


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • sestell1

    SSChampion

    Points: 10230

    david.gugg (2/19/2015)


    Wait, so if the memory optimized filegroup is not encrypted, does that mean the data is vulnerable? Should in-memory OLTP tables not be used with sensitive data?

    Encrypted filegroups are also decrypted while in memory.

    "Encryption of the database file is performed at the page level. The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory. "

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

  • SQL_kode_kracker

    Right there with Babe

    Points: 732

    good piece of information:-)

  • TomThomson

    SSC Guru

    Points: 104773

    sestell1 (2/19/2015)


    david.gugg (2/19/2015)


    Wait, so if the memory optimized filegroup is not encrypted, does that mean the data is vulnerable? Should in-memory OLTP tables not be used with sensitive data?

    Encrypted filegroups are also decrypted while in memory.

    "Encryption of the database file is performed at the page level. The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory. "

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

    Yes, but for the in-memory stuff the checkpoint files aren't encrypted either - so the data is not encrypted when secured.

    Tom

  • SQL_Hunt

    SSC-Dedicated

    Points: 33450

    I think in such questions where it's asked to choose multiple correct answers, it will be good to have more points rather just 1. Thoughts?

    Thanks.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    SQL-DBA-01 (2/19/2015)


    I think in such questions where it's asked to choose multiple correct answers, it will be good to have more points rather just 1. Thoughts?

    Sometimes they have more points. Sometimes they don't. 🙂

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

  • Ed Wagner

    SSC Guru

    Points: 286982

    Nice question. I haven't gotten to play with 2014 yet at work, so I had to do research to find the answer. I always enjoy learning something new. 🙂

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

Viewing 14 posts - 1 through 14 (of 14 total)

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