Thanks Douglas, simply brilliant. Now, this is what set based logic is all about!

I also have to agree that the use of object frameworks to access the data can cause real problems. Years ago, a division at Yahoo! contracted me to come in...

Daniel, thanks for adding!

Just like Steve noted, it is a tool. ACID databases were targeted for financial transaction systems, where ACID was a must, and hard, known relations existed. And the...

Excellent use of Row_Number.

I have to agree that the concept of disaster recovery should include the entire system infrastructure, including total site loss. But as mentioned earlier, if you don’t even have valid...

I have to agree with Chris.Stuart. I don't see any company putting trade secrets, data or code processes considered part of their strategic advantage into the cloud. Do you...

Thanks for the contribution. Most of the time I encourage the use of object abstraction tools like mygeneration, entity space, etc., but its always nice to have some tools available.

Nice intro. I've been thinking about getting more up to speed on Oracle.

...I believe SQLsvr made the change to schema to be more ANSI compliant.

When it comes to DR and internet focused technology staff, I’ve seen few who really understand the importance of recovery. Just take a look at the use of MySQL...

Agree!

All that contribute should be treated with respect. And those that write articles should be thanked for taking the time to contribute. Unprofessional comments are a waste of time for...

All good ideas. A full onsite and offsite process should be developed, documented and implemented, including testing. And not just for the database, but for the entire application(s).

depending on...

It is a double-edged sword. Ease of installation and use gets SQL Server out in many places. And from my perspective, the more SQL Server installations, the better for...

Anything we can do to encourage procs, the better. But, with the movement towards the use of object abstraction tools such as NHibernate, Linq, and MyGenerate, I fear the battle...

We do need SOX, but corporate executives hate it.

It limits their ability to softly manage their short term reported financials, and makes them responsible. In one of my past...