There is no guarantee that the ports will be the same on a restart. That's why your clients contact the server on 1434 and then get the port for that...

Do you mean you have two sets of tables and you are replicating both to a single table on the subscriber?

If you're turning replication on and off, you might lose...

Two versions tend to be tested/supported on the OS. So I'd expect SS2K5 and SS2k8 were tested on W2K8.

I'd actually look at 2008 as a more stable version of 2005....

You can find deals as well. I got TechNet a few years ago when I took an exam. I got MSDN with my MVP award.

The Express editions will get...

It would seem that they don't know a lot of T-SQL, but that doesn't necessarily mean they can't learn it or aren't a good DBA. plenty of people use the...

Interesting question. Posters in the last year is about 20k, not a lot. But that's the nature of the Internet. Most people lurk or read and don't participate. I've got...

No guns at work. Chances are we're run out of developers and have to go code things ourselves. Now truncheons....

I thought this was a little silly shooting the podcast, or...

A full backup doesn't back up the log. There might be log entries of the database is under heavy use as the backup is running as there could be the...

We'll probably feel like we're in a purple haze as more apps get built with this thing!

Or use a single backup job, drop parameters in a table, let the job run pick up parameters (db name, type of backup, path to file, etc.) from the table....

I thought that the backup would run under the context of the service account for SQL Server. You submit the request under your SQL login, but the service account for...

You need to track the usage of space over time to know if you need to add more space. In general you want enough space to last 2-6 months, so...

Did you upgrade or not? You cannot have two default instances, yet you say you had a 2000 default and chose default not upgrade during the install.

I suspect that you...

You could detach and attach, but I suspect you'll need to alter the log shipping jobs at some point. The log restores should pick up, but not sure how that...

Each file has to be a query. It seems you have that. You use SQLCMD to just execute that query. The file contains the same thing that you would execute...