Microsoft SQL Server 2005

by Trent Swanson and Prashant Dhingra

SQL Server 2005 Compact Edition is the version of the SQL Server database designed for use in mobile devices. This text presents details of all features of the Compact Edition, and explains how to... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0672329220
• ISBN13: 9780672329227
• Release Date: January 2007
• Publisher: Sams
• Length: 601 Pages
• Weight: 2.15 lbs.
• Dimensions: 1.4" x 7.1" x 9.1"

Customer Reviews

Good book for User or Developer

Combined with existing Visual Studio help, internet and this book you have pretty much all you need. This book is a very good reference which I've used in development the last few months for a large project. I've got enough example code in my project now to cover just about every situation and plenty of content to work with. I just wish a Full SQL book wrote this well existed.

Nice book

Nice book, it has all yo need to manage and tune SQL CE, and a lot of information about programming it. If you are a developer, this is the book for you.

Wonderful Reference

SQL Server Compact Edition is meant for storing data on mobile devices such as Smartphones and PDA's or for inclusion in applications running disconnected on some user's laptop in an isolated environment. This wonderful book written by Prashant Dhingra and Trent Swanson, two Microsoft developers, is a large book about a small topic, SQL Server Compact Edition. The authors take the time to cover every aspect of working with Compact from installing it and working with the tools necessary to building your database, to programming, to synchronization with a central server, to (my favorite topic) tuning and (my least favorite) security. The book's approach is to provide you with plenty of explanations and documentation, but then to focus on step by step instructions so that you can do the things you need to do with this handy tool. The topics are not limited to the developer's side of the box, but instead spread out to cover installations, maintenance and various methods of synchronizing the data with central sources. All of it is covered in a great deal of depth, making this a very thorough book. They even go so far as to show you how to tune queries and adjust the database structure to optimize performance and enhance integrity. It's a very thorough book. If you're just getting started with SQL Server Compact, I can recommend this book as a must read. If you need to just support Compact, not necessarily develop on it, this book is also very useful.

Good for learning MS technologies.

SQL CE based app uses - VS, SQL Server, .NET, .NET CF, Windows Mobile and SQL CE.The book explain the landscpae and how various pieces fit together. The developer who want to learn all MS technologies can find it useful as example walkthrough them VS, SQL Server, .NET, ADO.NET, .NET CF, Windows Mobile, IIS Security technologies Ofcourse must for teams who are developing using SQL CE.

A good read

The sheer size of the book was pleasantly surprising considering the subject matter. I was expecting something a lot smaller. I agree with the other commenter that parts of it are a bit repetitive, but in the author's defense, it's a very fine line between being thorough and being repetitive and it's a lot better to err on the right side. I think he was clearly trying to make sure that newer developers got a firm basis in the technology even if it could be a little much. And, other than the first few chapters, there's nothing even approaching redundant. The strenght of the book is the depth of examples. Can I say that every single scenario I've ever encountered or can envision was covered? Probably not. Can I say that every scenario that you'd expect to encounter and many advanced ones that you run into rarely are covered - Absolutely. The code is there for all of it and the examples clearly state everything you need to understand about the example. Moreoever, I have not been through every samplem but I've been through a lot of them approaching just about all, and I have yet to find a problem with them. All in all I think the author did a phenomenal job and although it's a fairly dry (albeit critical) subject matter, the book is never boring. The coverage is always thorough and never leaves you wanting. He did as good of a job as can be done on this subject and his attention to detail is commendable. If you're interested in doing Sql Ce development, this book is a must have.