Yoiu say you have a database. You don't. You have a file, and using SQL Server as a file system and SQL as a data parser isn't going...

I hear you on the advantage of linking for the physical model - otherwise its out of date before its done. However, that means its not really a...

One reason why they are poorly used (aside from the primary one - no one designs databases anymore, folks just throw a bunch of tables together) is that, for anyone...

By thinking "relations yield relations", SMV's comments are all the more important (far more so than bickering about case and commas).

When large numbers of "SQL Tables" are joined, good "aliases"...

It's one of the problems of "cloud" discussions. We may or may not be talking about the same thing. But I think Larry Ellison made a nice quote...

Drew, the thing that confuses me about sites like the one you describe - which I know are perfectly common - is how they manage the licensing - both logistically,...

Steve, while this is all possible - and in fact exists - I have a couple of concerns about how the issue is framed.

You speak about "not knowing which SQL...

I'll be a grouch on this: 'taint funny, McGee! (or McGehee...)

MS SQL Server, which was once not much more than a bad joke, is today one...

Strangely, although we keep everything in FULL recovery mode and do transaction dumps every few hours, differentials every night, and fulls twice a week, we have some databases (always 3rd...

There is an additional, possibly more serious problem with the copying.

For a moment, let's leave aside the ethical question.

When the folks doing the copying don't know the...

It may be time to stop considering cursors a crutch for the procedurally oriented. This sidesteps the question of how to replace them, or the question of why...

Kevin, while well understanding that the client just wants it to work, I'm going to play devil's advocate on this and argue who's got the "procedural" mindset.

If we were talking...

Please don't think me too rude, but you need to get a DBA. You simply can't run a database server - including MS SQL Server - for non-trivial...

Oh, I wish. However, posting something publicly on the web makes it public, period.

One needs to behave appropriately in public. And to remember than the rules may change,...

Client from hell, huh?

Do everything you're doing, and plan and implement a DR scenario during lunch.

A lot depends on what the BO really meant by "DR". FTPing...