[dba-SQLServer] Schemas for separation of clients?

[Mark Breen]

Hi John,

since you introduced me to Hamachi in about 2007, I have been using it and
loving it.  However, in recent years I start dot experience terrible
slowness when ports are relayed and I have tried to move away from it now.

It has caused me major headaches that went away when I got another
connection that was direct.



On 30 March 2015 at 20:34, John W. Colby <jwcolby at gmail.com> wrote:

> Are you guys hitting the BE with an Access FE?  If so how are you linking
> to the tables?
>
> I am running Access linked tables over the internet to SQL Server on a
> privately hosted VM / SQL Server.  It runs just fine, though a bit slow.
> OK very slow given how I design things.  But it does work. In order to do
> it however I set up a single user / password out in SQL Server, then come
> into the VM using Hamachi.  I think that Hamachi is one of the causes of
> the slowness, though since that is the only way in for me, it is tough to
> know exactly.
>
> Just wondering what you are up to and how to implement it.
>
> John W. Colby
>
>
> On 3/30/2015 9:18 AM, Gustav Brock 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
>
>