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

jwcolby jwcolby at colbyconsulting.com
Thu Oct 20 11:48:19 CDT 2011


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

I do many different things.  ;)

This is not about my monster sql server, but rather about some almost tiny databases used as the 
data store for access front ends for my non-profit clients.  It gets the data off of my servers and 
out to the web where it is 1) Always available and 2) faster data pipe.

John W. Colby
Colby Consulting

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

On 10/20/2011 12:31 PM, Martin Reid wrote:
> 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
>
> _______________________________________________
> 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