Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
Authors: N
Published year: 2006
Pages: 22-26/130

<< Previous page
Table of contents
Next page >>

Conclusion

Developing database applications requires not only the SQL Server itself, but also the inclusion of other tools to ensure the quality and reliability of your applications. Moreover, you need to make the proper choice about the SQL Server 2005 version you will use. Remember: you dont need a sophisticated environment to develop applications. In fact, SQL Server Express Edition might meet all of your development needs. However, it is a good idea to have at least the SQL Server Workgroup version of the software to test scalability and perform multi- user testing.

Chapter 2 Quick Reference

To	Do This
Work with security strengths, the Web, and Reporting Services	Previously install IIS.
Work smoothly with database application development	Ensure that you have a 500 MHz processor or higher and have at least 512 MB of memory.
Test different production environments	Use Virtual PC or Virtual Server.
Develop with security in mind	Try to work with a domain controller (Active Directory DC), and use a domain account to run SQL Server Services.
Configure which services to run	Use the Surface Area Configuration Tool.
Enable special features in your database server	Use the Surface Area Configuration Tool.

Chapter 3: Reviewing Microsoft SQL Server 2005 Management Tools

Download CD Content

Overview

After completing this chapter, you will be able to:

Use SQL Server Books Online
Use SQL Server Configuration Manager
Use SQL Server Surface Area Configuration
Use SQL Server Management Studio
Use SQL Server Profiler
Use Database Engine Tuning Advisor
Use SQLCmd

Introduction

Using Microsoft SQL Server 2005 does not only involve the creation and development of databases, tables, indexes, and stored procedures. Many tools are available to help you analyze behavior, enable features, and study and enhance the performance of your server. This chapter will acquaint you with all of these tools so that you will discover where to find the exact information you need and achieve the best results during the development and configuration process.

Using SQL Server Books Online

SQL Server Books Online is the SQL Server 2005 product documentation. It covers all of the features of the product such as the Database Engine, Analysis Services, Integration Services, Replication, Reporting Services, Notification Services, Service Broker, and Full-Text Search.

Accessing SQL Server Books Online

To open SQL Server Books Online, from the Start menu, select All Programs Microsoft SQL Server 2005 Documentation And Tutorials SQL Server Books Online. You will arrive at the Welcome page, which contains links to the major divisions of the content.
Click the Search tab in the upper zone to search for specific information.
In the Search tab, type the topic of your search in the empty search string textbox.
Under the search string textbox, two expandable links can be used to select either the technology or the type of content that you want to search.

The results of your search will appear grouped into four sections on the right side of the Search tab according to the source of the information. These four sections are:
- Local Help
- MSDN Online
- Codezone Community
- Questions

Click one of the four sections to view the list of results from that source.

Tip	You will find the MSDN Online section to be very useful because this is where the most current content is located. The Codezone Community and Questions sections contain solutions from other users and community specialists, such as the MVPs nominated by Microsoft.

<< Previous page
Table of contents
Next page >>