1
00:00:00,200 --> 00:00:07,200
《2. Using Microsoft SQL Server 2008》
-----本字幕由雷天音 整理制作-----
Most dynamic websites built with Microsoft ASP.NET need a database, a place on

2
00:00:07,200 --> 00:00:11,200
【----QQ 568031962----】
the server where data can be stored and retrieved to generate the pages that

3
00:00:11,200 --> 00:00:15,200
【----ACELY STUDIO----】
are requested by the client. I recommend using Microsoft SQL Server.

4
00:00:15,200 --> 00:00:22,200
SQL Server is one of a class of databases known as Enterprise Databases meaning

5
00:00:22,200 --> 00:00:28,200
that they can handle very large amounts of data and a large number of simultaneous users.

6
00:00:28,200 --> 00:00:33,200
There are many database products available on the market. MySQL, which is now

7
00:00:33,200 --> 00:00:38,200
owned by Sun Microsystems, is a free database that provides powerful relational

8
00:00:38,200 --> 00:00:42,200
database support. There is also Oracle, one of the best of the Enterprise

9
00:00:42,200 --> 00:00:48,200
Database class and IBM DB2, and you can also select Microsoft Access.

10
00:00:48,200 --> 00:00:52,200
When building an ASP.NET website, I think that Microsoft SQL Server is

11
00:00:52,200 --> 00:00:58,200
your best bet for these reasons. First of all, it's highly scalable, meaning that

12
00:00:58,200 --> 00:01:04,200
it can handle enormous amounts of data and a large number of simultaneous users.

13
00:01:04,200 --> 00:01:09,200
This distinguishes it from Microsoft Access, which is really designed for use

14
00:01:09,200 --> 00:01:12,200
as a Desktop database by an individual user.

15
00:01:12,200 --> 00:01:17,200
While it is possible to build a dynamic website using Microsoft Access and

16
00:01:17,200 --> 00:01:22,200
while ASP.NET does include all of the software or drivers that you need to use

17
00:01:22,200 --> 00:01:27,200
Access in the web environment, most developers and website administrators find

18
00:01:27,200 --> 00:01:32,200
that there is a very quick upper limit to both the amount of data and number of

19
00:01:32,200 --> 00:01:36,200
simultaneous users that you can support with the Access model.

20
00:01:36,200 --> 00:01:40,200
ASP.NET includes all of the required drivers not just for Access though, but

21
00:01:40,200 --> 00:01:46,200
also for SQL Server and this distinguishes SQL Server from products like MySQL,

22
00:01:46,200 --> 00:01:52,200
Oracle and IBM DB2. If your organization has already invested in those databases,

23
00:01:52,200 --> 00:01:56,200
that is, if you have enormous amount of data already in MySQL,

24
00:01:56,200 --> 00:02:01,200
Oracle or DB2, there are drivers available on the market for integration with

25
00:02:01,200 --> 00:02:06,200
the .NET Framework. But if you're getting started for the first time with data

26
00:02:06,200 --> 00:02:10,200
that will be used to support a dynamic website, you will find you'll be able to

27
00:02:10,200 --> 00:02:12,200
get started more easily with SQL Server.

28
00:02:12,200 --> 00:02:20,200
SQL Server and ASP.NET share a programming model, the .NET Framework. If you're

29
00:02:20,200 --> 00:02:25,200
familiar with programming in Visual Basic, .NET, C# or one of the other

30
00:02:25,200 --> 00:02:29,200
programming languages that's supported by .NET, you'll find you're able to use

31
00:02:29,200 --> 00:02:35,200
the same programming skills in both environments. Finally, SQL Server is highly

32
00:02:35,200 --> 00:02:39,200
integrated with Windows and its security model, which makes it easy to create

33
00:02:39,200 --> 00:02:45,200
integration and authentication of users when dealing with secured websites.

34
00:02:45,200 --> 00:02:49,200
To get started with SQL Server, the first step is to figure out which version

