sql server: All content tagged as sql server in NoSQL databases and polyglot persistence
Thursday, 16 February 2012
Hadoop Interoperability in Micosoft SQL Server and Parallel Data Warehouse
In the data deluge faced by businesses, there is also an increasing need to store and analyze vast amounts of unstructured data including data from sensors, devices, bots and crawlers. By many accounts, almost 80% of what businesses store is unstructured data — and this volume is predicted to grow exponentially over the next decade. We have entered the age of Big Data. Our customers have been asking us to help store, manage, and analyze both structured and unstructured data — in particular, data stored in Hadoop environments. As a first step, we will soon release a Community Technology Preview (CTP) of two new Hadoop connectors — one for SQL Server and one for PDW. The connectors provide interoperability between SQL Server/PDW and Hadoop environments, enabling customers to transfer data between Hadoop and SQL Server/PDW. With these connectors, customers can more easily integrate Hadoop with their Microsoft Enterprise Data Warehouses and Business Intelligence solutions to gain deeper business insights from both structured and unstructured data.
The time of data silos is long gone and the little giant is making the right moves.
Original title and link: Hadoop Interoperability in Micosoft SQL Server and Parallel Data Warehouse (©myNoSQL)
Tuesday, 22 March 2011
SQL Server and SQL Azure Comparison
SQL Azure provides relational database functionality as a utility service. Cloud-based database solutions such as SQL Azure can provide many benefits, including rapid provisioning, cost-effective scalability, high availability, and reduced management overhead.
If you are ready for the cloud — keep in mind this is not an easy question as proved by Netflix cloud migration and Reddit’s experience, going from on-premise SQL Server to SQL Azure doesn’t seem to involve drawbacks.
But what I’m really curious about is how SQL Azure compares to Amazon RDS.
Original title and link: SQL Server and SQL Azure Comparison (NoSQL databases © myNoSQL)
Monday, 30 August 2010
MongoDB and SQL Server Basic Speed Tests
Having used MongoDb almost exclusively with the NoRM C# driver for several months now, this is something that I have always wanted to do, just to satisfy my own curiosity.
Unfortunately “basic” is the wrong word. Just another useless benchmark.
Original title and link for this post: MongoDB and SQL Server Basic Speed Tests (published on the NoSQL blog: myNoSQL)
