[dba-SQLServer] Schemas for separation of clients?

[Gustav Brock]

Hi Dan

I use ODBC with the "SQL Server" driver and DAO and Access 2013. I guess you can use ADO as well.

I will later try with the "SQL Server Native Client 11.0". I've some troubles with this and Access 2010 and a different app, but as it is the recommended driver, I will try once more.

/gustav

-----Oprindelig meddelelse-----
Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af Dan Waters
Sendt: 30. marts 2015 17:27
Til: 'Discussion concerning MS SQL Server'
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

Hi Gustav,

I've been following this thread with interest!

I assume you are using Access to connect to SQL Server?  Are you using DAO or ADO to connect?

Thanks!
Dan

-----Original Message-----
From: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, March 30, 2015 9:47 AM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Schemas for separation of clients?

Hi John

I have just set up a micro instance at AWS hosting SQL Server 2008 Express and a public IP address.
Then I can attach it directly via ODBC.
We have only a 15 Mbit/s download, so speed is slower than from our in-house SQL Servers but fully acceptable.

At takes a little to set up the access to AWS. I skipped the VPN offering but I may add that later when I find out how to do it.

My need is very far from yours with a maximum record count per table of some hundred thousands so I may never meet the issues you are dealing with.

/gustav

-----Oprindelig meddelelse-----
Fra: dba-SQLServer [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af John W. Colby
Sendt: 30. marts 2015 15:35
Til: Discussion concerning MS SQL Server; jwcolby at gmail.com
Emne: Re: [dba-SQLServer] Schemas for separation of clients?

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