Very good article, although I would agree with Jacques on shared data sets. They're point isn't to replace a view or stored procedure, but to persist between reports data sets...

ANSI will be dead, as will Varchar/Char. EVERYTHING text will be in UNICODE. MS is already starting that - import a spreadsheet and see what data types they are....

It's a good article, though I would have like to seen more on shared data sets, which personally I think are the biggest inclusion. Well done!

I seriously have to work with a vendor database that has a Y10 issue. Yes, a Y10 issue. They use counter fields to "increment" when the decade changes. It's that...

That's an excellent point about the difference between log shipping and transactional replication - the latter does guarantee transactional consistency. I guess my point was that it isn't the easiest...

A great article, but...

I fundamentally disagree with using replication as a DR technique. Even with 2005, I've run into too many clients that often use replication to keep a standby...

Sorry to hear about the data loss. That's always tough to swallow...

As far as the transaction log, when in Full or Bulk-Logged mode it will continue to record transactions (or...

Given the translation of the error, (haven't gotten around to to learning Dutch - that's in my list of goals for the 2010-20 decade) it looks to me like either:

1) You...

Nope. Even with the compatibility level is 80, it won't work. You'd have to script out the structure of the database (reviewing the script for syntactical differences between 2000 and...

What an interesting question! I assume that your asking from an academic standpoint, rather than "What is normalization..." (if you are asking the latter, a search on Google for E.F...

In my opinion the biggest problem with using a GUID as a an active key is performance. If you're using an INT, that's a 4byte column. A GUID is 16bytes....

Kudos on being thorough! You'd be shocked at the number of times I've been asked questions about this situation AFTER the fact...

Yes, detach/reattch is much faster than backup/restore. I assume...

Great title!

Oh, if we only had the UPSERT command (DB2 - updates existing rows and inserts new ones).

Let me restate to see if I understand. Users can add new colors...

If I'm understanding the issue, the scheduled process runs fine until there's a disconnection in the network. Is that correct? That should rule out security issues (should...).

One thing you may...

Agreed, it's probably a blocking situation, but a memory constrained machine can give the same sort of response. Just thought I'd through that in...