- What is SQL?
The Structured Query Language (SQL), pronounced either as ‘sequel’
or ‘ess queue ell,’ is a language syntax used to extract, define, and modify
information in a relational database. In a typical session, a query formatted in
SQL syntax is sent to a server, the server then executes the command, and then
the server either modifies the information in its database, or returns the
requested information, depending on the nature of the transaction.
- What is Shared MS SQL?
Shared MS SQL gives you a database partition on a shared server
(i.e., one which hosts other databases in addition to your own). This provides a
more cost-effective hosting solution than a dedicated MS SQL server, but still has
the same functionality.
- What is MS SQL Server?
MS SQL Server, also known as Microsoft®
SQL, is a relational
database management system (RDBMS) used to manage transactions between a client
and a database. It receives SQL queries from a client, executes those queries
against the database, and then returns the requested information back to the
client.
- How many databases can I have with my MS SQL account?
Customers on SQL 50, SQL 100, and SQL 200 are only allowed ONE
(1) database . Click
here to see a table comparing the different packages.
- How many MS SQL user accounts will I have?
For each MS SQL database purchased (a single account can purchase
multiple databases) you may have one user.
- How much MS SQL Server storage space will I get?
The amount of storage space provided is dependant on the
package that you select. For example, customers on SQL 50 plan are given 50 MB of disk space; customers
on SQL 100 plan are given 100 MB of disk space, and customers on SQL 200 plan are given 200
MB of disk space. Click
here to see a table comparing the different packages.
- Is MS SQL included in any of the hosting plans?
SQL is an option available with our Premium and Professional hosting plans
under the Windows Platform. A free SQL 25 database with 25 MB of storage is
available to all customers with these hosting plans. If you require more space,
you can upgrade to one of our larger MS SQL plans.
- Can I purchase additional MS SQL storage space?
Yes, you can purchase additional MS SQL storage space by upgrading your MS SQL Package. The maximum plan is the SQL 500 plan which includes 500 MB of SQL storage and 100 MB of Log storage.
- Do I need to know SQL in order to manage the database?
No, it is not necessary for you to have knowledge of SQL.
You can use our web-based, graphical interface, found
within the control panel of your account, to do most functions including: running
queries, creating stored procedures, and exporting and importing data.
- How many concurrent connections can I have?
According to Microsoft, a SQL database can support up to
30,000 concurrent connections as opposed to Access in which performance will be
affected after only 10 to 15 concurrent connections.
- What is the relation between MS SQL Server and a web page?
The MS SQL Server can be thought of as the back-end of a dynamic web
site. Its database contains categorized raw information. The web pages of the
site are the front-end; they, in effect, act as templates that control what,
when, why and how information contained in the database is displayed.
- What is the relation between SQL, MS SQL Server, and the database?
The SQL syntax defines the format in which requests are sent to a
MS SQL Server. MS SQL Server is a management application that interprets those
requests and carries out the appropriate actions on the database. The database
is the categorized information that the MS SQL Server acts upon.
- What kind of support will I get?
The support staff at myhosting.com are trained to check and
verify your MS SQL connection. However, due to the complexity of the SQL query
language, support will not be able to debug scripts or third-party applications.
- What tools can I use to connect with my MS SQL Database?
Customers can connect to MS SQL using Access, Enterprise
Manager, Visual Studio as well as through their .asp and .aspx scripts. You can
also administer your MS SQL database directly using our free browser-based
administration tool available through the control panel.
- What will I need to manage and transfer data to my MS SQL database?
You can connect to your database through our web-based,
graphical MS SQL manager. This is a browser-based version of Enterprise Manager
that allows you to manage your database in the same way you would with the
application, directly through the control panel.
- Which hosting packages is Shared MS SQL available with?
MS SQL is an option on the Premium and Professional hosting plans
under the Windows platform only.
- Why might I want to have a MS SQL database?
A database hosted on a MS SQL server provides you with the
ability to create dynamic, interactive web pages. It allows you, for example, to
display personalized web pages for each user, display information specific to a
certain search term that the user may have entered, or simply to collect and
store data for complex analysis. Additionally, it also provides you with the
ability to more easily manage the content of your web page. For example, if you
wanted to modify a particular item in a static, purely HTML-based site, you’d
have to manually change that item in each and every instance in which it
appears. In a dynamically created, database-driven web site, you only have to
modify the information in the database once, and that change will be shown
wherever the item is referenced on the web site.
- Why should I use MS SQL Server over other database formats?
You should elect to use MS SQL-based databases over other
database formats because MS SQL-based databases have been proven to be faster, more fault
tolerant, and more accessible than other traditional databases such as Access or
FoxPro.
- Will my MS SQL database disk usage be counted against my normal hosting disk space allocation?
No, your MS SQL database disk space is separate from the disk space
provided to you in with your normal hosting package.
Your trusted web host since 1997
1 (866) 289-5091
