Click here to monitor SSC
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4612 Visits: 9545
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
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4604 Visits: 429
"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
Say Hey Kid
Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)

Group: General Forum Members
Points: 672 Visits: 1449
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
SSC-Enthusiastic
SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)SSC-Enthusiastic (162 reputation)

Group: General Forum Members
Points: 162 Visits: 1105
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
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4612 Visits: 9545
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
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3254 Visits: 11771
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-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45104 Visits: 39912
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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Eric M Russell
Eric M Russell
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4612 Visits: 9545
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
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3290 Visits: 2476
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