[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

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