|
Inside SQL Server 2005: The Storage Engine (Solid Quality Learning)
|
| List Price: | £39.49 |
| Price: | £20.82 & eligible for FREE Super Saver Delivery on orders over £5. Details |
Availability: Usually dispatched within 24 hours
Dispatched from and sold by Amazon.co.uk
30 new or used available from £6.93
Average customer review:
Product Description
Take an in-depth look at the internals of the SQL Server Storage Engine—with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases. Discover how to: • Upgrade or migrate to SQL Server 2005 and choose configuration options • Control space allocation for databases and files manually or automatically •Manage transaction logs to maximize efficient restore operations and data consistency •Observe the internal structures of clustered and nonclustered indexes • Build and partition relational indexes and tables •Explore internal storage issues and compare fixed- and variable-length datatypes •Detect and correct index fragmentation •Implement and manage an appropriate concurrency model using locking or row versioning PLUS—Get code samples on the Web
Product Details
- Amazon Sales Rank: #188439 in Books
- Brand: Microsoft
- Published on: 2006-10-17
- Original language: English
- Number of items: 1
- Binding: Paperback
- 464 pages
Editorial Reviews
About the Author
Kalen Delaney has been working with SQL Server since 1987 when
she joined the Sybase Corporation in Berkeley, California. She worked for
Sybase in the technical support department and then for five years with the
training organization.
Kalen was an independent trainer and consultant from 1992 until she helped
form Solid Quality Learning in 2002, where she is the CFO and a Principal
Mentor.
As a consultant, she has worked with both Microsoft Corporation and Sybase
Corporations to develop courses and provide internal training for their
technical support staff.
Kalen has taught Microsoft Official Curriculum courses, as well as her own
independently developed courses, to clients around the world. In addition,
she has been writing regularly about SQL Server since 1995. She has written
two previous versions of INSIDE MICROSOFT SQL SERVER for Microsoft Press.
Kalen is also a contributing editor and columnist for SQL Server Magazine
and has been a SQL Server Most Valuable Professional since 1995.
Customer Reviews
Inside SQL Server: The Storage Engine
The only other book I have ever pre-ordered was Harry Potter! Although this may have limited appeal to 8 year olds, it has certainly reached and surpassed the level of anticipation I had.
Like it's predecessor this book is a must buy for any SQL Server DBA or Developer who requires more than a basic knowledge of the way things work (unfortunately there are no mammoths!).
A very well written book that is very readable, whether you delve into it for reference or read it from cover to cover. It contains information of the highest level that can only be garnered by Kalen's unique relationship with the developers who designed and wrote the code.
"Another great book by Kalen Delaney"
This is another great book by Kalen Delaney, and a worthy addition to the Inside Microsoft SQL Server Series.
The only reason this book doesn't get 5 stars is down to price. Whereas 2000 was crammed into a single Inside SQL Server volume, 2005 is now spread across four.. ..yes there is both extra detail and more content to cover, but having purchased this book and flicked through a friends copy of the other two currently published books, I can't help thinking two books would have been enough.. ..to purchase all four volumes of the 2005 installment of the series really does seem a bit too pricey..
Kalen Delaney triumphs again
Kalen Delaney triumphs again with another great book in the Inside SQL Server series (a series that no DBA or developer should be without) however this time the book has been spilt into 4 volumes in which she writes 2 of them. The other 2 are written by Itzik Ben-Gan.
"The Storage Engine" covers the Architecture, Configuration, Databases (and Databases files), Logging and Recovery, Tables, index internals (and management), locking and concurrency.
Just like her other books, it is clearly written, with good use of diagrams and code (and results, so you don't have to run all the code in the book to see what Kalen is talking about).
Room or no room, make space for this one on your shelf. A book not to be missed.
