It's definitely hard to do in the real world. However like Dave mentioned, you take notes, you document things, and you review the issues.

In terms of your VM issue across...

I'd agree on Express. CE doesn't have stored procs, which is an issue.

Good luck with the replication. It can be tricky, and the more you can limit what data can...

Changed it to a DMV from a table. We generically seem to use "table" for system tables, views, and DMVs, which isn't correct.

The question has been edited to say "batch"...

Buck wants to go back to the MMC, things like the right-click-MyComputer-Manage.

There were plug ins for managing SQL 2K.

I liked Enterprise Manager. Personally I'd like to replace SSMS with a...

Thanks, but even I've had periods where I haven't posted much. Course, I have to keep this baby going, so I don't get too much of a break.

I doubt I'll...

If you have separate domains, I don't think Windows Auth gives you much, and the need to sync passwords, to me, is a problem. Might as well be on the...

Likely he's busy and no time to post. Seems that people go through phases of posting and then stopping because of work.

I'll be out the next three days. Family in...

Dave Schutz (5/18/2010)

---

Sometimes in the midst of trying to solve a problem it is difficult to learn from the situation. One thing I've done is to take notes during the...

Are you a 8 hour a day company? Does business get done all day/night long? Those are good sized dbs, but not huge.

Also, is that data size, or database size?...

Ross Petersen (5/18/2010)

---

Now, I am not writing as a DBA or anything like that, but I have quite a lot of life experience and I am just wondering if because...

It sounds good overall. I don't ever append to files. If the file corrupts, especially with fulls, you're dead. Overwrite all the time, IMHO.

The thing to think about is recovery....

It could be DBAs or developers. There's no definite way to define this, however it should be someone that understands how to do it.

They'll also learn not to do that, or how to shrink it themselves.

Auto shrink causes more problems, performance problems, and isn't worth it. This is one of those cases where...

You need to split the file name into strings. You can use searches to find the slash and the period and get the substring between them.

Some hints:

http://www.sqlservercentral.com/Forums/Topic679052-148-1.aspx

http://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/an-introduction-to-the-ssis-expression-language.aspx

Build a resume like you would for any job. Focus on your SQL skills.

Here are some hints. http://www.groovejob.com/resources/resumes/tips.html