Home > 2010 Winter BTI420 > Database server for our ASP.NET web apps

Database server for our ASP.NET web apps

February 10, 2010 Leave a comment Go to comments

In this post, you learn about the database server that will be used for our ASP.NET web apps.

This section covers database servers in general, and specifically the server we use in BTI420.

ASP.NET web applications can work with all the modern widely-used database server technologies, including Microsoft SQL Server, Oracle, IBM DB/2, and MySQL. As you will learn, the .NET Framework includes classes that enable you to work with database (and other) data sources in a consistent and object-oriented manner.


The warp server cluster’s database server

The warp server cluster has Microsoft SQL Server 2008 installed on it. Here are some notable highlights:

  • Each BTI420 student has an account on the database server
    • Your credentials were given to you during the first week of classes
    • Your database server password is not synchronized with your warp (web app development) server password, so if you changed your warp (web app development) password, you will still need to use your originally-assigned database server password (until you manually change it yourself)
  • Each BTI420 student has their own private database on the server
  • The host address of the database server is mssql.warp.senecac.on.ca
  • You can use any of a number of database administrationapplication development, or data access classes to work with the database


What is SQL Server?

Microsoft SQL Server 2008 is a relational database management system. Its data definition language (DDL) and data manipulation language (DML) is Transact-SQL, which is an implementation of the ANSI and ISO standard Structured Query Language (SQL). Versions of SQL Server are available for a wide range of uses, as suggested by the following list:

  • SQL Server Compact, a lightweight implementation which can be embedded in applications (and therefore devices) of all sizes
  • SQL Server Express, an entry-level implementation, suitable for small- and medium-sized applications
  • SQL Server Workgroup, and SQL Server Standard, suitable for medium-sized applications, which may include advanced management data warehousing functionality
  • SQL Server Enterprise, suitable for the highest level of scalable applications

This list of versions is provided to you for a number of reasons, including the need to be aware of this wide range of uses and therefore scalability. As a developer, some of the things that you are interested in include development efficiency and effectiveness. Targeting SQL Server enables you to create and deploy to small, medium, and large applications. Those who dismiss SQL Server as a “niche” product, and therefore not flexible, or scalable, or whatever, are misinformed, in denial, or ignorant.


SQL Server Express is in Visual Studio

When Visual Studio is installed, SQL Server Express is installed. For best results, use Visual Studio 2008, because it installs the current version of SQL Server Express Edition. An application note will be published which will describe how to get started with SQL Server Express.

One or more instances of SQL Server Express can also be installed separately from Visual Studio. For example, you can install it on a web server so that its web applications have access to a database server.


Sample databases

The mssql.warp.senecac.on.ca database server has two sample databases installed. Both databases are available to us in read-only mode. We will use these databases directly in read-only mode, and we will also copy some of their database objects to our own databases, so that we can perform DDL and DML operations that modify data. The databases:

  1. Northwind
  2. AdventureWorks


Categories: 2010 Winter BTI420
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: