Microsoft SQL Server 2005 Express Edition For Dummies (For Dummies (Computers)) [Paperback]

Robert Schneider (Author)

Book Description

ISBN-10: 0764599275 | ISBN-13: 978-0764599279 | Publication Date: July 31, 2006

• Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database
• Written in the typical nonintimidating For Dummies style, the book's emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft's Express product line
• Covers how to use SQL Server Express Manager, an easy-to-use management tool that comes with SSE, and the Application XCopy feature, which provides SSE with the ability to treat databases like files
• Addresses topics unique to SSE and not covered in standard SQL Server books, including network and security features, migrating and connecting from Access and MSDE to SSE, and migrating from SSE to the full-blown SQL Server database
• The CD-ROM contains SQL Server Express trial version and the Web site has the code from applications featured in the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Editorial Reviews

From the Back Cover

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

About the Author

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 [e-mail].

Product Details

• Paperback: 408 pages
• Publisher: For Dummies (July 31, 2006)
• Language: English
• ISBN-10: 0764599275
• ISBN-13: 978-0764599279
• Product Dimensions: 9.2 x 7.3 x 1 inches
• Shipping Weight: 15.2 ounces (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (6 customer reviews)
• Amazon Best Sellers Rank: #240,452 in Books (See Top 100 in Books)
  • #71 in Books > Computers & Technology > Microsoft > Development > SQL Server

Customer Reviews

Most Helpful Customer Reviews

11 of 11 people found the following review helpful:

5.0 out of 5 stars Really helped me understand this product!!, July 29, 2006

By 

Rory "Rory" (USA) - See all my reviews

This review is from: Microsoft SQL Server 2005 Express Edition For Dummies (For Dummies (Computers)) (Paperback)

I downloaded SQL Server for free from microsoft but needed some guidance to help me use the product to its full potential. In searching amazon I came across this book and decided to take a chance. Wow! It gave me a great broad overview of the product without bogging me down in too many details -- great simple writing style, really easy to follow.

In a few days, I was up and running with the software. I'm planning on writing an application using Visual Basic and this book has a great tutorial on using it this way. I would highly recommond this book to anyone who needs to learn how to use SQL Server.

6 of 7 people found the following review helpful:

1.0 out of 5 stars We're Dummies, Not Stupid, July 8, 2007

By 

I. Kolak (Sydney, Asutralia) - See all my reviews
(REAL NAME)   

This review is from: Microsoft SQL Server 2005 Express Edition For Dummies (For Dummies (Computers)) (Paperback)

The first 100 pages were read before starting to learn anything of real value. Please don't write for the sake of increasing the page volume of a book. Our time is valuable too.

Trying to be funny and telling us SQL Server 2005 Express is Free over and over again, chapter after chaper, is ... well ... simply not funny. We're dummies, not stupid.

You covered T-SQL relatively well. However, the heart and soul of SQL Server 2005 Express is Stored Procedures, Triggers and SQLCLR - but you barely even scratched the surface. A few pages here and there is not simply enough. So I still feel like a dummy.

6 of 7 people found the following review helpful:

5.0 out of 5 stars A Lot of Good Points about this Book, August 26, 2006

By 

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

This review is from: Microsoft SQL Server 2005 Express Edition For Dummies (For Dummies (Computers)) (Paperback)

There's a whole bunch to like, in my opinion, about this book and only one point that I think is pretty weak.

First off, what's there to like. Probably most important is that SQL Server Express is available and it's an extremely powerful software system and it's FREE, a very good price. Second is the book which is written in the typical 'For Dummies' style, with an occasional joke thrown in, that makes it pretty easy to read and yet is doing its job of educating you about the subject. And third, there's a CD-ROM supplied with the book that contains SQL Server Express as well as a lot of ancillary but useful programs to go with it. Yes, you can download SQL Server from the Microsoft web site, but having a CD is a lot easier and faster.

The weak point. There's a chapter on migrating from Microsoft Access to SQL Server that primarily talks about upgrading the tables from Access format to SQL Server format using one of the utilities provided. What's missing is a discussion on the differences in Access SQL (based on the 1989 standard) and SQL Server SQL (based on the 1992 standard). If you've used SQL to talk to Access on your previous system, you're in for a bit of a challenge to get it to talk to SQL Server.