35
00:02:49,200 --> 00:02:54,200
of SQL Server you need. There are many editions of SQL Server available.

36
00:02:54,200 --> 00:02:58,200
You can go to this webpage, which is listed on the screen at

37
00:02:58,200 --> 00:03:09,200
www.msdn.microsoft.com/en-us/ library/ms144275.aspx. This webpage,

38
00:03:09,200 --> 00:03:14,200
at the SQL Server Developer Center, includes a listing of all of the different

39
00:03:14,200 --> 00:03:17,200
editions of SQL Server that are available.

40
00:03:17,200 --> 00:03:21,200
When you deploy your ASP.NET website, if you're building an enormous website

41
00:03:21,200 --> 00:03:25,200
that needs to serve a lot of users, you might need the Enterprise Edition of

42
00:03:25,200 --> 00:03:30,200
SQL Server, but you'll find that there are less expensive versions available as

43
00:03:30,200 --> 00:03:35,200
well, including the Web version, which is a much lower cost edition

44
00:03:35,200 --> 00:03:40,200
specifically designed for deployment with websites. You'll also find SQL Server

45
00:03:40,200 --> 00:03:47,200
Express listed on this page. I'll be using SQL Server Express with Tools during this video series.

46
00:03:47,200 --> 00:03:53,200
This edition of SQL Server includes both the server itself and the tools you

47
00:03:53,200 --> 00:03:57,200
need to manage the server allowing you to create new databases, manage the

48
00:03:57,200 --> 00:04:04,200
structure of existing databases and configure SQL Server on your system for use

49
00:04:04,200 --> 00:04:07,200
with your development environment. I should caution that if you're going to

50
00:04:07,200 --> 00:04:12,200
install SQL Server Express on the same machine on which you're running Visual

51
00:04:12,200 --> 00:04:16,200
Web Developer, and the .NET Framework, the machine should be equipped with a

52
00:04:16,200 --> 00:04:23,200
minimum of 1 Gigabyte of RAM and you'll probably find that 2 Gigabytes of RAM will be much better.

53
00:04:23,200 --> 00:04:27,200
You will find other editions of SQL Server on the same page including the

54
00:04:27,200 --> 00:04:32,200
Compact Edition, which is designed for mobile devices and web clients on all

55
00:04:32,200 --> 00:04:38,200
Windows platforms. In order to download the appropriate version of SQL Server,

56
00:04:38,200 --> 00:04:49,200
go to this page, www.microsoft.com/express/sql. On this page you'll find a simple listing

57
00:04:49,200 --> 00:04:54,200
of the SQL Server 2008 Express product and a link to get started.

58
00:04:54,200 --> 00:04:59,200
When you click through to the link, you'll be able to download SQL Server 2008

59
00:04:59,200 --> 00:05:03,200
Express for free. You don't have to register; you can go directly to the

60
00:05:03,200 --> 00:05:08,200
download page by clicking on the Download link, but if you do register, it will

61
00:05:08,200 --> 00:05:12,200
allow you to receive information from Microsoft about changes to the SQL Server

62
00:05:12,200 --> 00:05:15,200
2008 Express product.

63
00:05:15,200 --> 00:05:19,200
As you scroll down on the page, you'll find a number of versions that you can

64
00:05:19,200 --> 00:05:24,200
select from. If you're getting started with SQL Server for the first time,

65
00:05:24,200 --> 00:05:30,200
choose this download, SQL Server 2008 Express with Tools. You'll receive both

66
00:05:30,200 --> 00:05:35,200
the SQL Server Database Engine that allows you to create databases, set up

67
00:05:35,200 --> 00:05:42,200
-----本字幕由雷天音 整理制作-----
-----更多Lynda字幕请访问我的人人-----
-----联系邮箱：acely@126.com-----
their structure and create initial data and SQL Server Management Studio Basic,

68
00:05:42,200 --> 00:05:42,200
an integrated environment for managing your SQL Server installation.