Web hosting provider - Chapter 11 SQL Server Crash Course In This
Chapter 11 SQL Server Crash Course In This Chapter Exploring database design Designing a database with tables and primary keys Creating your own SQL Server tables Linking tables Abig part of any dynamic data-driven Web site is the database that contains data for the site. Visual Web Developer allows you to use either Microsoft Access (.mdb files) or SQL Server 2005 (.mdf files) for storing data. Of the two, a SQL Server database provides better scalability and supports a greater number of simultaneous users. That s why it s the database most people will likely want to use (or would, if they knew what we know), so that s the one that gets the focus in this book. As its title suggests, this chapter is a quick crash course in using SQL Server as the database for your Web site. You ll discover what SQL Server is, and how to create tables to store the data your Web site needs. You ll also get the lowdown on SQL, Structured Query Language, the tool you use to extract specific data from the database to display on Web pages. If you re already familiar with a database program like Microsoft Access, the most noticeable feature of SQL Server is that it has no user interface no program window you can open from the Start menu. There s no table designer, no forms designer, nothing. The reason for that is simple: Microsoft Access is an application program that has to perform multiple tasks for a wide range of users but SQL Server is a lot more specialized; it s just a server. As a server, SQL Server 2005 is designed to provide data storage and Access to some other program rather than to a human who is sitting at the mouse and keyboard. The working interface for SQL Server isn t in its own separate program window. It s right in Visual Web Developer.
From our experience, we can recommend PHP Web Hosting services, if you need affordable webhost to host and run your web application.