Top VPS Hosting Provider

web hosting

Microsoft SQL 2008 Beta

by Tony P. on June 6, 2008

We are now offering Microsoft SQL 2008 Beta databases. A SQL database allows you to store and retrieve data. This is useful for web applications that are designed to take information from users and store it. For example, a web application can be designed to ask visitors for their email address. When a visitor enters their email address the application can save it to a database. At a later time, a list of email addresses can be retrieved from the database to be used.

Previously we only offered support for Microsoft Access databases and Microsoft SQL 2000 databases. For high volume sites with large databases, Microsoft Access is perhaps not the most ideal solution. It is also incompatible with ASP.NET web sites running on a Windows 2003 server. Microsoft SQL 2000 works well, but customers who develop their database on a newer version of the Microsoft SQL platform may find it difficult to transfer their data to myhosting.com.

With Microsoft SQL 2008, we have introduced new tools to make working with your database easier. One of these is the SQL Web Administration tool. It allows you to create and delete tables, retrieve and edit data, work with stored procedures, and run queries. This is great if you need to make a change quickly and would like to do it through your web browser.

SQL Web Administration Tool
The SQL Web Administration Tool

Most databases are developed and tested on a local workstation. When it is working correctly it is copied to the web hosting company’s server. To assist with this we are now offering a SQL Web Backup tool. To get your database on our server, first backup the database on your computer, then start the SQL Web Backup tool, upload your backup file, and finally restore it. This feature is available for both SQL 2000 and SQL 2008 databases. For a SQL 2000 database you can only restore a database that was created on a SQL 2000 server. For a SQL 2008 database you can restore a database that was created on a SQL 2000 server, a SQL 2005 server, or a SQL 2008 server.

SQL Web Backup Tool
The SQL Web Backup Tool

Microsoft is providing a free preview version of SQL Server 2008 Beta. The preview includes a copy of the latest SQL Server Management Studio. SQL Server Management Studio allows you to develop and work with a database. With this program you can connect to a SQL Server that is running on your local computer or connect to our SQL Server. If you would like to use SQL Server Management Studio to work with a SQL 2008 database, you will need to use the preview version from Microsoft. You can obtain the free download here.

myhosting.com offers a 25 megabyte database for free with all Premium and Professional hosting plans. If you would like to test out the new SQL 2008 Beta, why not sign up for your free account and then install an application such as DotNetNuke? DotNetNuke is a web application that can be used to build a web site. You can add features such as account login, banners, site search, and RSS feeds. You can build a web site that has all these features without DotNetNuke but it would take a lot of time to create. DotNetNuke is an open source application which means many developers contribute to it and you can download and modify the source code if you wish. We offer an auto-installer for the DotNetNuke application so you can get it up and running on your site in just a few minutes.

And if you outgrow the database it can be upgraded to a larger size for a fee. And if you run into any problems or have any questions, you can always contact our 24/7 Customer Support department for assistance!

Tony P
Software Developer
SoftCom Technology Consulting Inc.

Related posts:

  1. Microsoft SQL 2008 Beta now available!
  2. myhosting.com offers a great range of Microsoft SQL Hosting Plans including a Free Starter Plan!
  3. How to activate your Microsoft® SQL Server 2008 Database using your myhosting.com Account
  4. Database Hosting: MySQL, Microsoft SQL and PostgreSQL
  5. SQL Injection attacks on the rise

{ 6 comments }

IT Support October 2, 2009 at 5:03 PM

What’s the benefit over mysql?

Surely if you can’t make use of the reporting or analysis services then there’s no point for hosters…

Tony.

Birge Elif Basik / Community Manager of myhosting.com October 5, 2009 at 4:55 AM

Hi Tony,
Mysql has many benefits.
-It’s easy to install and deploy
-Easy to administer – MySQL is a low administration database.
-It has high performance
-It’s reliable and has a high availability, MySQL Cluster provides 99.999% availability.
-Mysql got its own embeddable library
-MySQL runs on Linux, Solaris, AIX, HP-UX, Windows, and Mac OS X.

By the way, our users can use reporting and analysis services!
Birge

Rebecca DeWitt, IT Support Raleigh August 15, 2010 at 12:24 PM

This sounds like a very interesting option for my clients. Thank you for bringing to my attention. I especially like the fact that the SQL can be enlarged as the clients’ needs increase. I am definitely going to take a closer look at this.

Steve Robbins October 29, 2010 at 2:32 AM

SQL looks good, I might try this one for my marketing page and i like its website backup tool

PotsNPans April 29, 2011 at 8:23 AM

I’m impressed by that list of advantages, especially the 99.999% availability!

Texas2Step September 19, 2011 at 9:05 AM

The embeddable library is just as impressive to me!

Previous post:

Next post:

Website Hosting and Domain Hosting Email Hosting Services, Pick Up Your Email
© 2013 SoftCom Inc. All rights reserved.