Post reply

Are the posted questions getting worse?

  • July 26, 2016 at 6:57 am

    #1892029

    Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

    Before enabling TDE I would find the PageID of interest then calculate the offset and use a hex-editor to navigate to it within the MDF - here you can see the ASCII representation of the data.

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    thanks.

  • July 26, 2016 at 7:14 am

    #1892034

    BLOB_EATER (7/26/2016)

    Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

    Before enabling TDE I would find the PageID of interest then calculate the offset and use a hex-editor to navigate to it within the MDF - here you can see the ASCII representation of the data.

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    thanks.

    A couple things. First this should be it's own thread because we try to keep technical discussions away from the water cooler. Second, there is no content to this post. Did you forget an attachment maybe?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • July 26, 2016 at 7:36 am

    #1892041

    Sean Lange (7/26/2016)

    BLOB_EATER (7/26/2016)

    Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

    Before enabling TDE I would find the PageID of interest then calculate the offset and use a hex-editor to navigate to it within the MDF - here you can see the ASCII representation of the data.

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    thanks.

    A couple things. First this should be it's own thread because we try to keep technical discussions away from the water cooler. Second, there is no content to this post. Did you forget an attachment maybe?

    Ok fair point I will create a thread in the proper section. (No attachments I was trying to engage someone on the concept). thanks

  • July 26, 2016 at 7:45 am

    #1892044

    Phil Parkin (7/26/2016)

    ChrisM@Work (7/26/2016)

    BrainDonor (7/26/2016)

    Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns within an Excel spreadsheet.

    One day I would like to meet these people, but only if I have full immunity from prosecution.

    Very well put, Steve.

    If you like I'll hold 'em down whilst you perform the surgery.

    This is one team I'd like to be a part of.

    If we could also get hold of the related Excel team who believe it's OK to open a text/CSV file and, without warning, alter the data it contains – "because Excel knows best" – I'd pay handsomely.

    I would really like to have a discussion with the genius tool bag who thought scientific notation was the appropriate format for large strings of numbers :angry:

    I wonder how many hours are wasted each year forcing excel to open documents like that properly and explaining to less technical people that excel just mangled their data with no warning.

  • July 26, 2016 at 7:55 am

    #1892049

    BLOB_EATER (7/26/2016)

    Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

    Before enabling TDE I would find the PageID of interest then calculate the offset and use a hex-editor to navigate to it within the MDF - here you can see the ASCII representation of the data.

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    Yes.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • July 26, 2016 at 7:58 am

    #1892050

    BLOB_EATER (7/26/2016)

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    Yup. TDE = encrypted at rest, encrypted on disk, so hex editor sees garbage.

    DBCC Page would see the decrypted value, because decrypted in memory.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 26, 2016 at 8:27 am

    #1892058

    thanks Gail and Hugo. I'm off to do the write up now.

  • July 26, 2016 at 8:35 am

    #1892061

    ZZartin (7/26/2016)

    Phil Parkin (7/26/2016)

    ChrisM@Work (7/26/2016)

    BrainDonor (7/26/2016)

    Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the columns within an Excel spreadsheet.

    One day I would like to meet these people, but only if I have full immunity from prosecution.

    Very well put, Steve.

    If you like I'll hold 'em down whilst you perform the surgery.

    This is one team I'd like to be a part of.

    If we could also get hold of the related Excel team who believe it's OK to open a text/CSV file and, without warning, alter the data it contains – "because Excel knows best" – I'd pay handsomely.

    I would really like to have a discussion with the genius tool bag who thought scientific notation was the appropriate format for large strings of numbers :angry:

    I wonder how many hours are wasted each year forcing excel to open documents like that properly and explaining to less technical people that excel just mangled their data with no warning.

    Hey, who needs leading zeros, and who needs a 16 digit number with the 16th digit anyway? Even with the CSV file has double quotes around the number.

    I spend way too much time trying to convince people that sending data as an Excel spreadsheet is a bad idea.

  • July 26, 2016 at 10:00 am

    #1892091

    BLOB_EATER (7/26/2016)

    Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

    Before enabling TDE I would find the PageID of interest then calculate the offset and use a hex-editor to navigate to it within the MDF - here you can see the ASCII representation of the data.

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    thanks.

    I use XVI32 to examine mdf files. I create a table and insert "aaaaaaa" in a table. Then search for that in the hex editor. Then enable TDE and do the same thing.

  • July 26, 2016 at 12:05 pm

    #1892119

    Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position in December 2016. Anyone else ever interview someone from the future before?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • July 26, 2016 at 12:20 pm

    #1892125

    Jack Corbett (7/26/2016)

    Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position in December 2016. Anyone else ever interview someone from the future before?

    I haven't yet but it was a long time ago.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • July 26, 2016 at 12:24 pm

    #1892127

    Haven't seen the UK Kitchen spam in a while.

  • July 26, 2016 at 12:42 pm

    #1892131

    Lynn Pettis (7/26/2016)

    Haven't seen the UK Kitchen spam in a while.

    You're welcome.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • July 26, 2016 at 1:09 pm

    #1892139

    Sean Lange (7/26/2016)

    Jack Corbett (7/26/2016)

    Apparently the person I'm going to be interviewing shortly has access to and knows how to use DBCC TimeWarp since they started their current position in December 2016. Anyone else ever interview someone from the future before?

    I haven't yet but it was a long time ago.

    My favourite one was "6 years of experience in SQL Server 2008", submitted in 2009. Guess he must have been a master of DBBC TimeWarp.

    😎

    BTW, he didn't know T-SQL from HTML 😀

  • July 26, 2016 at 1:43 pm

    #1892146

    BLOB_EATER (7/26/2016)

    Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

    Before enabling TDE I would find the PageID of interest then calculate the offset and use a hex-editor to navigate to it within the MDF - here you can see the ASCII representation of the data.

    Then I would enable TDE and do the same as above but this time showing all sort of random characters - Im guessing this is the encryption taking effect? Is that right?

    thanks.

    yes

    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

Viewing 15 posts - 55,066 through 55,080 (of 66,712 total)

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