Oracle vs SQL Server
So it's been a while since I have written something for my blog. But today I was talking to a colleague about how my transition into my new job over the last 9 months has gone. I mentioned to him that the although adjusting to the culture and methods of working took some time one of the challenges for me has been on the technology side. At this point I should note that a lot this blog will be geeky and techie. In all my previous development roles I have been using Microsoft Sql Server as the database backend and feel confident in writing very complex database scripts and looking under the bonnet when issues occur. However, in my present role we use Oracle as the database. Oracle's flagship product is established as probably the leader in enterprise size databases and although I have used it in the past – I was surprised how much difference there really was. I have still a lot to learn about Oracle itself and the PL/SQL language that sits on top of it. A lot of the difference...