Microsoft SQL Server 2005 Express Edition For Dummies
1st Edition
Published on 1. May 2006
Book
Paperback/Softback
408 pages
978-0-7645-9927-9 (ISBN)
Description
Find code for sample applications on the companion Web site
Get up and running in no time with this streamlined version of SQL Server
SQL Server Express with Advanced Services is new, cool, inexpensive, and now -- thanks to this book -- easy to handle! This friendly guide helps you migrate data from other databases, use SQL Server Management Studio Express, protect your information, even create applications and putter with a little programming.
Discover how to
* Use SQL Server Management Studio Express
* Migrate data from Access and MSDE
* Create custom reports using Advanced Services
* Formulate and run queries
* Maintain data integrity with transactions
* Employ XML to send data to Web applications
Get up and running in no time with this streamlined version of SQL Server
SQL Server Express with Advanced Services is new, cool, inexpensive, and now -- thanks to this book -- easy to handle! This friendly guide helps you migrate data from other databases, use SQL Server Management Studio Express, protect your information, even create applications and putter with a little programming.
Discover how to
* Use SQL Server Management Studio Express
* Migrate data from Access and MSDE
* Create custom reports using Advanced Services
* Formulate and run queries
* Maintain data integrity with transactions
* Employ XML to send data to Web applications
More details
Person
Robert D. Schneider has more than 15 years of experience developing and delivering sophisticated software solutions worldwide. He has provided database optimization, distributed computing, and other technical expertise to a wide variety of enterprises in the financial, technology, and government sectors. Clients have included Chase Manhattan Bank, VISA, HP, SWIFT, and the governments of the United States, Brazil, and Malaysia.
He is the author of Optimizing Informix Applications, Microsoft SQL Server: Planning and Building a High Performance Database, and MySQL Database Design and Tuning. He has also written numerous articles on technical and professional services topics. He can be reached at Robert.Schneider@Think88.com.
He is the author of Optimizing Informix Applications, Microsoft SQL Server: Planning and Building a High Performance Database, and MySQL Database Design and Tuning. He has also written numerous articles on technical and professional services topics. He can be reached at Robert.Schneider@Think88.com.
Content
Introduction.
Part I: Welcome to SQL Server 2005 Express.
Chapter 1: SQL Server 2005 Express Overview.
Chapter 2: Downloading and Installing SQL Server 2005 Express on Your Computer.
Chapter 3: Setting Up SQL Server Express.
Part II: Administering a SQL Server 2005 Express System.
Chapter 4: Putting SQL Server 2005 Express to Work.
Chapter 5: Maintaining a SQL Server 2005 Express System.
Chapter 6: Distributing Your Data with Replication.
Part III: Adding and Accessing a SQL Server 2005 Express Database.
Chapter 7: Planning Your Database.
Chapter 8: Creating Databases, Tables, and Relationships.
Chapter 9: Talking to a SQL Server.
Chapter 10: Transact-SQL: Beyond the Basics.
Part IV: Keeping Your Data Safe from Harm.
Chapter 11: Securing Your Data.
Chapter 12: Keeping It Together: Using Transactions to Maintain Data Integrity.
Chapter 13: Preventing Data Loss.
Part V: Putting the Tools to Work: Programming with SQL Server 2005 Express.
Chapter 14: Using Stored Procedures and Functions.
Chapter 15: Understanding Triggers.
Chapter 16: Going Beyond Transact-SQL: Using the SQL Common Language Runtime (SQLCLR).
Chapter 17: Sorry, I'll Try That Again: Adding Error Handling to Your Code.
Chapter 18: Full-Text Searching and Reporting Services.
Part VI: Creating SQL Server 2005 Express Applications.
Chapter 19: Building a Simple Desktop Application with Visual Basic Express.
Chapter 20: Building a Simple Web Application with Visual Web Developer Express.
Chapter 21: Using XML with SQL Server 2005 Express.
Part VII: The Part of Tens.
Chapter 22: Ten Sources of Information on SQL Server 2005 Express.
Chapter 23: Ten SQL Server 2005 Express Troubleshooting Tips.
Part VIII: Appendixes.
Appendix A: Upgrading to SQL Server 2005.
Appendix B: Migrating to SQL Server 2005 Express.
Appendix C: Glossary.
Appendix D: About the CD-ROM.
Index.
Part I: Welcome to SQL Server 2005 Express.
Chapter 1: SQL Server 2005 Express Overview.
Chapter 2: Downloading and Installing SQL Server 2005 Express on Your Computer.
Chapter 3: Setting Up SQL Server Express.
Part II: Administering a SQL Server 2005 Express System.
Chapter 4: Putting SQL Server 2005 Express to Work.
Chapter 5: Maintaining a SQL Server 2005 Express System.
Chapter 6: Distributing Your Data with Replication.
Part III: Adding and Accessing a SQL Server 2005 Express Database.
Chapter 7: Planning Your Database.
Chapter 8: Creating Databases, Tables, and Relationships.
Chapter 9: Talking to a SQL Server.
Chapter 10: Transact-SQL: Beyond the Basics.
Part IV: Keeping Your Data Safe from Harm.
Chapter 11: Securing Your Data.
Chapter 12: Keeping It Together: Using Transactions to Maintain Data Integrity.
Chapter 13: Preventing Data Loss.
Part V: Putting the Tools to Work: Programming with SQL Server 2005 Express.
Chapter 14: Using Stored Procedures and Functions.
Chapter 15: Understanding Triggers.
Chapter 16: Going Beyond Transact-SQL: Using the SQL Common Language Runtime (SQLCLR).
Chapter 17: Sorry, I'll Try That Again: Adding Error Handling to Your Code.
Chapter 18: Full-Text Searching and Reporting Services.
Part VI: Creating SQL Server 2005 Express Applications.
Chapter 19: Building a Simple Desktop Application with Visual Basic Express.
Chapter 20: Building a Simple Web Application with Visual Web Developer Express.
Chapter 21: Using XML with SQL Server 2005 Express.
Part VII: The Part of Tens.
Chapter 22: Ten Sources of Information on SQL Server 2005 Express.
Chapter 23: Ten SQL Server 2005 Express Troubleshooting Tips.
Part VIII: Appendixes.
Appendix A: Upgrading to SQL Server 2005.
Appendix B: Migrating to SQL Server 2005 Express.
Appendix C: Glossary.
Appendix D: About the CD-ROM.
Index.