Features
- Cover Type: Paperback with 408 pages
- Published by: For Dummies; Pap/Cdr edition July 31, 2006
- Written in: English
- ISBN 10 Number: 0764599275
- ISBN 13 Number: 978-0764599279
-
Book Dimensions:
9.3 x 7.3 x 1.3 inches
- Weighs: 15.2 ounces
Book Description
- 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.
Back Cover Copy
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
Reader Reviews
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.
Comment | |
(Report this)
Search for books at
