Archive

Posts Tagged ‘SQL’

SQL: the successful cousin of Haskell « Experimental Thoughts

October 15, 2011 Leave a comment

Nice article: SQL: the successful cousin of Haskell « Experimental Thoughts.

Advertisements
Tags: ,

SQL PASS 2011 – SQL Azure gets a facelift

October 14, 2011 Leave a comment

The delta:

  1. The maximum database size for individual SQL Azure databases will be expanded 3x from 50 GB to 150 GB.
  2. Federation. With SQL Azure Federation, databases can be elastically scaled out using the sharding database pattern based on database size and the application workload.  This new feature will make it dramatically easier to set up sharding, automate the process of adding new shards, and provide significant new functionality for easily managing database shards.
  3. New SQL Azure Management Portal capabilities.  The service release will include an enhanced management portal with significant new features including the ability to more easily monitor databases, drill-down into schemas, query plans, spatial data, indexes/keys, and query performance statistics.
  4. Expanded support for user-controlled collations.

Source: Just Announced at SQL PASS Summit 2011: Upcoming Increased Database Limits & SQL Azure Federation; Immediate Availability of Two New SQL Azure CTPs – Windows Azure – Site Home – MSDN Blogs.

Now Microsoft comes up with a road map for Hadoop efforts

October 14, 2011 Leave a comment

Here is the post: Microsoft’s Big Data Roadmap & Approach – SQL Server Team Blog – Site Home – TechNet Blogs.

As we have noted in the past, in the data deluge faced by businesses, there is an increasing need to store and analyze vast amounts of unstructured data including data from sensors, devices, bots and crawlers and this volume is predicted to grow exponentially over the next decade. Our customers have been asking us to help store, manage, and analyze these new types of data – in particular, data stored in Hadoop environments.

I am not sure about IBM, but this makes two of them – Microsoft and Oracle, finally realizing the power of Hadoop and acknowledging that they have to do something about it. Pretty late already, I will say. Earlier, Oracle had something similar to say in OpenWorld 2011.

My Hadoop experience so far has been limited, but nevertheless amazing in every sense. I was blown away by the simplicity, more than anything else. It takes very minimal effort (okay, you do need the understanding) to setup a Hadoop cluster and run a task distributed on several machines. We were using 5 laptops and although the task we wrote was a simple search, but with the effort that was put in, I never expected it to work. I was surprised when it sailed through.