http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30043/

Uses PKZip, but you can modify to use the command line for WINRAR.

You can run frequent diffs, but they'll get larger and larger. For that matter, why not run a full every hour? You could do that and it would let you...

As mentioned above, a simple in the WHERE clause should do this.

This sounds like some test question or interview question. We are happy to help, but we want to...

Good points on your value and something I hadn't considered.

As an FYI, I actually have a balanced NCA where the I have to give xx notice and the company must...

RE-uploaded the file for the WMV. Hope that works.

localhost/mssqlserver is a named instance. (local) defaults to local (I think 127.0.0.1)

The /mssqlserver isn't necessary for a default instance. You'd just connect to the Windows machine name.

If you want to...

Agent shouldn't restart SQL Server. If it is, I'd call MS. Perhaps keep an eye on it to be sure it wasn't coincidence.

There are very few secrets. Is SQL Server doing something that Oracle can't? Hardly.

I heard Jason Fried of 37 Signals speak last week. He talked about how often they blog...

Thanks Keller, I've updated the feed. Not sure it's working, but that's the one I have from Mevio.

Feed broken at times, working on that, or I've been trying to get...

Read the articles by Jeff Moden. He covers some great basics you might want to avoid.

There isn't a good way to do this. You could script grabbing 10% of rows in all tables, but the issue is that you'll have FKs and child rows that...

Is there a unique index on the table?

Haven't seen the error, but I'm amazed it would restart the server. Did the SQL Server instance restart or was it Windows? Or SQLAgent?

I'd probably call Microsoft on this one.

You have a syntax error there with the name of the column. What is the column name of the table?

I think you're kidding, and I hope so. Soft Skills are important. Even in the military, where it's a top-down, no-nonsense, do what I say attitude, soft skills are needed...