Stuart McLachlan
stuart at lexacorp.com.pg
Thu Oct 20 15:06:51 CDT 2011
Any special reason for using SQL Server rather than MySQL? It is always more expensive and more complex to use the former on a hosted web platform. -- Stuart On 20 Oct 2011 at 12:48, jwcolby wrote: > > 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 > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >