Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

SQL Server on RDS Expand / Collapse
Author
Message
Posted Tuesday, May 08, 2012 10:59 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:20 PM
Points: 32,764, Visits: 14,928
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
Post #1296880
Posted Tuesday, May 08, 2012 11:08 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 21, 2013 4:45 AM
Points: 11, Visits: 48
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
Post #1296882
Posted Wednesday, May 09, 2012 12:21 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:30 AM
Points: 141, Visits: 379
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.
Post #1296909
Posted Wednesday, May 09, 2012 2:10 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 10:18 AM
Points: 294, Visits: 1,008
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.
Post #1296953
Posted Wednesday, May 09, 2012 4:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:40 PM
Points: 179, Visits: 382
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?
Post #1297012
Posted Wednesday, May 09, 2012 5:25 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:30 AM
Points: 141, Visits: 379
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 ?
Post #1297028
Posted Wednesday, May 09, 2012 5:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 1,201, Visits: 2,658
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.



Post #1297042
Posted Wednesday, May 09, 2012 6:42 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 6:00 AM
Points: 157, Visits: 792
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.

Post #1297058
Posted Wednesday, May 09, 2012 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 9:17 AM
Points: 7, Visits: 40
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?
Post #1297060
Posted Wednesday, May 09, 2012 7:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 3:30 AM
Points: 141, Visits: 379
stephanie.sullivan (5/9/2012)When do you stop on this paranoid train?


Totally agree, this answer Markus question too I think
Post #1297077
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse