SQL Server 2005 Express (SSE) is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (non-enterprise) features from SQL Server 2005, and comes complete with its own dedicated development and administration tools. As such, not only is it an ideal database for developers and administrators to use in prototype/evaluation projects, it is also a powerful development platform in its own right for low-budget database applications for non-profit Web Sites, as well as small office/departmental solutions and even eCommerce sites.
This book provides all of the installation, configuration, administration and development techniques that you need to build these types of application quickly and effectively. It focuses on solution techniques that are easy to learn, fast to implement, and transparent in the ways they address real-world problems. It covers: SQL Server Express tools and techniques, including use of Express Manager, and T-SQL programming; Using Visual Basic Express with SSE to build Windows Forms applications; Using Visual Web Developer with SSE for rapid but effective development of ASP.NET Web applications.
The book includes two full example case studies showing how to build a paypal-based eCommerce site and a Church administration application.