A New SMK

Question

Post reply

A New SMK

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
January 5, 2012 at 9:01 pm

#391250

Comments posted to this topic are about the item A New SMK

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

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Nice easy question to end the week ....

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Yay - I got it right.

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

Revenant SSC-Forever Points: 42467 More actions · Answer 3

SQLRNNR (1/5/2012)
Yay - I got it right.

+1, but it was not obvious.

I mark this one as 50 percent educated guess, 50 percent luck.

Revenant SSC-Forever Points: 42467 More actions · Answer 4

But I forgort to thank Steve for the challenge -- so here we go: thanks, Steve!

M&M SSC-Insane Points: 21700 More actions · Answer 5

M&M

SSC-Insane

Points: 21700

January 6, 2012 at 3:03 am

#1429506

Thank you Steve, got me thinking 🙂

M&M

Ryan Barrett Right there with Babe Points: 731 More actions · Answer 6

Thanks.

I was fairly sure of my answer... but admit to doubting myself just a bit.

Nice to see I got it right.

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Good question.

Needed more thought than usual to get the answer - my first reaction was that it's created by magic when sql server is installed, but I could see that was wrong because that wasn't one of the options, so I had to think what would trigger its creation.

Tom

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 8

very good question!!!

I learned more thing!!!!!!

thanks Steve!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

george sibbald SSC Guru Points: 104210 More actions · Answer 9

slightly crafty steve, but I got it.

Interestingly, MS advise one of the first things you should do on installing an instance is backup the service master key, and this indeed you can do even though encryption has not been activated. So what in fact are we backing up at that point?

---------------------------------------------------------------------

rothj Hall of Fame Points: 3343 More actions · Answer 10

I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 11

rothj (1/6/2012)
I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.

I should have had that as an option. 😉

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 12

Steve Jones - SSC Editor (1/6/2012)
rothj (1/6/2012)
I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.
I should have had that as an option. 😉

I would likely have fallen for that trap also! Tks Steve

Mattrick Ten Centuries Points: 1176 More actions · Answer 13

Steve Jones - SSC Editor (1/6/2012)
rothj (1/6/2012)
I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.
I should have had that as an option. 😉

You would have tripped me up with this, for sure. As it stands, I did answer this question correctly.

Thanks and have a good weekend,

Matt

Paul White SSC Guru Points: 150467 More actions · Answer 14

Three in a row wrong!!! :crying:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi