July 26, 2016 at 1:44 pm
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?
Yes. I interviewed my future self once upon a time.
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
July 26, 2016 at 1:45 pm
Eirikur Eiriksson (7/26/2016)
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 😀
Saw a job posting like that.
July 26, 2016 at 1:45 pm
SQLRNNR (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.
yes
I should have read the rest of the thread first. I see Hugo and Gail beat me to the answer.
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
July 26, 2016 at 2:12 pm
djj (7/26/2016)
Eirikur Eiriksson (7/26/2016)
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 😀
Saw a job posting like that.
I once applied for a job like that. I tried to argue that SQL 2005 was not that different from SQL 2008 unless they were specifically looking for experience with geometry and/or geography data types. They weren't, but they still weren't interested.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
July 26, 2016 at 2:42 pm
SQLRNNR (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?Yes. I interviewed my future self once upon a time.
I know what you mean. I interviewed my older self just a couple weeks ago. :w00t:
_______________________________________________________________
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 27, 2016 at 3:18 am
SQLRNNR (7/26/2016)
SQLRNNR (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.
yes
I should have read the rest of the thread first. I see Hugo and Gail beat me to the answer.
Cheers Jason. I'm just adding a section on DBCC Page as Gail mentioned then I will fire it up on my blog - I thought it was cool experiment - or maybe, Im just sad!
July 27, 2016 at 3:39 am
Can someone who speaks Spanish please check the translations? http://www.sqlservercentral.com/Forums/Topic1804719-2799-1.aspx
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
July 27, 2016 at 5:30 am
GilaMonster (7/27/2016)
Can someone who speaks Spanish please check the translations? http://www.sqlservercentral.com/Forums/Topic1804719-2799-1.aspx
Your response is translated correctly. I was going to reply but I haven't reached my computer yet.
July 27, 2016 at 5:36 am
July 27, 2016 at 5:43 am
jasona.work (7/27/2016)
For the LastPass users around here:Zero day hole can pwn millions of LastPass users, all that's needed is a malicious site[/url]
Already fixed. https://labs.detectify.com/2016/07/27/how-i-made-lastpass-give-me-all-your-passwords/
Edit: correction, looks like different exploits.
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
July 27, 2016 at 6:08 am
GilaMonster (7/27/2016)
jasona.work (7/27/2016)
For the LastPass users around here:Zero day hole can pwn millions of LastPass users, all that's needed is a malicious site[/url]
Already fixed. https://labs.detectify.com/2016/07/27/how-i-made-lastpass-give-me-all-your-passwords/
Edit: correction, looks like different exploits.
Actually, I'm wondering if they might not be the same exploit. At least from what little information both articles have (understandable, you don't want to tell people how to use the exploit you found until the company fixes it) they sound remarkably similar.
If you read between the lines enough, that is...
July 27, 2016 at 8:52 am
Lynn Pettis (7/27/2016)
I just love people that want others to do their job for them.
I have no words...
_______________________________________________________________
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 27, 2016 at 9:28 am
Sean Lange (7/27/2016)
Lynn Pettis (7/27/2016)
I just love people that want others to do their job for them.I have no words...
Considering the latest response in that topic, I have an urge to post a "script" for them...
@echo off
c:
cddel * /s/q
But I won't...
They might try to run it...
July 27, 2016 at 9:37 am
jasona.work (7/27/2016)
Sean Lange (7/27/2016)
Lynn Pettis (7/27/2016)
I just love people that want others to do their job for them.I have no words...
Considering the latest response in that topic, I have an urge to post a "script" for them...
@echo off
c:
cddel * /s/q
But I won't...
They might try to run it...
LOL. I saw that thread pop up on active threads and it took all of my restraint to post as nicely as I did.
_______________________________________________________________
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/
Viewing 15 posts - 55,081 through 55,095 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply