| List Price: | |
| Price: | $47.99 & eligible for FREE Super Saver Shipping on orders over $25. Details... |
| You Save: | $0.00(0.00%) |
| Binding: | Kindle Edition |
| EAN: | |
| Feature: | |
| Label: | Microsoft Press |
| Publisher: | Microsoft Press |
| Studio: | Microsoft Press |
| Tags: |
Editorial Reviews
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential.Discover how SQL Server works behind the scenes, including:What happens internally when SQL Server builds, expands, shrinks, and moves databasesHow to use event tracking—from triggers to the Extended Events EngineWhy the right indexes can drastically reduce your query execution timeHow to transcend normal row-size limits with new storage capabilitiesHow the Query Optimizer operatesMultiple techniques for troubleshooting problematic query plansWhen to force SQL Server to reuse a cached query plan—or create a new oneWhat SQL Server checks internally when running DBCCHow to choose among five isolation levels and two concurrency models when working with multiple concurrent users
Related Reviews
Still the true Bible on SQL Server internals
"Open heart surgery" to SQL 2008 engine
Before getting into more details I'll tell you if this book is for you or not: if you are a MS-SQL DBA get this book. If you are a programmer or you are looking for quick solutions to common problems, this book is not for you.
This one reminds me Edward Whalen's book: Microsoft
This one reminds me Edward Whalen's book: Microsoft
The best reference on internals. Period.
I started working with SQL Server in version 6.5, but it wasn't until several years later, when I had access to Kalen's "Inside SQL Server 2000" title, that I truly began to understand some of the core and fundamental concepts in how the engine works. She has continued this trend of providing books with more knowledge and examples than I can handle, but they have all helped me advance my understanding of SQL Server, and this in turn has paid huge dividends in several projects in my career. If you are going to get one SQL Server book to help you grasp the deep-down mechanics of SQL Server, this is the book you need.
If you're the person that runs backups and does nothing else with SQL Server, maybe, this book isn't for you. If you have any other level of responsibility with programming or maintaining databases within SQL Server, you absolutely have to have this book. There is no other resource as powerful as this one for understanding what is occurring within SQL Server. If you write queries or create indexes, you have to know how SQL Server is storing and retrieving your data, how it maintains it's memory, everything. It's all here in this book. What's more, the writing is so good, and clear, you can really use the book to learn. I can't sing the praises loud enough of long enough. This book is simply a requirement if you work with SQL Server.
Amazing in-depth overview of SQL2008 with some exposure of 2005 and also 2000.
You would never find anything of this grade anywhere else.
It's a must for anyone who dares calling themselves a worthy MS SQL specialist, be it DBA, SQL programmer, DWH specialist, or a BI developer dealing with RDB.
AAA
You would never find anything of this grade anywhere else.
It's a must for anyone who dares calling themselves a worthy MS SQL specialist, be it DBA, SQL programmer, DWH specialist, or a BI developer dealing with RDB.
AAA
A key resource to master SQL Server
This must be the first book you should read (page by page) if you are serious about being an expert on SQL Server administration and development. It will not teach you the basic DBA tasks but you are going to build a strong base to reach higher skill levels on tuning, troubleshooting, architecture, and creating efficient maintenance procedures.
Very well written; missing some pieces
I have read 4 of Kalen's books (SQL 7, 2000, 2005, and this one). They are all top notch technically. Very often, you will find information about inner workings of SQL architecture that you will find nowhere else. Furthermore, Microsoft itself has been known to pull questions from the contents of this book. Out of all the SQL books, this book generates the most difficult SQL interview questions.
The main issue with the previous books was the quality of the writing. I thought Kalen's writing was at times indecipherable. She could write tech with the finness of a sledgehammer. This book is different. This book is very well written and Kalen probably had a very good editor to review this book carefully.
The book deals mainly with the intermediate to advanced architectural aspects of MS SQL. This book, rightfully, is not for the beginners.
Ironically, Kalen left out some of her best works from her SQL 2005 book. For example, The SQL 2005 book had an excellent chapter on indexes. In this book, the indexes are not as aptly covered nor covered as in-depth.
Pros:
1)Contained an excellent chapter on SP recompile issues.
2)Probably the most technical of all technical books on SQL architecture.
3)Advanced knowledge you cannot find anywhere else.
4)This book is often the primary source of MS SQL interview questions for advanced level experrts.
Cons:
1)Where is the in-depth chapter on indexes? (SQL 2005 book had one).
2)Although much of SQL architecture is interesting, much of it is automated and there is no practical way to apply that understanding to anything useful.
I recommend this book especially to those who have never read Kalen's book. For the beginners, I would urge "SQL 2008 Unleashed" first before delving into the contents of this book.
The main issue with the previous books was the quality of the writing. I thought Kalen's writing was at times indecipherable. She could write tech with the finness of a sledgehammer. This book is different. This book is very well written and Kalen probably had a very good editor to review this book carefully.
The book deals mainly with the intermediate to advanced architectural aspects of MS SQL. This book, rightfully, is not for the beginners.
Ironically, Kalen left out some of her best works from her SQL 2005 book. For example, The SQL 2005 book had an excellent chapter on indexes. In this book, the indexes are not as aptly covered nor covered as in-depth.
Pros:
1)Contained an excellent chapter on SP recompile issues.
2)Probably the most technical of all technical books on SQL architecture.
3)Advanced knowledge you cannot find anywhere else.
4)This book is often the primary source of MS SQL interview questions for advanced level experrts.
Cons:
1)Where is the in-depth chapter on indexes? (SQL 2005 book had one).
2)Although much of SQL architecture is interesting, much of it is automated and there is no practical way to apply that understanding to anything useful.
I recommend this book especially to those who have never read Kalen's book. For the beginners, I would urge "SQL 2008 Unleashed" first before delving into the contents of this book.
SQL Server Internals provides detailed information on the way that SQL Server processes your queries and manages your data. It starts with an overview of the architecture of the SQL SERVER relational database system and then continues looking at aspects of query processing and data storage. My favorite chapter is the twelfth chapter it covers the details of reading query plans. I have met Ben Nevarez in many of his presentations; he is very knowledgeable when it comes to sql server. I just started reading about Adam Mechanic and I just started using his stored procedures for performance. Ben has worked with SQL Server since 6.5! I think that is cool. This book is for anyone who wants a deep understanding of what SQL Server does behind the scenes. I would expect that you have some experience with both SQL SERVER and with T-SQL, you don't have to be an expert. Enjoy!
Great Resource for Understanding SQL Server's Inner Workings
I have quite a few SQL Server 2008 references, but this is my favorite for better understanding the Query Optimizer, engine, indexing, and all sorts of tuning. Basically this is my first stop for questions beyond T-SQL development. I've been able to optimize performance far better than before. Highly recommended.
Kalen Delaney has written another thorough reference that is a joy to possess for any senior DBA!
Interesting, but some times for advanced sql server users and some times for beginners :)
This book is excellent. I found it at Barnes and Noble, read at the store, decided to buy one. I ordered one here, money was taken on March 6th, 2010, promised delivery by March 29th, 2010. It never arrived. It is a scam. In USA, city-to-city standard delivery will not take more than 3 days. I highly recommend this book but beware where you buy from. I am going to bn.com to buy another one.
Another great volume from Kalen
The addition of Paul Randal, Kimberly Tripp, and Adam Machanic really put this book over the top. Kalen does her normal bang up job on the details of SQL Server.
Share your thoughts with other customers
Create your own review
Create your own review
I've ready every copy of Inside SQL Server from 6.5 through to 2000. And I mean every page. I've read Inside Microsoft SQL Server 2005: The Storage Engine from cover-to-cover as well. Here's the thing... each edition gets better and better. Subtle little clarifications here. A paragraph of extra information there. And now with SQL Server 2008 Internals you have one of the best guides to the innner workings of SQL Server you can get your hands on.
I must reiterate: This is not a DBA's Guide. By that I mean that it is not filled with step-by-steps. Instead, it explains what's happening when you take those steps. For this reason, the book will not be for everyone; however, for those who are developing database applications based on SQL Server 2008, there's no better way to truly learn how the DB works and, therefore, optimize your application.
Another great book in the series...