[dba-SQLServer] Schemas for separation of clients?

[Mark Breen]

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
>
>