Friday, February 14, 2014

How cloud based databases could be used in smart grid

I have finally found some good usages of cloud databases - storing some non-critical data. Instead of storing it in Your local database (SQL Server, Oracle), I think that the good place to store some non - critical data are cloud. In case that something happened to these data - the damage will not be critical, and You will save lots of resources - storage, machines, OS, licences, and all the things needed for having local database.
As an example of data (from smart grid field) which can be stored in the cloud are MDM data.
By reading some news lately, I have concluded that there are several utilities which  are using the cloud. With MDM data. But, maybe, this is just a shy first step, and that in the feature more things could be pushed into cloud.

I have also been experimenting with Windows Azure SQL database. Good starting point to try it by Yourself is here http://www.windowsazure.com/en-us/documentation/articles/sql-database-get-started/

Friday, February 7, 2014

HA DR Oracle and SQL Server solutions

From version 2012, SQL Server has a HA DR solutions, similar to Oracle (Active) Data Guard. Here is some (I would say Microsoft sponsored - oriented) comparison of these two solutions.

http://joedantoni.wordpress.com/2012/03/29/alwayson-versus-active-data-guard-a-value-proposition/

Also, one of the articles which describes complexity of Oracle RAC installation (team I have been working in has done it with Oracle 10g  - so I could say that is correctly written - installing RAC on 10g was a nightmare) is

http://download.microsoft.com/download/C/D/C/CDCA80B2-FD63-49C5-AC66-8E3A179E31F7/SQL_Server_2012_Why_Oracle_RAC_Might_Not_Be_Suitable_For_You_Apr2012.pdf

and inside that document there is a link to the Oracle RAC installation overview

http://www.linxcel.co.uk/Whitepapers/Real-World%20Challenges%20for%20Oracle%20RAC%20Implementation-Issue%201.pdf

I am not preaching not for SQL Server nor for Oracle. Although these two documents are describing complexity of Oracle RAC installation and usage, if we are looking on the Oracle RAC not only as a DR solution but also as a platform with which You can scale up, than we could tell that Microsoft does not have that solution.