The Book
Information
Need to get your arms around Microsoft SQL Server 2005 fast, without getting buried in the details? Need to make fundamental decisions about deploying, using, or administering Microsoft's latest enterprise database?
Need to understand what's new in SQL Server 2005, and how it fits with your existing IT and business infrastructure? SQL Server 2005 Distilled delivers the answers you needquickly, clearly, and objectively.
Former SQL Server team member Eric L. Brown offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more. Brown draws on his extensive experience consulting with enterprise users, outlining realistic usage scenarios that leverage SQL Server 2005's strengths and minimize its limitations. Coverage includes
Architectural overview: how SQL Server 2005's features work together and what it means to you
Security management, policies, and permissions: gaining tighter control over your data
SQL Server Management Studio: Microsoft's new, unified tool suite for authoring, management, and operations
Availability enhancements: online restoration, improved replication, shorter maintenance/recovery windows, and more
Scalability improvements, including a practical explanation of SQL Server 2005's complex table partitioning feature
Data access enhancements, from ADO.NET 2.0 to XML
SQL Server 2005's built-in .NET CLR: how to use it, when to use it, and when to stay with T-SQL
Business Intelligence Development Studio: leveraging major improvements in reporting and analytics
Visual Studio integration: improving efficiency throughout the coding and debugging process
Simple code examples demonstrating SQL Server 2005's most significant new features
Created by: navyzhu on May 27th 2006, 15:40.
Editing privileges: Any pro user.
How to learn? Read once.
Being studied by: pramod kumar, derchrissi, erik001, i_chaitu_foru, katelibby and 27 other persons.
Rating: 
Autor: Eric L. Brown
ISBN: 0321349792
Publication date: 2006-03-20
Edition: Paperback
Publisher: Addison-Wesley Professional
Number of Pages: 336
Price: From $4.94 at Amazon (on February 19th 2007, 04:25)
Reviews
2 tiers instead of 3 tiers?!
Read
Microsoft continually improves its SQL Server, and Brown shows how far it has come in the 2005 version. There has been a big push to make SQL Server 2005 industrial strength. So now it can do 1 million transactions per minute, up from 20 000 per minute in 2000. A remarkable gain that suggests Microsoft is making a strong drive into the bread and butter of DB2 and Oracle's customer bases. And, yes, the book comes out in 2006, while the Server is labelled 2005. But it's a very complex product [as the book makes clear], so some slippage was inevitable.
Other features covered by Brown include the High Availability, for businesses that need 365/24/7 coverage, or at least as close to this as possible.
A very interesting discussion takes place early in the text, where Brown suggests that more business logic needs to be embedded into the database layer, through such means as stored procedures, perhaps. In contradiction to the heavily promoted 3 tier arrangement, of database layer, application layer and presentation layer. Where the application layer holds the business logic. The idea is to separate the latter from depending on a particular choice of database. Brown disagrees. Saying that the performance gains often necessitate pushing the business logic into the database.
Maybe. Keep in mind however that every database vendor is likely to say this. Since a major [intended] effect is to lock the customer into that database. With this caveat, Brown might ultimately be correct. For the greatest performance, you may well have to do as the text suggests. Though whether you choose SQL Server or an alternative database is another matter.
Good overview
Read
This book is well written. I feel that it covers material that all managers need to know about SQL Server 2005. Programmers will be unhappy with it due to the lack of "how to" details, but that's not the purpose of this book. The size of the book is ideal for an airplane read.
Comments
No comments yet.
Write comment
Only signed in users may write comments. Sign in now!