SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Should We Move to Azure?


Should We Move to Azure?

Author
Message
Eric M Russell
Eric M Russell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28028 Visits: 11484
SQL Server Azure offers scalability when it comes to storage, memory, and CPU, but I'm guessing that this website really isn't that massive and it grows over time in a predictable way. I'm guessing that your biggest concern should be how moving your websute and databases to the cloud would impact accessibility and latency. Latency; that's probably the game changer.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Feifarek
Feifarek
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 1641
I would be interested in seeing the real world comparison of the differences in (a) operating costs, and (b) ease of maintenance, between the in house server vs cloud.

But while I see it as an interesting exercise, I don't (yet) see a compelling argument for either hosting it on the cloud or keeping it on your own server.



lionfan91
lionfan91
SSCertifiable
SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)SSCertifiable (5.3K reputation)

Group: General Forum Members
Points: 5292 Visits: 431
"Or is SQLServerCentral just a service and you don't care how it works, as long as it does."

For me, it's this. As we tell our own users, I don't care how it works behind-the-scenes, I care about the front-end and the content. That said, all my work is in a classified environment so "the cloud" has never, and will never, be a player for me. It's be an interesting read if you do go this route, but personally I could never benefit from lessons learned. Best of luck if you choose to do it!



John Hanrahan
John Hanrahan
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1203 Visits: 1468
I'd like to also see your planning for cloud failure. This would be very interesting for me. I have read about cases where a cloud provider goes out of business and end-users are given only a few days to pull everything off. Also an exploration of the legal aspects would be interesting. Right now my understanding of the law says that if the Feds grabbed the servers for an unrelated issue they wouldn't have to give SSC back their data. How will you prepare for that (and should you?). All very interesting. Another question might be now that you don't control your servers and data 100% will you do anything different. An admin at a cloud provider was recently fired and used some back doors he set up to cause trouble. Will you prepare for that? Will you save money? What's your ROI? Will you prep an ROI analysis before moving?

I think you should do it (all of it).
Dalkeith
Dalkeith
Mr or Mrs. 500
Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)Mr or Mrs. 500 (553 reputation)

Group: General Forum Members
Points: 553 Visits: 1116
No better way to learn the benefits or problems than try to try to implement a solution / application at production.
Eric M Russell
Eric M Russell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28028 Visits: 11484
Does Red Gate SQL Monitor work with SQL Azure; could we still peel back the covers and see that, if SQLServerCentral were hosted on Azure?


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Michael Valentine Jones
Michael Valentine Jones
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13885 Visits: 11848
Like everything else, it is a business decision.
Does it lower costs?
Does it increase revenue?
Is it easier to manage?
Is there majors risks associated with either doing nothing or moving to the cloud?

I have my doubts that you will see any return on investment compared to doing nothing.

If you were just starting the site with no established infrastructure, then it might make more sense.

It might make sense if you were doing such a major overhaul to the site that it was really a new site.

What is your current setup? Hosted on your own infrastructure, hosted in a hosting center, etc.?
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (206K reputation)SSC Guru (206K reputation)SSC Guru (206K reputation)SSC Guru (206K reputation)SSC Guru (206K reputation)SSC Guru (206K reputation)SSC Guru (206K reputation)SSC Guru (206K reputation)

Group: General Forum Members
Points: 206405 Visits: 41956
I'd REALLY be interested in this especially if a comparison of costs between the current rendition of SSC and the cloud version were CAREFULLY TRACKED and revealed. I think that there will be a fair number of hidden costs and savings revealed and this would be a beautiful chance to do such a comparison.

As to the following comment of...

Since you really don't have any medical, financial or legally sensitive information and SSC is a web site, not a critical business service set in a "real" enterprise, you should be a perfect candidate for Azure.


... heh... lose my stuff and it may become a medically sensitive issue for someone when I make a personal visit in my postal uniform to find out where my stuff went. :-P

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Eric M Russell
Eric M Russell
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28028 Visits: 11484
Dalkeith (5/23/2014)
No better way to learn the benefits or problems than try to try to implement a solution / application at production.


http://blogs.msdn.com/b/seliot/archive/2011/04/25/i-don-t-always-test-my-code-but-when-i-do-i-do-it-in-production.aspx
:-P


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Rudyx - the Doctor
Rudyx - the Doctor
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10552 Visits: 2503
SQLServerCentral just a service and I don't care how it works, as long as it does :-)

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search