Catálogo de publicaciones - libros

This chapter presented the background you need to get started with SQL Server Express. The chapter began by giving you a summary of what SQL Server Express is, and described four types of potential SQL Server Express users. Then it contrasted SQL Server Express with enterprise-scaled SQL Server 2005 editions and MSDE. Next, the chapter drilled down on how to install a SQL Server Express instance. The chapter concluded with two sections that demonstrated how to create client applications for SQL Server Express. One of these sections introduced the SSMS-based query tool for SQL Server Express, and the other section showed examples of down-level client applications interacting with SQL Server Express databases. In the process of preparing a SQL Server Express instance for connection from remote and down-level clients, you learned critical steps for configuring both a SQL Server Express instance and a Windows XP firewall.

This chapter drilled down on two tools for running T-SQL statements. Express SSMS is a rich graphical tool for running T-SQL statements. Express SSMS is especially designed for SQL Server Express, although you can use it to run T-SQL statements for other SQL Server 2005 editions and even other SQL Server versions, such as the MSDE version of SQL Server 2000. This chapter demonstrated many of the most important Express SSMS features, including how to

Chapters 3 through Chapter 8 examine in-depth T-SQL coding techniques that you can use from within Express SSMS (or any other query tool).

The second tool covered in this chapter is the sqlcmd utility. This command-line application also runs T-SQL statements, but it offers no graphical user interface. The sqlcmd utility is especially designed for IT professionals and SQL Server power users. What the sqlcmd utility lacks in ease of use it compensates for by exposing an interface that makes it fast to invoke T-SQL statements without the overhead of a graphical user interface. In addition, the coverage of the sqlcmd utility included an example showing how to schedule the automatic running of sqlcmd tasks using the Windows Scheduled Tasks applet.

This chapter focused heavily on how to explore, create, and recover databases. In the area of exploring databases, the chapter covered system catalog views and selected stored procedures. sys.databases was the main catalog view covered in the chapter, but sys.tables and sys.columns were also given some attention. The system-stored procedures for learning about and manipulating databases covered here included sp_helpdb and sp_dboption. The review of creating databases focused on programmatic approaches; see Chapter 2 for a demonstration of graphical techniques for creating databases. This chapter illustrated how to create and manipulate databases programmatically with Express SSMS. You were also able to take a close look at the CREATE DATABASE statement from multiple perspectives, including creating a database from scratch as well as attaching data and log files copied from databases that already exist. The chapter’s final major section drilled down on backing up and restoring databases. You learned core concepts and saw specific examples that illustrated how to build backup and restore solutions with the BACKUP DATABASE and RESTORE DATABASE statements.

This chapter showed you how to create tables for the solutions that you build with SSE. Tables are at the heart of every custom database solution. If you can’t build your own tables, you are limited to selecting from tables created by other developers and administrators. Even in this case, knowing about the table design issues covered in this chapter can help you to design smarter SELECT statements and to debug your SELECT statements faster.

This chapter drilled down on two tools for running T-SQL statements. Express SSMS is a rich graphical tool for running T-SQL statements. Express SSMS is especially designed for SQL Server Express, although you can use it to run T-SQL statements for other SQL Server 2005 editions and even other SQL Server versions, such as the MSDE version of SQL Server 2000. This chapter demonstrated many of the most important Express SSMS features, including how to

Chapters 3 through Chapter 8 examine in-depth T-SQL coding techniques that you can use from within Express SSMS (or any other query tool).

The second tool covered in this chapter is the sqlcmd utility. This command-line application also runs T-SQL statements, but it offers no graphical user interface. The sqlcmd utility is especially designed for IT professionals and SQL Server power users. What the sqlcmd utility lacks in ease of use it compensates for by exposing an interface that makes it fast to invoke T-SQL statements without the overhead of a graphical user interface. In addition, the coverage of the sqlcmd utility included an example showing how to schedule the automatic running of sqlcmd tasks using the Windows Scheduled Tasks applet.

This chapter focused heavily on new and advanced data access topics for those creating solutions with SQL Server Express. The two main advanced topics include

The new topics include

This chapter showed you how to create tables for the solutions that you build with SSE. Tables are at the heart of every custom database solution. If you can’t build your own tables, you are limited to selecting from tables created by other developers and administrators. Even in this case, knowing about the table design issues covered in this chapter can help you to design smarter SELECT statements and to debug your SELECT statements faster.

This chapter had two main objectives. First, it covered the basics of Visual Basic programming for Windows forms. Second, it presented a series of samples that illustrated several typical kinds of tasks suitable for development with VBE. Among the major topics this chapter addressed were

This chapter had two main objectives. First, it covered the basics of Visual Basic programming for Windows forms. Second, it presented a series of samples that illustrated several typical kinds of tasks suitable for development with VBE. Among the major topics this chapter addressed were

This chapter showed you how to create tables for the solutions that you build with SSE. Tables are at the heart of every custom database solution. If you can’t build your own tables, you are limited to selecting from tables created by other developers and administrators. Even in this case, knowing about the table design issues covered in this chapter can help you to design smarter SELECT statements and to debug your SELECT statements faster.