That certainly will help with SQL skills, but it doesn't necessarily help you with larger projects.

I'd try a few different things and see what works best for you.

That's a good one.

Or if you want to make things easier, at least for me, use DAY(), MONTH(), YEAR() and concatenate those (after casting to char)

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/analyzingdatastoragetenshowcontigqueries/1438/

or examine this script to learn a few things

http://www.sqlservercentral.com/scripts/Index+Management/30041/

If you have more questions, you need to ask specific questions, not just say you don't understand everything.

Hopefully you're not using notepad/wordpad to open backup files. They're not in human readable format.

Why not just script out the database before each deployment? Then you can use that for...

Thanks and hopefully all the SSC isn't too big a vice. I'd like to think it has some positive benefits in there as well.

I'll concur on the DVR. I rarely...

The 2GB limitation is for Standard edition, regardless of the OS.

The limitations for Enterprise edition vary depending on the host OS.

I think it's personal preference. I'm a leading comma guy.

I don't think you can fake out the tape interface.

Will the virtual tape back up files? Any reason why you can't just have it grab the backup files from...

Actually everything below the "use" is what you would put into the DTS task.

Put the definitions for the variables inline in the code in place of the variables.

Boy that code is a bit of a mess. Is there any chance you could distill down what you are trying to do with the tables?

It would seem that you...

OK, I definitely missed out. Need to go watch this on the PASS site.

Or other issues.

Sorry for the delay

http://www.sqlservercentral.com/articles/Editorial/64933/

To become and expert, you need experience. You need to do things and work on them.

You might be able to get experience at some place like Rent-a-coder, or volunteer for...