Friday 7 May 2010

Dropping a table during SELECT in oracle and SQL server

Uwe Hesse in his article Dropping a table during SELECT has described how dropping a table during select statement works in oracle database server. As per his post, you are able to drop while selecting from the table. In contrary to this in SQL server dropping a table while a select is running doesn't work. The drop statement is blocked by the select statement. Once the select statement is completed, the drop statement also completes.

Monday 22 March 2010

Mission Critical: Database Design

A very good documentation on designing and implementing mission critical database. I found it quiet interesting though now far from what I normally do when designing a mission critical database. You can find the full document @ simple-talk.com

Wednesday 17 March 2010

SOA governance

Adaption of SOA is more likely to succeed if you embark a good but simple SOA governance. The following white paper explains the approches and best practices towards acheiving good SOA governance. Read
SOA governcance