Datasheet

If you’re more inclined to use heavier-weight, more powerful tools, Visual
Studio 2005 makes a lot of sense to employ for application development. It’s
an extremely potent tool that contains a tremendous amount of functionality.
It’s also very well integrated with all SQL Server 2005 products, not only the
Express edition. Naturally, all this power comes with additional complexity
and a somewhat steeper learning curve, so you should decide if your applica-
tion requires all these capabilities.
Of course, Microsoft isn’t the only game in town when it comes to application
development technologies. You can use several third-party tools (including
open source and shareware) to construct a SQL Server-based solution.
Configuring, managing, and monitoring
SQL Server 2005 Express
With your database and application built, it’s natural to turn your attention to
setting configuration parameters and then monitoring the database. Here
again, you have no shortage of options.
To begin, SQL Server 2005 Express snaps into the standard Microsoft
Computer Management console. This lets you configure and run your data-
base services, which you can see in Figure 1-3.
Figure 1-3:
Configuring
SQL Server
2005
Express
services.
20
Part I: Welcome to SQL Server 2005 Express
05_599275 ch01.qxp 6/1/06 9:08 PM Page 20