June 1, 2016 at 10:45 pm
Comments posted to this topic are about the item Certificate
Igor Micev,My blog: www.igormicev.com
June 1, 2016 at 11:15 pm
So, is the START_DATE by default set to one year ago?
I wanted to select one year, but given that it wasn't an option I selected 'never' (because in computer-life one year is an eternity)
June 2, 2016 at 12:32 am
jason-706424 (6/1/2016)
So, is the START_DATE by default set to one year ago?I wanted to select one year, but given that it wasn't an option I selected 'never' (because in computer-life one year is an eternity)
No, I say I created the certificate at Today's date previous year. The expiry_date is by default one year.
Igor Micev,My blog: www.igormicev.com
June 2, 2016 at 2:26 am
This was removed by the editor as SPAM
June 2, 2016 at 5:06 am
Thanks, Igor. Good question and very clear.
June 2, 2016 at 6:14 am
I repeated again the theme Encryption Hierarchy and Certificates 🙂 Thanks, Igor for this question and a clear explanation.
June 2, 2016 at 7:20 am
Great question. I couldn't find the answer that I "knew" was correct so I had to read the question a couple more times until I realized you stated you created the key a year 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/
June 2, 2016 at 8:39 am
It goes on for an year unless we mention any expiry date. V Nice B Teaser. I liked it. 🙂
Thanks.
June 2, 2016 at 11:07 am
Nice and straightforward. Thanks, Igor!
June 2, 2016 at 11:32 am
One note though, the expiration is ignored if the cert is used for encryption
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
June 2, 2016 at 3:43 pm
Nice clear question and explanation. Thanks Igor.
June 3, 2016 at 1:05 am
sjimmo (6/2/2016)
One note though, the expiration is ignored if the cert is used for encryption
No! It was exactly used for backup encryption. Backups are simply not done.
I think I read somewhere that the backuping continues without the encryption supported by the certificate when it expires, but it's not.
That's why I posted the question.
Igor Micev,My blog: www.igormicev.com
June 3, 2016 at 12:27 pm
Quite an amusing question.
At first I thought there was no correct answer, and re-reading it didn't shed any light. But the second time I re-read the question I was no onger skim-reading, and took in the statement that the certificate was created a year ago, and that made it very easy to answer the question. I know better than to skim-read specifications and requirements statements, but I seem to have difficulty applying the same common sense to QotD.
Tom
June 3, 2016 at 1:10 pm
That's interesting, as that is contrary to what MS says about encryption (not specifically backup). So the assumption is there. Learn something daily 😉
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
July 14, 2016 at 2:57 am
Didn't read the question very well missed the bit about one year ago, so disagreed with all the answers. But guessed at Today.
Doh!
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply