Post reply

TDE and In-Memory OLTP

  • February 18, 2015 at 9:17 pm

    #301408

    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/

  • February 18, 2015 at 11:07 pm

    #1778534

    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.

  • February 19, 2015 at 12:53 am

    This was removed by the editor as SPAM

  • February 19, 2015 at 1:29 am

    #1778551

    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)

  • February 19, 2015 at 2:10 am

    #1778568

    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.

  • February 19, 2015 at 7:17 am

    #1778628

    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?

    Be still, and know that I am God - Psalm 46:10

  • February 19, 2015 at 7:44 am

    #1778638

    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

  • February 19, 2015 at 10:51 am

    #1778717

    good piece of information:-)

  • February 19, 2015 at 3:02 pm

    #1778788

    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

  • February 19, 2015 at 6:06 pm

    #1778823

    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.

  • February 20, 2015 at 2:24 am

    #1778889

    Nice question, thanks.

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

  • February 20, 2015 at 2:24 am

    #1778890

    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

  • February 20, 2015 at 6:12 am

    #1778920

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

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

  • February 23, 2015 at 12:51 pm

    #1779393

    Thanks for the question.

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

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