The Rational Guide to SQL Server 2005 Express: Beta Preview (Rational Guides) [Illustrated] [Paperback]

Anthony T. Mann (Author)

Book Description

Series: Rational Guides | Publication Date: July 15, 2005

Microsoft SQL Server 2005 Express is the free edition of Microsoft’s flagship database product. The Express edition, which replaces MSDE, contains many of the features of other editions of SQL Server 2005, including the integration of Microsoft’s .NET technology into the SQL Server platform.

This book gives an early look into the Community Technology Preview (CTP) of SQL Server 2005 Express and presents the basics of using SQL Server 2005 Express and hosting SQL Server Common Language Runtime (CLR) objects in the database. With its friendly tutorial approach and numerous examples, this book will help the reader quickly learn how to create, configure, maintain and deploy SQL Server 2005 Express databases. It also covers advanced topics, such as security, distributed support, and XML support.

Technical accuracy is assured by Roger Wolter, Group Program Manager, SQL Server 2005 Express, Microsoft Corporation.

This book comes with the following bonus materials: * Extra Chapter - Advanced User Instances * Extra Chapter - Advanced User-Defined Types * Sample code shown in the book

Editorial Reviews

About the Author

Anthony T. Mann is the President/CEO of the Mann Publishing Group, which specializes in publishing business and technology titles, including this book (under the Rational Press imprint). He typically focuses on writing and teaching Microsoft-based technologies, including SQL Server, software development, and Microsoft Office. His 13 prior books include: ► The Attorney’s Guide to the Microsoft® Office System (Agility Press) ► The Paralegal’s Guide to the Microsoft® Office System (Agility Press) ► The Rational Guide To Microsoft® Virtual PC 2004 (Rational Press) ► The Rational Guide To SQL Server Reporting Services (Rational Press) ► .NET Web Services for Dummies (John Wiley & Sons) ► Microsoft SQL Server 2000 for Dummies (John Wiley & Sons) ► SharePoint Portal Server: A Beginner’s Guide (Osborne/McGraw-Hill) ► Microsoft SQL Server 7 for Dummies (John Wiley & Sons).

Product Details

• Paperback: 224 pages
• Publisher: Rational Press; illustrated edition edition (July 15, 2005)
• Language: English
• ISBN-10: 1932577165
• ISBN-13: 978-1932577167
• Product Dimensions: 8.8 x 6 x 0.6 inches
• Shipping Weight: 12.6 ounces (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #2,843,046 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars Gets you started with SQL Server 2005 Express Edition, August 17, 2005

By 

Louis B. Davidson "DrSQL" (Antioch, TN USA) - See all my reviews
(REAL NAME)   

This review is from: The Rational Guide to SQL Server 2005 Express: Beta Preview (Rational Guides) (Paperback)

The Express Edition of SQL Server 2005 contains much of the functionality of all editions of SQL Server 2005, with a few limitations (like a maximum of 1 processor!), and some enhanced functionality for letting you redistribute single user applications using it as the data storage. Best of all, it is absolutely free. The only confusion, where to get started? This book is that place.

This book is quite good for what it is, an introduction to many of the features of SQL Server 2005 with an emphasis on typical Express usage. There are 18 chapters in this fairly short book, covering everything from Administration to T-SQL to Triggers to using the ADO.net and Visual Studio 2005 with this product. If you have never used SQL Server, it is a great introduction to SQL Server, and a great jumping off point for reading Microsoft's Books Online for more information. Books Online is a fantastic resource, but it can be daunting for the newbie developer just trying to figure out how to store some data in a database.

This is not to say that the book is only for people who have limited knowledge of base SQL Server features, though that is clearly where the book shines. If you are seasoned with SQL Server 2005 already, but have limited Express experience you will still get a leg up on the additional features if you are planning on doing any development with Express. You will probably see a few of the core 2005 features that you haven't yet mastered (I know I did!)

As a warning, it is clearly marked a preview book, so be prepared that some material may change slightly over time. When you register your book (in my opinion a cool feature with Mann Publishing books) you get two additional chapters that will help complete the picture of how to use Express Edition in a single user mode.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Free is such a nice price., August 3, 2005

By 

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

This review is from: The Rational Guide to SQL Server 2005 Express: Beta Preview (Rational Guides) (Paperback)

SQL Server Express 2005 has changed the rules about databases. To be sure it is a more limited version than the full blown SQL Server versions but FREE is such a nice price. The real limitations of 'Express' are: supports only one CPU, supports only 1 GB of memory, supports a database of only 4 GB. To be sure, there are a few features that would be nice to have (such as notification services), but you have to consider just how much more that would be worth.

At this time only preliminary releases of the software are available, and that's what this book covers. If you were thinking of using MySQL or PostGre SQL on your next project, you might want to consider this instead.

This book is a fairly general overview of the Express system, how to install it, what it contains, things like that. Transact-SQL, the programming language for SQL Server is only given about eight pages. Transact SQL is a big time SQL. You'll want a big book on that alone. This book is inexpensive and gives you a good introduction to what Microsoft is doing. It'll well worth the few dollars it costs.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Not bad at all, October 21, 2005

By 

A. M. Mitchell (UK) - See all my reviews
(REAL NAME)   

This review is from: The Rational Guide to SQL Server 2005 Express: Beta Preview (Rational Guides) (Paperback)

Ok so it is not the most in depth look but at around 200 pages it was never going to be. It is a good , light taster of SQL Server Express. It took me 2 days to read and was worthwhile.