Adventures on the dark side
Last week I trundled along to a full day event covering various aspects of Oracle DB schemas, indexing and database optimisation. Why did I do this? From a personal point of view I like to understand SQL from all the different viewpoints. I spent 2 years as a Sybase developer, I am currently studying for Microsoft SQL Server 2008 exams and have recently been focusing on performance tuning and maintaining indexes in MS SQL. I was curious what sort of differences, if any, there would be between the Oracle and MS optimisation practices. Quite a lot it seems. I was expecting to find more similarities than differences, so was mildly surprised by what I heard. For the intial stages, Oracle and MS devs are in agreement. 1. Before you start coding, implement a strategy for handling errors that all the developers/DBAs will adhere to. Try..Catches that developers add willy nilly are not a strategy. You need to ensure that errors are captured, reported, handled correctly, and tha