February 2012 - Posts

• Database Migration Scripts: Getting from place A to place B

  Posted Tuesday, February 28, 2012 1:00 AM | 1 Comments
  
  

  With a database synchronization tool you can produce a script that modifies the database's schema, but what about the data? It depends. Sometimes one has to spit on one's hands and cut some code. Read More by Phil Factor | 1 Comments | Comment on this post

• Normalisation and 'Anima notitia copia' (Soul of the Database)

  Posted Friday, February 17, 2012 6:23 AM | 8 Comments
  
  

  Phil, in a guest editorial for Simple-Talk, puzzles over the possibility that a SQL Server System table commits sins against relational theory. Maybe the answer isn't that simple. Read More by Phil Factor | 8 Comments | Comment on this post

• Curing the Database-Application mismatch

  Posted Tuesday, February 14, 2012 7:52 AM | 5 Comments
  
  

  If you design the database-application interface well, then the strains of release, integration and deployment vanish. Testing and implementing database-security becomes a lot easier too. It's an old-fashioned approach but it works Read More by Phil Factor | 5 Comments | Comment on this post

• Hadoop, NOSQL, and the Relational Model

  Posted Friday, February 10, 2012 1:28 AM | 1 Comments
  
  

  (Guest Editorial For SysAdmin/IT Pro Newsletter) In which the Editor asks Phil to stand in and write an editorial about NOSQL, expecting a rant. Unexpectedly, Phil broke into a smile at the thought of Hadoop, especially in view of its forthcoming ODBC Driver! Read More by Phil Factor | 1 Comments | Comment on this post