Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content in the Cloud

By Steve Jones,

This past week was the MVP Summit in Redmond, where Microsoft entertains and informs the people on whom it has recognized as MVPs for various products. I didn't attend this event as I've been out of town a lot in 2013 and wanted to remain at home. I also didn't have high hopes that it would be particularly informative given the relative close proximity to the next release of SQL Server 2014. However many others did and there was one item that caught my eye at the end of last week.

Greg Low wrote a blog about an option in SQL Server 2014 to place part of your database in the cloud. Essentially you could put a filegroup or file in a location accessible by a URL and use that when creating your database. There is documentation on this up on MSDN and you could test this if you have CTP2 and want to experiment with the effect of having a portion of your database on-premises and a portion in Azure.

Dr. Low includes a couple of places where this configuration might make sense in his blog. The first I agree with. If you are using your database in Azure, then accessing some of the files via a URL makes sense. The second? I'm not so sure. The documentation talks about how or why you might do this, but there's one key element I don't see mentioned: performance. What happens if the Azure connection drops? What happens if it's very slow? If my queries were returning to users asynchronously, from separate batches, I would see some benefit here to clients, but if they don't get results until my local files AND my cloud files return data, I'm not sure I'd pay that penalty.

I'm glad this is an option, and I'm sure there are places where this makes sense. I'm just not sure one of them is some of the tables in my database on premise and some in the cloud when they're being joined together.

 
Total article views: 70 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Cloud Patches

The cloud changes the way that we can administer and deploy changes to our systems. Steve Jones high...

ARTICLE

Deploying tech to the cloud

There is a world of difference between technology originating in or designed for the cloud and techn...

ARTICLE

Cloud Skills

The cloud is going to be important for the future of SQL Server.

ARTICLE

Cloud Barriers

I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of movin...

ARTICLE

Lassoing a Cloud

Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about...

Tags
 
Contribute