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
SOA governcance
Subscribe to:
Posts (Atom)