Check out Microsoft's certification offerings at http://www.microsoft.com/learning/mcp/mcdba/Default.asp

And welcome to the wonderful world of MS Sql Server!

When I first started at my present job, there was no concept of user testing. It was basically the developer doing his own testing on his machine and then deploying...

Cory,

This has been a very interesting and helpful thread. Can you please confirm that in the end, steps 1 and 2 were all you needed to do to solve the...

Jorge,

Did you ever sort out a way around this? I'm trying to do the same thing. I've had to code it as a stored procedure but that makes my solution...

Thanks Dylan.

I'm not sure what you meant by setting up the identity ranges to be compatible but I think I might.

It likely won't apply to us, however, because if we do...

Cheers.

I actually got this correct but I think there was a typo in the question. I assume the question should have said the table was deleted at 11:55 am instead...

I have taken more than 15 Microsoft exams over the years (haven't failed any yet but have come close once or twice!). I definitely find Transcender to be a useful part of...

Interesting. Thanks!

Remi,

I hadn't even got that far with the user. I didn't think it was particularly relevant.

Thanks for your interest nonetheless. I don't think I need anything further.

- Mike

Thanks ... I was aware of the Identity/temp table solution but was hoping for a single statement solution.

It sounds like it isn't possible. That's okay ... I was just wondering.

P.S....

I thought we just had this question or something very close to it!

Carl,

I obtained my MCDBA about two years ago. I definitely feel it was worth it as it helped me move from a unsatisfying job to a fantastic one.

Like most DBAs, I...

When I said I had written over 15 exams, I meant I had taken over 15 exams not authored them as somebody asked me to clarify.

Jon,

I think your decision to take a Transcender exam was a good one. Don't worry too much about the 65%; it has been my experience that the Transcender exams are...