Wednesday, October 25, 2006

October 2006: Month of the Database.

Currently I’m working for Avanade Spain in EADS-CASA in Spain, optimizing a .NET application (ASP and C#/PL-SQL) using large databases in Oracle 9i/10g R2.
At the same time I’m studying for the 70-431 exam (TS: Microsoft SQL Server 2005 - Implementation and Maintenance) for the MCTS - Microsoft Certified Technology Specialist: SQL Server 2005 certification.
In the last month I read five books of Oracle and two of SQL Server 2005 and spent several hours of lab work.
Working with both leaders of the Database market at the same time provide me a better understand of database concepts and the difference between products.
As MCDBA in SQL Server 2000 since 2004, I spent the last two years without extensive work with databases, just the setup of several Windows 2003/SQL 2000 cluster servers and the migration from SQL Server 7.0/2000 and Oracle 8/9 to SQL Server or optimizing .NET applications.
The “intensive” last month help me to improve my knowledge of database modeling, how to use XML in both databases, optimization of the code, migration from ANSI SQL to Transact-SQL or PL-SQL, etc.

Favorite SQL Server 2005 Book: TS: Microsoft SQL Server 2005 - Implementation and Maintenance Training Kit from MS Press (2006)

Favorite Oracle Book: Mastering Oracle SQL from O'Reilly (2004)

No comments: