I approached one employer about this when I found that they didn't really need a 40hour a week DBA. They did need some on-call, after hours support, and I said...

The compatibility mode changes the way keywords are handled in SQL Server. There were lots of words that were valid in v6.5 that became reserved in v70 and above (ie...

Interesting numbers.

So are costs higher in physical businesses or are software companies taking advantage of their lower costs and charging more? Is there value in what they're providing?

If you have the 2005 client, the SQL Native Client, then you put two entries in there for the mirrored servers and they automatically reconnect if the primary has failed.

http://msdn.microsoft.com/en-us/library/ms366348.aspx

It's...

The newsletter is new each day. We don't have things go from day to day, except perhaps the forum threads, and those reappear if they've had a new post in...

Block the users from the database with the firewall. More rules, not so elegant, but it solve the issue.

Right now, there's no way to change this. There have been suggestions...

Perhaps put them in a separate filegroup? Maybe then work with that separately?

Or add an "image" filegorup, put the data in, then add another one at some point, delete the...

There was a way in SQL 2000 to perform an MD5, one way encryption of data, and ENCRYPT() works on my SS2K instance.

However this cannot be decrypted. You can "compare"...

No standard way of doing this. If you have Enterprise edition, I'd look at table partitioning and moving those older partitions to separate file groups.

You can make a view instead...

If you are in simple mode then your logs will be truncated at each checkpoint, and space used by committed transactions marked as free.

However, you cannot recover work beyond your...

Rinu's explanation is the best.

The advice is to run with full mode, unless you need to run a bulk operation, in which case, you can switch (online) to bulk...

I would guess that most people would be using only one of these, so I'm not sure you will get a comparison.

I don't know about the CBTs, but the books...

I know that GIS is heavily used, but I'm definitely not aware of how extensively it's implemented. The "finding directions" and mapping is stuff I've seen, but the shortest paths,...

SQL Server 2005 is a single instance. It is self contained. If you install multiple instances, they are all installed on Windows as separate pieces of software.

I'm not sure if...

It is interesting, but I don't see anywhere that they require for the certification. The prerequisites make some sense, but it needs to have some way to verify those items...