Post reply

TDE and Replication

  • June 8, 2011 at 10:37 pm

    #100763

    Comments posted to this topic are about the item TDE and Replication

  • June 8, 2011 at 10:39 pm

    #1336027

    Thank you Steve.

    M&M

  • June 8, 2011 at 10:45 pm

    #1336029

    Thanks,

    Thanks

  • June 9, 2011 at 2:09 am

    #1336076

    Simple 'yes' or 'no' meant there were no worries about this being a trick question.

    Nice one Steve.

  • June 9, 2011 at 4:57 am

    #1336167

    A 50/50 chance of getting this right and, at this time, 50% got it right LOL!! 😀

    Fortunately, I'm in the right half. Cheers Steve.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • June 9, 2011 at 7:05 am

    #1336248

    Except that they put NO on top and YES on bottom, which could be interpreted as a trick...:-D

  • June 9, 2011 at 8:07 am

    #1336322

    Good question, I'm suprised there are so many wrong answers.

    TDE is a Physical Data Encryption on Disk. The Data is not encrypted in memory when the pages are read off of disk.

    The only way the data at the other end of replication would have TDE is if it was enabled on that end.

    Twitter: @SQLBalls
    Blog: http://www.SQLBalls.com
    Channel: https://www.youtube.com/@Tales-from-the-Field

  • June 9, 2011 at 9:36 am

    #1336435

    Good question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 9, 2011 at 9:37 am

    #1336436

    Intriguing - at this point 51% of respondents have answered incorrectly.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 9, 2011 at 11:18 am

    #1336558

    Glad you liked it. Not sure you can read much into the distribution since it might be a guess for many of the correct answers. This wasn't to try and trick people, but either you know it or you don't, and if not, you learn.

  • June 9, 2011 at 1:03 pm

    #1336659

    *muttermuttermutter* I knew the correct answer. And I somehow picked the wrong one when I submitted it.

    Thanks for a very good question - people often don't pay attention to their assumptions when they are dealing with security issues like this.

    -Ki

  • June 9, 2011 at 1:09 pm

    #1336668

    Steve Jones - SSC Editor (6/9/2011)

    Glad you liked it. Not sure you can read much into the distribution since it might be a guess for many of the correct answers. This wasn't to try and trick people, but either you know it or you don't, and if not, you learn.

    Good point.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 10, 2011 at 10:32 am

    #1337117

    Steve Jones - SSC Editor (6/9/2011)

    Glad you liked it. Not sure you can read much into the distribution since it might be a guess for many of the correct answers. This wasn't to try and trick people, but either you know it or you don't, and if not, you learn.

    Well, the score now is 411 right, 347 wrong. The probability of getting that close to a 50-50 split if everyone thought they were just guessing (eg by tossing a fair coin to get their guess) is under 0.07 if my mental arithmetic is still up to scratch. Of course that doesn't really tell us anything about how much guessing there was, but it makes me think that maybe a lot of people thought they knew the answer (and about half of them were wrong), so that the split amonst those actually guessing was rather wider than 54%-46%.

    Anyway, it's a good question that points out a wee hole in security - you can use TDE on the distribution and subscriber databases, but it will still be in clear as it passes between the servers so you will need to encrypt their connection if you want to be really secure.

    Tom

  • June 10, 2011 at 11:08 am

    #1337153

    Anyway, it's a good question that points out a wee hole in security - you can use TDE on the distribution and subscriber databases, but it will still be in clear as it passes between the servers so you will need to encrypt their connection if you want to be really secure.

    Excellent point Tom.

    M&M

  • June 12, 2011 at 2:42 am

    #1337441

    Nice question, thanks.

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

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

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