System Engineering Design Tallahassee

Technical Corner...

ASP.NET

What is ASP.NET? ASP is an acronym for Active Server Pages. "NET" refers to technology that is suited for internet development and solutions. ASP.NET is arguably the leading web framework for building interactive web sites. Application of this technology provides faster performance and tighter security.

ASP.NET provides enchanced security with it's "built-in" Membership Application Programming Interface (API) module. This module allows for building a user registration system that stores user information in an SQL SERVER database or Active Directory. Thus, multiple users may be assigned different roles with specific "web paths" for each type of user. Also, both the username and password are encrypted in the database for added security.

Microsoft's Visual Studio is an Integrated Development Environment (IDE) used by System Engineering Design to build ASP.NET applications. It provides the flexibility to build N-tier applications allowing for a separation of the presentation layer, the business logic layer and the data access layer. This means web pages, business rules for processing data, and the type of relational database used (DB2/UDB, SQL Server, Oracle) may be changed without impacting the entire application. System Engineering Design builds N-tier applications.

An additional advantage of ASP.NET is the ability to cache data, a web page or part of a web page. This enhances the web browsing experience by providing faster web page loading and data retrieval.

System Engineering Design applications are coded using the VB.NET programming language or the C# programming language. SQL Server is the database of choice.

ASP.NET handles 1.5 billion page views per day and 2.3 million concurrent users View Article...

SQL SERVER

What is SQL SERVER? SQL is an acronym for Structured Query Language. "SERVER" refers to data that is stored and retrieved from a server. SQL SERVER is a database component useful for many applications. It is ideally suited to an internet application where "permanent" storage is needed.

SQL SERVER is a full-bodied database. This means that a database administrator can set indexes and define various column types (date, numeric, text, etc). Also, since it's a relational database, data tables can be associated to each other. SQL is the common language used for relational databases. This language is used to build or modify data structure and to create, read, update or delete records.

"SQL Server 2008 provides the highest levels of security, reliability, and scalability for your business-critical applications." ...quote from SQL Server 2008 Overview

Learn more about SQL Server 2008 View Article...

ASP.NET TECH TIPS

Save bandwidth by disabling View State when not needed View Article...

Use cascading style sheets, themes and skins for a consistent look and feel View Article...

Use text files versus xml files if writing-out large amounts of data for database consumption View Article...

Use master pages for web pages that require the same header, footer and menu items View Article...

Use datareader versus dataset to save memory View Article...

Close database connections when no longer needed View Article...

Know the page and control life cycles View Article...

Build applications using the N-tier architecture (presentation, business, data) View Article...

Create component libraries for common actions (DLLs) View Article...

Use namespaces to group type names and to avoid naming collisions View Article...

Use error handling routines in your code (try, catch, finally) View Article...

Should VB.NET or C# be used to build ASP.NET applications? View Article...

Server hardware purchase and installation is the responsibility of the agency. Server software and software installation (such as SQL Server database and the Server Operating System) that are required for the Contract Invoicing System to function properly will be the responsibility of the agency. Server security will be the responsibility of the agency. If the agency does not have the technical staff to accomplish these actions, System Engineering Design will provide this expertise from a pool of knowledgeable consultants. The agency will be responsible for all hardware and software costs including the salaries of persons needed to complete the installation of hardware and software. Agency is defined as the party purchasing the Contract Invoicing System software.