reccomend asp.net 2.0 hosting + SQL2005

pinkaardvark · 9 May 2007 at 14:39

I know it's been asked a few times recently but the search seems out of order. Anyone got a recommendation. Just for personal usage not commercial so needs to be reasonably priced. Can live with SQL express but do need 2005.

pinkaardvark · 9 May 2007 at 15:11

Stelly said:
I use hostinguk.net which seem very good and not too dear... but you will pay no matter what with MSSQL server as they have to pay licencing

Stelly

SQLExpress is free

pinkaardvark · 9 May 2007 at 15:38

elkdanger said:
You also can't use it for live websites, and for multiple connections it will be very slow.

You can get a MySQL .Net Connector for ASP.Net, which has been a good experience so far. I've found that many hosts provide .Net hosting with a MySQL database for just as cheap as PHP/MySQL hosting.

Where did you hear that. SQLExpress was designed for web applications as a competitor to MySQL and I can find nothing to suggest it has connection limits. Can people back up these statements please?

"
When delivered in SQL Server Express form, Microsoft has limited SQL Server in several ways:

§ A database cannot exceed 4 gigabytes in size.

§ SQL Server Express may be installed on a multiple CPU machine, but it will execute (run) only on a single processor or a single processor core if multi-core processors are used.

§ SQL Server Express may be installed on a server with any amount of memory, but will use only up to 1 GB of available RAM memory.

Other than these limitations SQL Server Express provides virtually the full power and breadth of SQL Server capabilities. Although MSDE was limited to no more than five users, SQL Server Express no longer has such an artificial throttle on performance. Within the limits of processor, RAM and maximum database size, SQL Server Express always runs at full speed. "

Those limitations are the only ones I am aware of from the MS documentation on the subject.

pinkaardvark · 9 May 2007 at 16:03

With Express you don't actually have an Instance of SQL Server installed, it's a bit like access in that you just drop the .mdf and .ldf files for a database into your web folder. So the contention with other users of the hosting partners server is no different from any other file type.

Lots of ASP.NET 2.0 features rely on SQL 2005, in fact many features automatically use SQL express, so unless you have MSSQL access you lose a lot. There are lots of hosts out there that provide Express free or at reasonable rates, i'm just asking for reccomendations not M$ hating.

As said in my original post this is not for commercial stuff, just as a testbed for my own purposes so don't want a dedicated server or VPS but I am happy to pay a bit more ie £150 a year sort of figure.

pinkaardvark · 9 May 2007 at 16:20

thedazman67 said:
I'm with UltimaHosts great customer service and good prices, fully featured.

http://www.ultimahosts.net/

thedazman

Looks good but a bit concerned about the "unlimited" dimension. what's the performance like? and can I ask what your hosting with them.

pinkaardvark · 9 May 2007 at 16:28

elkdanger said:
If it's just for testbed stuff, why do you need hosting? Could you not do your testbed stuff locally?

Basically i'm a .net winforms SQL developer but I want to expand my skillset to include ASP.NET. So yes I can run everything locally but I'd like to publish stuff for review, I'd also like to knock up some commercial sites for friends etc to get me into the whole web design arena. I've built web sites before many moons ago and I don't have any problems with the technology, ie I know enough ASP/CSS/XML etc to get me through but I want some experience working with real published sites and if hosting is only a couple of hundred quid it's no real loss.