Amazon has this book listed, but I haven't actually seen it for sale anywhere. And even Amazon doesn't seem to know where to find it:

http://www.amazon.ca/MCITP-Self-Paced-Training-Exam-70-446/dp/0735623848

That might give you a...

I prefer transceder myself. That's after using the Self-Paced training kits and their included practice exams.

Can you backup while the database is online? If so, how?

Believe it or not, people actually ask that question (though I've never heard it in an interview).

Well this just stinks. Now I have an extra hour that I have to fill with actual work related things... @=Pbt.

What to do... what to do. I know!...

Rescheduled? I registered for the event and haven't heard anything back about it being rescheduled. Are they not letting the pre-reg attendees know?

You can also set logging in the job step where the package is run. Send it to a text file and see what it says.

I'm wondering if the job...

Where can backup files be saved? What native tools does SQL Server provide for creating backups? How would you access those tools? How would you retrieve the...

Wow. I am so learning a lot from this thread. I thought I knew details about our SAN. Until I looked at the chart and realized the...

There is a time limit, but if you know your way around, this isn't an issue.

The questions aren't terribly complicated. You don't have to do 50 things before the...

There are a couple of ways you can do it.

A) Write a script task (C# .Net or VB .Net) on SSIS and run that job on a scheduled...

The PBT for exam 431 is totally SSMS based. Essentially, you need to open up Management Studio, going through the Object Explorer bit by bit and figure out how...

You're welcome.

Let us know if you have any other questions.

Sounds like a plan. @=)

You can pretty much start anywhere. Here's a link to all the SQL Server certs: http://www.microsoft.com/learning/mcp/mcitp/default.mspx

Only three of the certs on that page are relevant to SQL Server....

You should at least know the syntax to the basic commands and some of the newer stuff. There are multiple choice questions which ask you about syntax and what...