Author: Rafael Copquin
Posted: 2017-08-15 07:39:31 Link
I am experimenting with cloud computing.
A client of mine who is currently using a Microsoft SQL Server based
application, wishes to have the SQL Server database in the cloud so it
can be accessible by all his company's branches.
I would like to know if Amazon is offering SQL Server as a service. I am
aware that if you contract a Virtual Machine with SQL Server inside you
would have the problem solved, but I wonder if it is possible to use SQL
Server without the need to have a VM as well
In the case of Google Cloud Computing, you must have a virtual machine
and SQL Server inside
I have tried Azure and I've seen that they offer SQL Server as a
service, but if you want to get in a single select statement data from
two different databases, that is not possible, unless you try a
convoluted solution that I got from the web and that would involve
modifying my application code a lot. This I will not do (the client
won't pay for the time involved in reprogramming)
OTOH, the information provided in any of those sites is so huge and
confusing, that I do not know what to choose, where to look and......too
much for this old programmer.
Can anybody enlighten me, please?
Remember, I am looking for a simple SQL Server as a service solution,
without the need to get a VM as well. Is this possible?
Rafael Copquin
---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/8e7cd088-3acc-c85c-e4b0-c99bbb06d510@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Malcolm Greene
Posted: 2017-08-15 07:51:19 Link
Yes, this is possible. Look at AWS RDS (Relational Database Services).
Malcolm
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1502801479.1214476.1074005240.7A076FB5@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2017-08-15 08:39:19 Link
It is not as simple as hosting your db in a rack that someone else
maintains for you.
There is a fee for bits going in and coming out so it gets costly depending
on the data you have and what you might be doing.
You might find that getting a rackspace virtual server or a GoDaddy site
may be better for you compared to AWS. As an Amazon investor I want more
people to get into AWS but in your case, it is probably a bad fit.
On Tue, Aug 15, 2017 at 7:39 AM, Rafael Copquin <rafael.copquin@gmail.com>
wrote:
> I am experimenting with cloud computing.
>
> A client of mine who is currently using a Microsoft SQL Server based
> application, wishes to have the SQL Server database in the cloud so it can
> be accessible by all his company's branches.
>
> I would like to know if Amazon is offering SQL Server as a service. I am
> aware that if you contract a Virtual Machine with SQL Server inside you
> would have the problem solved, but I wonder if it is possible to use SQL
> Server without the need to have a VM as well
>
> In the case of Google Cloud Computing, you must have a virtual machine and
> SQL Server inside
>
> I have tried Azure and I've seen that they offer SQL Server as a service,
> but if you want to get in a single select statement data from two different
> databases, that is not possible, unless you try a convoluted solution that
> I got from the web and that would involve modifying my application code a
> lot. This I will not do (the client won't pay for the time involved in
> reprogramming)
>
> OTOH, the information provided in any of those sites is so huge and
> confusing, that I do not know what to choose, where to look and......too
> much for this old programmer.
>
> Can anybody enlighten me, please?
>
> Remember, I am looking for a simple SQL Server as a service solution,
> without the need to get a VM as well. Is this possible?
>
> Rafael Copquin
>
>
> ---
> Este correo electrónico ha sido comprobado en busca de virus por AVG.
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMY+9TqnUFXSw=9mfWdBt0mOFq4BjBWL2YSqTkWu1W-WaLw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Malcolm Greene
Posted: 2017-08-15 08:55:25 Link
A different opinion: Who wants to worry about OS/database
patches/upgrades, optimized database configuration, security, and then
be responsible for monitoring this environment as well?? There's no way
you're going to do a better job at these tasks than a team of
professionals focused 24x7 on these specific concerns ... all from a
best practice perspective. Your value-add is your application and
customer support - not haphazardly configuring and maintaining
infrastructure in your spare(?) time.
----- Original message -----
From: Stephen Russell <srussell705@gmail.com>
To: profoxtech@leafe.com
Subject: Re: [NF] Amazon Web Services/Azure/Google Cloud Computing
Date: Tue, 15 Aug 2017 08:39:19 -0500
It is not as simple as hosting your db in a rack that someone else
maintains for you.
There is a fee for bits going in and coming out so it gets costly
depending
on the data you have and what you might be doing.
You might find that getting a rackspace virtual server or a GoDaddy
site
may be better for you compared to AWS. As an Amazon investor I want
more
people to get into AWS but in your case, it is probably a bad fit.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1502805325.1226952.1074064976.60AAA72E@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Ed Leafe
Posted: 2017-08-15 09:15:11 Link
On Aug 15, 2017, at 8:55 AM, Malcolm Greene <profox@bdurham.com> wrote:
> our value-add is your application and
> customer support - not haphazardly configuring and maintaining
> infrastructure in your spare(?) time.
This.
If all you’re doing is moving your workload from an in-house machine to a remote machine, you’re really not getting much benefit beyond reduced capex costs.
-- Ed Leafe
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/C56A95AB-AAEF-4881-A620-13FF5BFD432D@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: mbsoftwaresolutions@mbsoftwaresolutions.com
Posted: 2017-08-16 07:48:17 Link
On 2017-08-15 10:15, Ed Leafe wrote:
> On Aug 15, 2017, at 8:55 AM, Malcolm Greene <profox@bdurham.com> wrote:
>
>> our value-add is your application and
>> customer support - not haphazardly configuring and maintaining
>> infrastructure in your spare(?) time.
>
> This.
>
> If all you’re doing is moving your workload from an in-house machine
> to a remote machine, you’re really not getting much benefit beyond
> reduced capex costs.
But saving money on not having to have an in-house DBA, letting the
vendor take care of the 24/7 and patches etc....isn't that a good thing?
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/eb01e105c43f0e3bc781d59afb8f01ca@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2017-08-16 08:32:52 Link
Knowing that backups are made and being able to restore from one because
your testing just destroyed key data is always a nice thing. Not that
ANYONE would ever test against PROD data.......
Allowing them to roll patches is good when those patches are safe.
SQLServer2014 SP2 in particular.
When you are in the Rented space you don't get the awesome tools that are
FREE from M$. Analysis Services, Integration Services, and Report Services
unless you specify them on the front end.
You also cannot have an always-on environment that some people pay for
because this insurance for the business is justifiable.
On Wed, Aug 16, 2017 at 7:48 AM, <
mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:
> On 2017-08-15 10:15, Ed Leafe wrote:
>
>> On Aug 15, 2017, at 8:55 AM, Malcolm Greene <profox@bdurham.com> wrote:
>>
>> our value-add is your application and
>>> customer support - not haphazardly configuring and maintaining
>>> infrastructure in your spare(?) time.
>>>
>>
>> This.
>>
>> If all you’re doing is moving your workload from an in-house machine
>> to a remote machine, you’re really not getting much benefit beyond
>> reduced capex costs.
>>
>
>
> But saving money on not having to have an in-house DBA, letting the vendor
> take care of the 24/7 and patches etc....isn't that a good thing?
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYK3g0fChP4SbDA3rerPVvzUeFLKEb_O1ihxUkZ6TpPh3A@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Rafael Copquin
Posted: 2017-08-16 10:02:49 Link
thank you all for your replies
Rafael Copquin
---
Este correo electrónico ha sido comprobado en busca de virus por AVG.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/5c475c5f-7214-ea17-0ef2-6c2c0f68039c@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Ed Leafe
Posted: 2017-08-16 14:11:28 Link
On Aug 16, 2017, at 7:48 AM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
>
>>> our value-add is your application and
>>> customer support - not haphazardly configuring and maintaining
>>> infrastructure in your spare(?) time.
>> This.
>> If all you’re doing is moving your workload from an in-house machine
>> to a remote machine, you’re really not getting much benefit beyond
>> reduced capex costs.
>
> But saving money on not having to have an in-house DBA, letting the vendor take care of the 24/7 and patches etc....isn't that a good thing?
That’s just what I said: the gain by using cloud services is that you don’t have to spend your own time on the stuff that you mentioned, and can instead focus on providing value by developing applications.
-- Ed Leafe
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/B633EFE4-D62B-4BBB-9F9A-0236D5CB4FE6@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Charles Hart Enzer, M.D.
Posted: 2017-08-17 02:13:13 Link
byethost.com
Shai / שי
Charles Hart Enzer, M.D., FAACAP
Aliyah: Cincinnati to Jerusalem's German Colony May, 2017
Volunteer Associate Professor of Psychiatry
University of Cincinnati Medical Center
WebSite: http://EnzerMD.com
May all of us merit endless generations to live and thrive in the Holy Land
On Aug 15, 2017 3:40 PM, "Rafael Copquin" <rafael.copquin@gmail.com> wrote:
> I am experimenting with cloud computing.
>
> A client of mine who is currently using a Microsoft SQL Server based
> application, wishes to have the SQL Server database in the cloud so it can
> be accessible by all his company's branches.
>
> I would like to know if Amazon is offering SQL Server as a service. I am
> aware that if you contract a Virtual Machine with SQL Server inside you
> would have the problem solved, but I wonder if it is possible to use SQL
> Server without the need to have a VM as well
>
> In the case of Google Cloud Computing, you must have a virtual machine and
> SQL Server inside
>
> I have tried Azure and I've seen that they offer SQL Server as a service,
> but if you want to get in a single select statement data from two different
> databases, that is not possible, unless you try a convoluted solution that
> I got from the web and that would involve modifying my application code a
> lot. This I will not do (the client won't pay for the time involved in
> reprogramming)
>
> OTOH, the information provided in any of those sites is so huge and
> confusing, that I do not know what to choose, where to look and......too
> much for this old programmer.
>
> Can anybody enlighten me, please?
>
> Remember, I am looking for a simple SQL Server as a service solution,
> without the need to get a VM as well. Is this possible?
>
> Rafael Copquin
>
>
> ---
> Este correo electrónico ha sido comprobado en busca de virus por AVG.
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAFSdja0Hrh4yfDFaH6S5+5=OPeaaDrNrsPvS8F0f6i6=fbxKCg@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.