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


SQL Server on RDS


SQL Server on RDS

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62460 Visits: 19102
Comments posted to this topic are about the item SQL Server on RDS

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
mhotek-836094
mhotek-836094
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 61
Um...the big deal is....what? I connect remotely to every production SQL Server instance that I've worked with for over 2 decades. I rarely have to manage the OS on anything that my SQL Servers are running on. If I built it against a local development instance, I haven't ever had to make changes to it to get it to run in production. I would hope the RedGate tools worked against this Amazon instance, because it is just like every other SQL Server instance out there.

I guess I must have missed something, because you just described almost every SQL Server in existence. Only a tiny fraction of the SQL Server out there even have a DBA to manage them. Of the group that I manage, I set the backups up once and the sys admins take care of getting my backup files offsite. I rarely have to do anything at an instance level and even more rarely have to manage anything on the OS.

All Amazon has done is say "we'll provide the DBA".

Michael Hotek
President - Champion Valley Software, Inc.
http://www.ChampionValleySoftware.com
yazalpizar_
yazalpizar_
SSC-Enthusiastic
SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)

Group: General Forum Members
Points: 176 Visits: 626
I do not think that Amazon has just "provided the DBA", all the contrary, they provide the hardware and the sys admin functions, the DBA tasks is on our side. We use Amazon cloud services and, in my opinion, what it provides is a 24/7 uninterrupted service without the big spences a small or medium company can not afford to make, as in our case. We have all the connectivity, CPU & processing power, storage and other benefits Amazon provides for one tenth of what we should spend if we wanted to buy and administrate our own test/production servers. Indeed we have a small test server, but is only for that, small tests at developer level, nothing more.
IceDread
IceDread
Mr or Mrs. 500
Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)Mr or Mrs. 500 (507 reputation)

Group: General Forum Members
Points: 507 Visits: 1145
Steve, you don't get sponsored by companies for posting this or do you?

I do not mean to question your integrity but you seam so positive about it. However that could be because I feel quite negative about it, thou I have my reasons.

However, since it's on the news all the time, it sure is worth debating now and again.

mhotek-836094 (5/8/2012)
Um...the big deal is....what? I connect remotely to every production SQL Server instance that I've worked with for over 2 decades. I rarely have to manage the OS on anything that my SQL Servers are running on. If I built it against a local development instance, I haven't ever had to make changes to it to get it to run in production. I would hope the RedGate tools worked against this Amazon instance, because it is just like every other SQL Server instance out there.

I guess I must have missed something, because you just described almost every SQL Server in existence. Only a tiny fraction of the SQL Server out there even have a DBA to manage them. Of the group that I manage, I set the backups up once and the sys admins take care of getting my backup files offsite. I rarely have to do anything at an instance level and even more rarely have to manage anything on the OS.

All Amazon has done is say "we'll provide the DBA".


You've missed nothing, it's a sales hype. Virtualized server services in a new package is all it is, but with more limitations.

I would say that this far, the gain is not worth the loss. The loss would be the cost as well as the problem with performance, reliability and also the legal issues of where the data is stored and who has access to the data and who can demand access to the data. It's not legal to export Swedish personal information about customers etc to third parties like some agency in usa for instance which could happen.
webskater
webskater
Old Hand
Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)Old Hand (323 reputation)

Group: General Forum Members
Points: 323 Visits: 479
You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You use this service - your web site gets popular ... what's to stop someone at Amazon ripping off your code?
yazalpizar_
yazalpizar_
SSC-Enthusiastic
SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)

Group: General Forum Members
Points: 176 Visits: 626
sku370870 (5/9/2012)
You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You use this service - your web site gets popular ... what's to stop someone at Amazon ripping off your code?


A contract ?
Markus
Markus
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3003 Visits: 3768
Do you control the backups/restores? Is SQL Server patched automatically if a service pack or security patch comes out? If so, and it causes issues with your application how do your roll it back?

I just do NOT like the thought of all of my data in the cloud where I have no idea if anyone else has access to it and I have no way of knowing this.



Steph Locke
Steph Locke
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 870
sku370870 (5/9/2012)
You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your own. You use this service - your web site gets popular ... what's to stop someone at Amazon ripping off your code?


What's to stop your developers ripping off your code? They'd probably find it a hell of a lot easier than an Amazon employee, they'd know the prospective value and they could steal it more easily.

What happens if you host your site with a company like rackspace? Would you not do it because of the risk that they could steal your code? When do you stop on this paranoid train? Do you stop your developers from seeing it? Do you stop users from accessing your site since the EU courts just found that functionailty cannot be copyrighted and is therefore open to being reverse engineered?

Personally, I think the risk is a lot less that Amazon will steal you code as the liability Amazon would face as well as negative publicity means there's a lot more pressure on them to keep things secure than there is from internal perspective. I do however know of employees who have successfully ripped code and gone on to produce major businesses on the back of it and they could not be halted or prosecuted because they were individuals. You have a lot more recourse and less burden of proof required between companies.
george 86905
george 86905
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 52
First of all, I love this site, and therefore, by extension, I love Steve Jones, I suppose. You guys have saved me many hours of deadends and the hours some of you spend on editing your posts and example code is amazing. However... on the other hand... a little morning rant:

I have to say this post really does read like marketing copy and to my mind that makes the poster pretty much a shill. I wonder if I'm going to see Amazon RDS banner ads on my Google search pages now? This press release-like post does not note a single negative aspect of Amazon's new product--and if course it is just another product. One would think that an actual informative post might also mention the costs or at least provide a link to a menu of cost options.

Not trying to be totally negative without offering an alternative. What about this? Now that this 'news' is out there, what about an objective product comparision showing the other main players in this space and how they all rank along the most important decision vectors?
yazalpizar_
yazalpizar_
SSC-Enthusiastic
SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)SSC-Enthusiastic (176 reputation)

Group: General Forum Members
Points: 176 Visits: 626
stephanie.sullivan (5/9/2012)When do you stop on this paranoid train?


Totally agree, this answer Markus question too I think
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