Another possibility, and keeping it in the SQL Server family, would be through using OSQL. I use that technique to run my DBCCs every night using this CMD file:

osql...

A couple of thoughts.

First, try these, they might give you some ideas:

select * from master.sys.databases

select * from (your DB name).sys.database_files

The database_files view doesn't show the actual size of the data,...

Donald, as far as going with a web interface, I don't really do ASP.NET right now. When the time comes, maybe I'll be able to revisit it. I...

Donald Burr (7/16/2008)

---

Frankley, with the cost of storage as low as it is in my opinion it makes little sense to not keep every thing online, unless you are talking...

Jeff Moden (7/12/2008)

---

Heh... as you well know, it doesn't have to be something new to be abused... look at cursors and While loops... look at people storing dates as formatted...

Heh. I'm also an in-betweener, somewhere between klutz and DIYer. I also know my limitations. Just last weekend my wife reminded me to do something about her...

Steve Jones - Editor (7/11/2008)

---

... They're planing SQL 11, or about to, so I'd encourage Jeff to hit the MVP groups and post suggestions for the team there. Itzak will...

That's my one problem with the...

Multi-server query sounds cool, could be very nice for consolidating job execution and DBCC info. I'm VERY thankful for separate date and time data types, I like the combined...

I remember going to a Comdex in Vegas one year (mid/late 90's?) and seeing a...

K. Brian Kelley (7/10/2008)You've seen SQL Server MVP Linchi Shea's book, right? If not, here's the title:

Real World SQL Server Administration with Perl

It's from the SQL Server 2000 days, but...

I can't comment on shell scripts, but I've written two Perl programs to help me with day-to-day operations, and they save...

Steve Jones - Editor (7/6/2008)

---

...I think they should give you a VM of SQL Server, give you 20 things to do, and then evaluate the state of the VM to...

Lynn Pettis (7/3/2008)

---

Way back in the days of Novell, didn't their Novell Certified Administrator require that you have at least one year experience before awarding the cert, and your company...

Agreed, G^2. Like a degree, a cert might indicate knowledge. And it can help get your foot in the door. But it still boils down to needing...