Month: June 2013

Eeeeeek it’s SQL2014 on windows 8.1

Finally time to install the new microsoft toys! Yeeh! Time to install virtual box and the freshly released windows 8.1 and install sql2014.

Get some code here and start a Hekaton

Memory optimalization code named Hekaton:

So we have this idea that our data belongs on disks and the data we need will be loaded into the memory of your machine for manipulation. In Hekaton transactions never get rolled back. when you change data, you create a new version in memory. If the transaction fails, the changes are never written to the disk. When a transaction does commit, it goes into the transaction log and a background process copies it back to the set of sequential files, the Hekaton data. These files are read at database start-up, when they get copied into memory. the downsite is, it has to fit in your RAM, if not, the new rows can’t be added, you can’t change it to the old write to disk mode. So, your old database probably will not work with hackaton, but Microsoft is working on a solution for this to optimize al your data.

to be continued…

25-6-2013 14-22-01

Total cloud control together with Oracle and Microsoft


Total cloud control – “Reduce downtime” and “pluggable database”


This is what the new oracle rdbms 12c is all about; It’s a business driven enterprise cloud management solution.

Two features highlighted:

Pdb pluggable database features: one instance for multiple databases saves lots of memory and you can upgrade multiple database instances at once.

Multitenancy* (the key ingredient for the cloud)  the pro’s of the  shared server technology is it’s efficiency with the guarantee of data isolation and discrete tenant performance management. db admins can discretely manage service levels and define resource  allocation and priority.

Oracle also promises 12c’s database disk I/O is reduced and uses fair memory usage which was not really the case with the absorbing powers of current popular oracle 11g, which only works well on a powerful x64.

The multitenancy* refers to the already growing SAAS community (software as a service) where many customers share the same application instance, but with separated data. Oracle pushes this approach from the application to the database!

So whats the fuzz about?

Oracle and Microsoft announced their partnerships along with some other (saas) companies today with software vendors that will, I quote “Reshape the cloud and reshape the perception of oracle technology in the cloud”.

Partnerships are no big news in the ever changing IT world, but Microsoft and Oracle being database competitors for a long time, this is big news. This could not only bring together the best of both worlds. But will this change the way we think an work with databases? Will oracle’s 12c become the big force behind the SQl Azure cloud services? I can’t wait to hear more about this!

I’m curious to hear your thoughts on this partnership.