[dba-SQLServer] Using SQL Server through my web site

Martin Reid mwp.reid at qub.ac.uk
Thu Oct 20 11:31:21 CDT 2011


John

Given the huge amounts if data your moving about what about performance. Using the web databases?

Martin

Sent from my Windows Phone
________________________________
From: jwcolby
Sent: 20/10/2011 16:42
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Using SQL Server through my web site

I selected my Web host specifically to allow me to have a sql server database.  What I did not
examine closely is how many databases or how much they cost.  My current ISP only allows me one
MSSQL and one MySQL database which is really pretty silly.  I can purchase more, but even then only
up to 3 maximum which is even more silly, and those extra only come with package upgrades which cost
a lot more money.

I still want to figure this out just to see what the performance is like and solve the technical
problems of using them for the future.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 10/20/2011 10:44 AM, Doug Steele wrote:
> John, I just got this link from ZDNet - it might interest you:
>
> http://whitepapers.zdnet.com/abstract.aspx?docid=3422473&promo=550&trial=25439928&tag=nl.e550
>
> Doug
>
> On Thu, Oct 20, 2011 at 12:33 AM, Michael Maddison<
> michael at ddisolutions.com.au>  wrote:
>
>> Hi JC,
>>
>> I've done it but I don't do it often.
>> IIRC Our host requires us to upload a backup of the db.
>> We let them know via email the db is ready, including user details and
>> they have it set up in no time. YMMV.
>> You should be able to get the IP via your Plesk (or similar) terminal
>> and create a connection from Enterprise manager or use the built in
>> tools (Plesk).
>> Your host login should have admin privs over your database only.
>> Name the db well as it will be sitting with many others.
>> Never really got the backup tools to work with my Host so I email them
>> to drop a backup into a folder I created and I ftp it back here.
>> Got a feeling there will be issues with the user account, you may need
>> to drop and recreate the login.
>> Oh yeah, probably doesn't need to be said but I don't think you can use
>> Windows Authentication.
>>
>> Good luck
>>
>> Michael M
>>
>>
>> -----Original Message-----
>> From: dba-sqlserver-bounces at databaseadvisors.com
>> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Wednesday, 19 October 2011 11:02 PM
>> To: Sqlserver-Dba
>> Subject: [dba-SQLServer] Using SQL Server through my web site
>>
>> I buy a web hosting plan where I have the ability to build sql server
>> databases though my web account.  I have never used this but I need to
>> do so now.  I haven't a clue how to get started.  I have written an
>> email to the hosting company (PowerDNN) asking them for documentation on
>> "how to"
>> but I am wondering if any of you guys do this?
>>
>> I have built a bunch of SQL Server back end databases for Access FEs.
>> this is all working well but the databases are running on a VM on my
>> server at my home office which has obvious limitations.  I am hoping
>> that I can push these databases out to my web host and reconnect the FEs
>> to those databases out on the web.  That would make scaling issues go
>> away.
>>
>> Is anyone doing this?  Any tricks / tips / cautions etc?
>>
>> --
>> John W. Colby
>> Colby Consulting
>>
>> Reality is what refuses to go away
>> when you do not believe in it
>> _______________________________________________
>> dba-SQLServer mailing list
>> dba-SQLServer at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>> http://www.databaseadvisors.com
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com<http://www.avg.com>
>> Version: 10.0.1411 / Virus Database: 1522/3962 - Release Date: 10/19/11
>>
>> _______________________________________________
>> 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




More information about the dba-SQLServer mailing list