Welcome to EMC Consulting Blogs

June 2009 - Posts

• UPDATE FROM the Sybase code museum

  UPDATE FROM is dead … or it should be. Hugo Kornelis has done a good job of explaining why. Apart from a badly thought out and non-portable syntax, UPDATE FROM suffers a notorious bug/feature. I say “notorious” but it’s probably not notorious enough because Read More... Posted 24 June 2009 22:57 by David.Portas | 0 Comments Filed under: SQL, SQL Server

• DB2 9.7 and Database Type Safety

  DB2 has some new features that are aimed at customers who want to transition from Oracle to DB2: http://www-05.ibm.com/ch/events/symposium/pdf/9_M_Obrecht_IBM_Symposium_2009.pdf IBM are emphasising the improved snapshot isolation, PL/SQL support and packages Read More... Posted 24 June 2009 22:01 by David.Portas | 1 Comments Filed under: SQL