Mastering Microsoft SQL Server 2005 (Mastering)
| |||||||||||||||||||||||||||||
|
| |||||||||||||||||||||||||||||
| Sort customer reviews by: | |||||||||||||||||||||||||||||
|
Show All Reviews on Page
Hide All Reviews on Page
| |||||||||||||||||||||||||||||
| Mastering Microsoft SQL Server 2005 (Mastering) | |||||||||||||||||||||||||||||
|
A Comprehensive Guide to Microsoft's New Express Edition of its Bestselling Database Server
Microsoft's SQL Server 2005 Express Edition is the perfect fit if you're a small business owner, trainer, or student who doesn't need all the bells and whistles of the full version of SQL Server 2005. In this comprehensive guide written by two SQL Server experts, you'll find step-by-step explanations and simplified management tools for using SQL Server Express in smaller-scale but still mission-critical situations. With a focus on practical tasks, the book thoroughly covers both database administration and development, smoothly moving you from beginner to advanced subjects. Coverage Includes * Understanding basic database concepts * Getting to know database types: file server, client server, relational and more * Learning Structured Query Language (SQL) and SQL Server's Transact-SQL * Creating efficient and useful databases * Writing queries and stored procedures to explore your data * Automating the administration of your databases * Developing database applications with Visual Basic(r) Express * Using SQL Server Management Studio Express * Sharing data between multiple servers * Monitoring and optimizing SQL Server Express Featured on CD CD includes Microsoft(r) SQL Server Express and Visual Basic(r) Express! Leverage the Experience of Experts through Real-World Examples Increase Your Own Productivity with an Entire Chapter on Troubleshootng Discover Practical Solutions to a Database Administrator's Needs Reduce Complexity and Build Simple Data-Driven Applications |
|||||||||||||||||||||||||||||
| Reader Reviews 1 - 6 of 6 | |||||||||||||||||||||||||||||
| Review Date |
Review Rating(5 High) |
Review Helpful to: |
Customer Review | Reviewer Info |
Permanent Link |
||||||||||||||||||||||||
| Reader Reviews Below Sorted by Newest First | |||||||||||||||||||||||||||||
| 06-04-08 | 5 | (NA) |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I have been creating applications that use Access for the last few years, so it has been awhile since I used SQL Server.
With this book I got up to speed on client/server databases, permissions, stored procedures, triggers, T-SQL. It should be the start for anyone who is interested in this "free!" new SQL Server. I found it very helpful, well written, succinct. (Review Data Last Updated: 2008-08-26 06:41:23 EST)
|
|||||||||||||||||||||||||||||
| 02-18-08 | 5 | 1\1 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Microsoft realeased a free version of SQL Server to compete with mySQL and it's actually quite excellent, especially given its price tag. This book makes the book claim to have you 'mastering' SQL Server, but of course no single book could do that. Instead, it provides a very comprehensive tour-de-force of all the features, bells and whistles, and relies on you - dear, Internet-connected reader - to research areas of particular interest to you.
The biggest flaw is that there's not enough information to get you up and running in the first place. Literally, the installation instructions for SQL Server Express are esoteric, and there's a couple of missing pieces of information, without which you're going nowhere. But a little digging around on the Net will have you running fairly quickly. Overall, a great little book for the price. (Review Data Last Updated: 2008-06-04 06:00:59 EST)
|
|||||||||||||||||||||||||||||
| 09-12-07 | 5 | 16\16 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
.
Microsoft has developed a FREE, yes that is FREE, SQL application that is actually rather good. This book will get you up and running on SQL; database concepts and design; trouble shooting your databases as well as introducing you to Visual Basic Express...another FREE app from Microsoft It isn't as robust as SQL Server, but is far better than Access. (Review Data Last Updated: 2008-02-19 13:13:59 EST)
|
|||||||||||||||||||||||||||||
| 08-14-07 | 3 | (NA) |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I have bought this book for my teaching purposes targeting a "new starter" group. Introductory chapters are good. It has abundant representative pictures. But as the topics progres the book becomes having a little problematic. If you think to buy this book as a self study guide, it is maybe better to look for another one.
On the other hand, SQL Server Express Edition does not have so much book-style resources. This may force the reader to buy this book (as in my case!) But as a last opinion, this book is not a "must have book" (Review Data Last Updated: 2007-09-13 10:50:12 EST)
|
|||||||||||||||||||||||||||||
| 06-14-07 | 5 | 3\3 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
I give this book five stars not because the entire book is great, but because chances are there will be a few parts that 'serve' you well - which is most likely why you buy this book. One or two of these gems (such as adding Encryption to a connection string to automatically encrypt all data moving from sql server onto the network) will be worth the price of the book many times.
The intro on things like normalizing is weak and chances are you will not learn anything here (if you do not know the basics about normalizing a database schema, then chances are some tutorials on the internet will help you better). Sections on backups, locks, internal workings of sql server, smo objects for custom management apps, logs, etc are all well written and helpful. A few performance metrics for various typical approaches would have been appreciated, the type of things you have to dig through white papers for. (Review Data Last Updated: 2007-08-14 23:14:13 EST)
|
|||||||||||||||||||||||||||||
| 01-11-07 | 4 | 10\11 |
| Reviewer | Permalink | ||||||||||||||||||||||||
|
Before I had got this book I had been reading tutorials on the internet. I wanted a single source of information so I started looking for a book. I'm just starting to get into SQL Server and I'm going to convert an Access DB into SQL Server 2005 Express.
My experience with Access was learn as you go because I needed to get the app finished asap. By the time I was done I wanted to redo the whole app again using the knowledge I'd gained through the whole process. Now I do not have time constraints and like I said I'm going to redo the Access DB in SQL Server 2005 Express, but I didn't want to make the mistake of jumping in right away and learning as I go. So I decided to read up as much as I could before starting. After reading this book I feel I have a solid understanding of most the aspects of SQL Server 2005 Express. What I wanted most was to learn about backups and security which this book does a good job of covering. I think the strongest attribute of the book is it reads easy and fast, but has good information. The chapters are kept short so it is easy to finish each in one sitting. I gave it four stars because to me it is a comprehensive book, but after reading it I don't believe I have "mastered" SQL Server 2005 Express. I don't think anyone could with one book. I think it gives the reader a good base knowledge on most aspects but to master them you'd have to research further. (Review Data Last Updated: 2007-06-15 10:13:11 EST)
|
|||||||||||||||||||||||||||||
| Reader Reviews 1 - 6 of 6 | |||||||||||||||||||||||||||||
| All Books | Arts | Biography | Click Here For An A-Z Index Of All 213 Best-Seller Subjects | Business | Children's | Comics | ||||||
| Computers | Cooking | Engineering | Entertainment | Health | History | Home | Horror | Humor | Law | Fiction | Medicine | Mystery |
| Nonfiction | Outdoors | Parenting | Professional | Reference | Religion | Romance | Science | Sci-Fi | Sports | Teens | Travel | |
