SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Selecting a Web Host for your SQL Server Database Driven Web Site Part


Selecting a Web Host for your SQL Server Database Driven Web Site Part

Author
Message
Jonr
Jonr
SSC Veteran
SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)

Group: General Forum Members
Points: 270 Visits: 65
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jreade/selectingawebhostforyoursqlserverdatabasedrivenweb.asp


Jon
Anthony Bressi
Anthony Bressi
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 1

Nice Article Jon!

We do web development and db work for clients and have been using a fairly good host - but my gripe with their company is that they have a ton of other db instances on the server along with ours. This is a concern for obvious reasons. So I add that when shopping for a host it would be helpful to determine the # of instances that the host limits each server to. I'd be interested in hearing suggestions from other members if anyone has a great host that keeps the # of instances down to a fair amount.


Jim Underwood
Jim Underwood
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 1

Jon,

Great article!

Now that you've done all that work, would you mind sharing your top 5 choices?

TIA.


BobAtDBS
BobAtDBS
SSC-Addicted
SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)SSC-Addicted (450 reputation)

Group: General Forum Members
Points: 450 Visits: 364

I'm curious as to how many folks use public web and sql hosts rather than hosting their own. Our choice, and I would think many folks's choice would be to host their own web and sql services if they are running a site of any size at all.




Student of SQL and Golf, Master of Neither
Jonr
Jonr
SSC Veteran
SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)SSC Veteran (270 reputation)

Group: General Forum Members
Points: 270 Visits: 65

Jim,
Thank you! I did consider sharing my choices at some length when writing the article, however, I decided not to in the end, because there are so many variables involved, it's really a matter of picking the right host for your needs, and a host that performs well from where I'm based may not be so good for where you are, depending on internet traffic and support requirements. But if you or anyone else reading this runs a relatively small db(up to ~100Mb)/site, let me know, and I'd gladly send you a private post detailing who we use at present.

The problem is that if I recommend anyone in a public forum, I have to emphasise exactly what my own requirements were at the time I chose them.
Also, I would automatically exclude good, higher end business providers such as Cable & Wireless, simply because they provide facilities beyond what was required at a budget which exceeded what we had available. I'm also aware that these articles are on the SSC website for some years, so I'm reluctant to say a host is great now, because in a year they may not be (and we've been in that situation several times).

Bob, with regard to the web hosts, the article was mainly targetted at start-ups, and small to medium sized businesses. I agree with your point and given a limitless budget and time, I'd do it all myself too (call me a control freak!). I've worked in very large businesses and corporations where they obviously have enough cash and resource to throw at the solution in-house, but as a smaller enterprise, you need to have the site and database regularly backed up, have a high speed line into the site from the net, and have support staff to keep it running. The cost of setting up the infrastructure and the ongoing costs of doing it properly can be prohibitive to a smaller company. This is probably even more so the case in more rural areas, and in the developed world outside of Japan and North America, where bandwidth doesn't come cheap and telco's can be (ex-)state monopolies which still have a stranglehold on the pricing of telecomms connections. You may be talking about an order or two of magnitude in costs difference in these places.




Jon
John Langston
John Langston
Old Hand
Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)Old Hand (300 reputation)

Group: General Forum Members
Points: 300 Visits: 522

Part of the reliability question has to do with how insulated is the primary host site to outage due to loss of power or natural disaster. Do they have a backup site and if so, where is it located in relation to the primary site? I ask this question from personal experience with a provider whose secondary site was several miles from their primary site but, as it turned out, on the same power grid. When the primary site was without power, so was the first and neither site had backup generators!





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search