[dba-SQLServer] Schemas for separation of clients?

[Mark Breen]

Hello Gustav

Re the vpn I am not sure in fully grasp why you would need it.

Would it not be sufficient for you to open each clients external facing IP
to your odbc ports.  What would make you create a VPN and although I need
to read up on it, how or what would u have to do on your clients machines
to make the VPN work?

Thanks

Mark
On 31 Mar 2015 22:07, "Gustav Brock" <gustav at cactus.dk> wrote:

> 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]
> > På
> > > 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>