[dba-SQLServer] Schemas for separation of clients?

Gustav Brock gustav at cactus.dk
Tue Mar 31 10:06:02 CDT 2015


I hope I can use the VPN offering of AWS.

/gustav
________________________________
Fra: fhtapia at gmail.com<mailto:fhtapia at gmail.com>
Sendt: ‎31-‎03-‎2015 15:46
Til: Discussion concerning MS SQL Server<mailto:dba-sqlserver at databaseadvisors.com>
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

how do you manage a secure connection? are you sending all your data in the
clear then?


On Mon, Mar 30, 2015 at 11:23 AM Mark Breen <marklbreen at gmail.com> wrote:

> Hi Gustav
>
> no need for a VPN, just make a security rule to include all ports from your
> office and only open what other ports you need to the outside world.
>
> I imagine that will work fine.
>
>
>
> On 30 March 2015 at 20:18, Gustav Brock <gustav at cactus.dk> wrote:
>
> > Hi Mark
> >
> > Perfect. I missed that. I have a t2.micro instance running now with
> public
> > access.
> >
> > I wonder if I should set up a VPN connection? It seems quite
> > straight-forward to at the AWS site but may create some challenges at my
> > site.
> >
> > /gustav
> >
> > -----Oprindelig meddelelse-----
> > Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com]
>> > vegne af Mark Breen
> > Sendt: 30. marts 2015 11:31
> > Til: Discussion concerning MS SQL Server
> > Emne: Re: [dba-SQLServer] Schemas for separation of clients?
> >
> > Hello Gustav
> >
> > I have played with RDS but mostly I use ec2.  For you I was suggesting
> ec2
> > and SQL express.  Then you can have multiple dB's.
> >
> > Mark
> > On 30 Mar 2015 16:28, "Gustav Brock" <gustav at cactus.dk> wrote:
> >
> > > Hi Mark
> > >
> > > Interesting. We've used AWS for years, but for storage only, so I was
> > > not up-to-date with their RDS offerings. It seems like it could be
> > > well suited for my purpose.
> > >
> > > I had to update our login options, and that seems for some reason to
> > > be a major task as they claim it can take up to 24 hours before
> > > settled - and until then no RDS service. I have to turn on some
> patience
> > ...
> > >
> > > /gustav
> > >
> > > -----Oprindelig meddelelse-----
> > > Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com]
> > > På vegne af Mark Breen
> > > Sendt: 30. marts 2015 05:46
> > > Til: Discussion concerning MS SQL Server
> > > Emne: Re: [dba-SQLServer] Schemas for separation of clients?
> > >
> > > Hello Gustav
> > >
> > > I have been using aws for two years now and love it.  Amazon have some
> > > new micro machines (t2) that are really cheap and yet have some power.
> > > Their costs are low enough yo consider for low budget projects yet
> > > offer all the quality of true best in class cloud.
> > >
> > > I usually do all my setting up on an enormous machine, then shutdown
> > > and switch to a micro instance and restart.  That way I get to deal
> > > with great performance when in rdp and once I am done I pay pennies per
> > day.
> > >
> > > For me the absolute cost is secondary to the almost 100% likelihood my
> > > hardware will never fail.  This reliability is what u am really buying.
> > >
> > > As an aside, I have automated all my daily backups and transferred
> > > them all off machine to Amazon s3.
> > >
> > > Hth
> > > Mark
> > >  On 30 Mar 2015 02:42, "Gustav Brock" <gustav at cactus.dk> wrote:
> > >
> > > > Hi Mark
> > > >
> > > > Good points. The added precautions and potential issues may very
> > > > well not be more "expensive" than the little money saved.
> > > >
> > > > /gustav
> >
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list