Wrox's SQL Server 2005 Express Edition Starter Kit (Programmer to Programmer) [Paperback]

Rajesh George (Author), Lance Delano (Author)

Book Description

ISBN-10: 0764589237 | ISBN-13: 978-0764589232 | Publication Date: January 11, 2006

You'll learn the basics of working with SSE databases, and see how the Visual Basic(r) 2005 Express Edition programming environment is tailored to work well with SSE. Step-by-step examples cover major scenarios that you're likely to face, from installation and development to debugging and deployment. Plus, the CD-ROM features both VB Express and SSE so you can get started designing your databases right away.

What you will learn from this book

• How to create simple, single table applications without writing a single line of code
• Making the transition from SSE to a higher-level version of SQL Server
• The benefits of using XML in your database
• How to deploy your applications using Xcopy
• How to secure your database applications
• How to move your database to a multi-user scenario

Who this book is for

This book is for database or programming novices who want to create and deploy database applications. It is also useful for experienced developers and independent software vendors who intend to develop applications for SSE.

Wrox Starter Kits give you a CD-ROM with the software development tools you need to get started as well as structured tutorials that walk you through all the techniques you need to begin programming right away.

Editorial Reviews

From the Back Cover

You'll learn the basics of working with SSE databases, and see how the Visual Basic® 2005 Express Edition programming environment is tailored to work well with SSE. Step-by-step examples cover major scenarios that you're likely to face, from installation and development to debugging and deployment. Plus, the CD-ROM features both VB Express and SSE so you can get started designing your databases right away.

What you will learn from this book

• How to create simple, single table applications without writing a single line of code
• Making the transition from SSE to a higher-level version of SQL Server
• The benefits of using XML in your database
• How to deploy your applications using Xcopy
• How to secure your database applications
• How to move your database to a multi-user scenario

Who this book is for

This book is for database or programming novices who want to create and deploy database applications. It is also useful for experienced developers and independent software vendors who intend to develop applications for SSE.

Wrox Starter Kits give you a CD-ROM with the software development tools you need to get started as well as structured tutorials that walk you through all the techniques you need to begin programming right away.

About the Author

Rajesh George is one of the founders of the SQL Server Express project within Microsoft, and has been involved in many of the key design decisions. He worked as a program manager on the SQL Server team responsible for various functionalities in SQL Server Express, MSDE, and SQL Data Access layers. He has spoken at several conferences and has authored the SQL Server Express Overview white paper on Microsoft.com. With prior software development experience in the Windows team at Microsoft as well as companies such as Nortel Networks and Netscape, he is currently a development manager at Amazon.com. Rajesh holds a Masters in Computer Science from Mississippi State University and MBA from University of Washington. You can reach him directly at [e-mail].

Lance Delano is a lead program manager in Visual Studio. Lance has an extensive background in database tools including database design and query tools. He is heavily involved in the customer research, proposals, specification, and program management of SQL Server Express.

Product Details

• Paperback: 384 pages
• Publisher: Wrox (January 11, 2006)
• Language: English
• ISBN-10: 0764589237
• ISBN-13: 978-0764589232
• Product Dimensions: 9.2 x 7.4 x 0.9 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #1,308,972 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

5.0 out of 5 stars SQL Server specific book, June 5, 2006

By 

nicole - See all my reviews

This review is from: Wrox's SQL Server 2005 Express Edition Starter Kit (Programmer to Programmer) (Paperback)

I use MSDE at work the last few years and has recently moved to SQL Server express. My biggest gripe about MSDE was that there was no book covering MSDE - all the books with MSDE in its title was covering other editions of SQL Server. I deployed MSDE with my application and the MSDE books were not very helpful.

I like this book because it focusses on SQL Server express. I like the sections specific to sql server express like setup and deployment and recommend this for those who use sql server express with VB.

11 of 12 people found the following review helpful:

5.0 out of 5 stars Good beginner book, May 17, 2006

By 

Josh "Josh" (Bellevue,USA) - See all my reviews

This review is from: Wrox's SQL Server 2005 Express Edition Starter Kit (Programmer to Programmer) (Paperback)

I am used to Access, and this book was wonderful to get introduced to and work with SQL Server. Step by step instructions on using sql with Visual Basic helped me a lot. The user interface provided was similar to my usage of access for basic scenarios; ofcourse access ui is more powerful than visual basic's. I would recommend it for a beginning user.

15 of 18 people found the following review helpful:

5.0 out of 5 stars A Beginners Book that doesn't cover SQL., March 20, 2006

By 

John Matlock "Gunny" (Winnemucca, NV) - See all my reviews
(REAL NAME)   

This review is from: Wrox's SQL Server 2005 Express Edition Starter Kit (Programmer to Programmer) (Paperback)

Among other things, Microsoft really likes to change the names of its products. For some years the Access database supplied as part of the Microsoft Office suite has come with two database engines. Originally supplied with the Jet database, Microsoft then began shipping it with a stripped down version of SQL Server, the latest name of which was Microsoft SQL Server Desktop Engine (MSDE).

SQL Server 2005 Express Edition (SSE) is MSDE brought up to date using SQL Server 2005 as the code base rather than SQL Server 2000. Perhaps the most important feature added is the graphical user interface that allows the creation of tables, defining relationships between tables and other simple database applications.

The one point that I would have liked to see in this book is more information, perhaps even a chapter on SQL. Especially in the section on migrating from the Jet database in Access to SSE some comments on the differences between the two SQL's would be very helpful.

For instance, in Access SQL (Jet Engine) you can have JOINs in UPDATE and DELETE statements. In T-SQL you can't. In T-SQL you can have a subquery in the SET clause of UPDATE statements, in the Jet engine you cannot. Finding all these differences is difficult. I'd like to see them in the migrating chapter.

Still, this book is intended for the beginner who is going to use Microsoft's GUI approach for everything, and not SQL. For that purpose it is excellent.