Solved

Azure DocumentDB vs Azure SQL

Posted on 2014-10-08
6
365 Views
Last Modified: 2015-05-11
There is an old saying - "If the only tool you have is a hammer, every problem looks like a nail".   I am starting a new project and i don't want to make that mistake.   I have abundant experience building SQL based systems and have grown comfortable with SQL Server specifically.  But this project will be hosted in Azure.   I was planning to use Azure SQL to store the data.  I understand that i may be looking at it myopically, but the data seems (to me) to fit naturally into TABLES.   If this were 5 years ago, i would not even have this internal debate.  But then i looked at DocumentDB.

DocumentDB programming model seems nice and clean (C# serialization/deserialization) and that makes my code nice and i start to drool.    I felt myself being lured in by the bright shiny new thing.  If this (NoSQL) is the future (and it may be), i don't want to be starting a new project with my grand-dad's database ;-)

First and foremost, this new project is a new business venture for my company.  If successful, it will be around for 10 years or more.    My data requirements are not HUGE.  I don't need petabytes.  The AzureSQL limits seem to be acceptable to me.  DocumentDB is appealing but new and missing many things i "MAY" need.  Sure, they may come along over time, but that is a gamble.  But the siren song of NoSQL is pulling me in and i need a sanity check.

Please provide me your thoughts on this question (Sobering slaps across the face accepted).
0
Comment
Question by:RXGeorge
  • 2
6 Comments
 
LVL 18

Assisted Solution

by:Peter Hutchison
Peter Hutchison earned 250 total points
ID: 40368416
I am not familiar with DocumentDB or NoSql.
But say you left the company, is there anyone who could easily take over the project and maintain it, compared to someone with just SQL experience?
0
 
LVL 41

Accepted Solution

by:
pcelba earned 250 total points
ID: 40368484
You have to decide what is your need and intention. The venture for next 10+ years is suitable for both solutions.

Your concerns are similar to mine.

SQL Server is here for long time so it means the proof of feasibility and reliability. It supports everything you need incl. BLOB data storage and fulltext indexes.

DocumentDB is something new and neither you nor Microsoft knows about its future. To vote for DocumentDB now shows just the fact you like to implement new things or you have some vision. NoSQL is a new trend and next 10 years will show if your decision was right or not... Microsoft can stop DocumentDB development at any point as they did for other products in the past. SQL will be here for a long time.

I would wait with DocumentDB but that's my nature. I am using on-line services just for backup purposes.
0
 

Author Comment

by:RXGeorge
ID: 40370735
The kid in me wants to go DocumentDB - it;d be fun.  The grown-up side, however, fears that even with ongoing Microsoft support and maintainance - i will be isolated.  Everytime i want to run a report or use some other ad-hoc tool, It will not be supported on DocumentDb and would have been on Azure SQL.
0
 
LVL 41

Expert Comment

by:pcelba
ID: 40370764
OTOH, this is a question of the backend. The frontend may be designed to support more different backends and the effort to switch from one to another should not mean big amount of work then...
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now