For me, this was a good book to reinforce what I knew, as well as to try to pick up some key insights that might have escaped me. It covered the majorFor me, this was a good book to reinforce what I knew, as well as to try to pick up some key insights that might have escaped me. It covered the majority of database design concepts which I have picked up over the last few years of practical experience in one volume. I would recommend this as a really good place to start out if you are just learning to deal with database design, or if you are starting out with system application design and need to understand how it integrates with the underlying databases....more
SQL Server 2008 Query Performance Tuning Distilled approaches the task of maintaining and tuning an SQL Server in a methodical fashion. The book mightSQL Server 2008 Query Performance Tuning Distilled approaches the task of maintaining and tuning an SQL Server in a methodical fashion. The book might take a little while to get through, but it isn't that it is a hard read, it is just that there is a lot of information. The book will best be read by a DBA who has at least some working knowledge of how to interact with the SQL Server (i.e. this might not be the best book for a true beginner).
The following is a quick overview of what the book has to offer:
Chapter 01 - SQL Query Performance Tuning A general overview of the iterative performance tuning methodology. Also gives a description of the coming chapters and the information to which each will delve.
Chapter 02 - System Performance Analysis In my mind, the best chapter in the book. This gives us a comprehensive guide for using the Perfmon tool as well as the system DMVs to understand how your system is performing.
Chapter 03 - SQL Query Performance Analysis A quick look at profiler traces, execution plans and some of the statistics options.
Chapter 04 - Index Analysis This chapter presents a fairly thorough look at SQL Server indexes, their benefits, their costs and how you can use them effectively.
Chapter 05 - Database Engine Tuning Advisor A short chapter dedicated to using the Database Engine Tuning Advisor (DTA or DETA).
Chapter 06 - Bookmark Lookup Analysis Another fairly short chapter discussing the Bookmark Lookup Operation, and ways in which they can be avoided.
Chapter 07 - Statistics Analysis Discusses how SQL Server keeps track of statistics, how they are used, and the few options you have to keeping up with them.
Chapter 08 - Fragmentation Analysis A look at index fragmentation, what causes it, some options of dealing with it and how you can maintain objects affected by it.
Chapter 09 - Execution Plan Cache Analysis This chapter investigates the Execution Plan Cache, the costs associated with storing the plans in the cache, and some tips on how you can make the cache reusable. This chapter may have me rethinking how we currently execute the majority of our database loads.
Chapter 10 - Stored Procedure Recompilations This chapter investigates the intentional and unintentional ways for recompiling stored procedures, the costs associated with these recompilations and tips on how to avoid the same.
Chapter 11 - Query Design Analysis This chapter has a few general tips and tricks for working with query design.
Chapter 12 - Blocking Analysis This chapter goes into the details for the SQL Engines locking mechanism, the isolation settings, the effects of each and how they can effect blocking within the database engine.
Chapter 13 - Deadlock Analysis A short chapter on deadlocks, some quick tips for how you might avoid them, and information on how you can capture information that will enable you to triage the errors after they occur.
Chapter 14 - Cursor Cost Analysis A chapter on the different types of cursors, the various pros and cons of each and some tips for defining them to be as efficient as possible. As always, lots of warnings on avoiding them entirely if at all possible.
Chapter 15 - Database Workload Optimization A chapter on the iterative nature of capturing the overall workload of a server, analyzing it for problem queries, and then iteratively tuning them. This seems like the "Bringing it all together" type of chapter and does a good job of showing where each topic you have learned about will come in handy for helping to improve the overall health of the system.
Chapter 16 - SQL Server Optimization Checklist This is almost like a summary chapter, in the guise of a quick checklist. It reviews the rest of the larger subjects which the book has covered as a reminder that you can quickly flip through.
This book was an easy read on a subject that can be relatively intimidating for a developer with no experience in the area. It is a great introductionThis book was an easy read on a subject that can be relatively intimidating for a developer with no experience in the area. It is a great introduction to learning how to read SQL Server Execution Plans. There are lots of good examples and screen shots describing how the server is interpreting the commands being executed.
However, one should note that the book is NOT about how the plans will help you to improve your queries. Instead, knowing how to read through the various execution plans will help the reader to understand where problems might exist....more
This book took me a good six weeks to finish as it had so much information to consume that I would often find myself reading for ten or twenty pages aThis book took me a good six weeks to finish as it had so much information to consume that I would often find myself reading for ten or twenty pages and then having to take a break. However, I feel like reading it cover to cover once, in combination with some of the MCM Prep videos, has given me a very strong foundation of how the engine works. I'm sure that I will continue to look back at some of the chapters over the next several years as I come upon problems with T-SQL.
This book is highly recommended, although not for the faint of heart, and definitely not an entry level text....more
Fast and easy read. Not quite up to the standard of the other Sookie books, but then, I rarely ever like short stories as much as novels. Worth the reFast and easy read. Not quite up to the standard of the other Sookie books, but then, I rarely ever like short stories as much as novels. Worth the read if you can get a copy cheap, otherwise, it is probably worth it to wait for this one in paperback....more
I used this to get through the Database Development Certification in July. I certainly wouldn't say that it is all that you need to pass, but it coverI used this to get through the Database Development Certification in July. I certainly wouldn't say that it is all that you need to pass, but it covers the majority of the information. The questions on the practice test helped to narrow down areas which I needed to focus on more, which helped out immensely.
Of note was the fact that there were a few errors in the practice questions that I saw. However, it was obvious what they were and what the intent of the question was, particularly when reading through the explanations. ...more
This book was a breeze to read (I got through it in a day). I really enjoyed the exposition on what makes humans human throughout the story. I especiaThis book was a breeze to read (I got through it in a day). I really enjoyed the exposition on what makes humans human throughout the story. I especially enjoyed the internalization of what it is that made Deckard tick, as opposed to that of Iran, Isidore, or Resch, let alone that of Rachael or the others.
At the end, the reader is left with a number of questions which lead to further debate about what is real, and, more importantly, what does real, really mean?...more
The book was OK. It seems like a lot less happens in this volume than previous books in the series. There are some "Revelations" that don't really comThe book was OK. It seems like a lot less happens in this volume than previous books in the series. There are some "Revelations" that don't really come off too well as they were somewhat expected.
All in all, a fun read. But not one I would recommend unless if you are already a fan of the series....more
**spoiler alert** This one for me was an incredibly quick and easy read. It was fun, and not nearly as dense as most of Wolfe's other works. It dealt**spoiler alert** This one for me was an incredibly quick and easy read. It was fun, and not nearly as dense as most of Wolfe's other works. It dealt with a story written by Holly Hollander, a younger woman who is caught up in some strange events when her mother brings home a strange box labelled "Pandora" which she auctions off the right to open and keep the contents during a fund raiser. As one would guess, opening up pandora's box is not exactly the wisest decision and events lead towards multiple deaths, including at least one murder and the eventual revelation of 'who done it'....more
Just finished up with The Devil in a Forest by Gene Wolfe. The story revolves around Mark, a young apprentice weaver, and the small village that he liJust finished up with The Devil in a Forest by Gene Wolfe. The story revolves around Mark, a young apprentice weaver, and the small village that he lives in as they go through the trials and tribulations of dealing with a highwayman, an elderly lady with an evil heart who may or may not be a witch and the soldiers who are sent in to deal with the highwayman. Wolfe is able to capture the persona of Mark quite well as he struggles to realize that the adults around him are not all powerful or perfect and that even at his young age, he may be more equipped to deal with some of the stressful situations then they are.
It doesn't appear that this is one of Wolfe's customary stories. There were no stories within stories and it didn't appear that the reader needed to be paying extreme attention to every detail to gather everything that is going on, both on screen and off screen. Also, Mark appeared to be an at least mostly reliable narrator. All in all a quick read that was enjoyable, but definitely not my favorite of Wolfe's novels....more
This is a campy fictionalization of a walking tour guide of the shambles, a neighborhood in Chicago. In it there are a number of humorous horror elemeThis is a campy fictionalization of a walking tour guide of the shambles, a neighborhood in Chicago. In it there are a number of humorous horror elements detailing the various locales and some of the denizens of the area. One of my favorites was the Rent a Rifle at the top of the largest building where you would attempt to shoot sight seers of the sears building. Overall, I would probably say that this is one that most people could skip... but as it was written by two of my favorite authors it has been on my too read list for quite some time....more
**spoiler alert** Confessions of an Economic Hitman is the story of the author John Perkins; this story describes his part in, and observations of, a**spoiler alert** Confessions of an Economic Hitman is the story of the author John Perkins; this story describes his part in, and observations of, a series of events which take place over the last several decades leading to the impoverishment of various countries through the use of corporate policies including underhanded manipulation, bribery, improper statistics, etc to undermine those countries economies to such an extent that they would be beholden to their creditors and various corporations.
The general formula would be to take a country which is rich in some resource that the U.S. deems to be valuable, but which has not been modernized and has little infrastructure, and conduct research into how much money would be loaned to these countries based on an economic forecast conducted by companies with a vested interest in the result. This research would always lean in a direction such that the country would receive a vast amount of money more than they could afford in loans which would be used to build out infrastructure in the country. Of course, the infrastructure would be built, maintained and designed by the U.S. companies which were in league with the economic forecasters and banks. In turn, the loans would be so large that the countries, after the initial investment of the loaned money used to build out the new infrastructure, would not be able to pay them off. The countries which received the loans would instead be pressured into giving out resource rights, favors, political asylum, etc.
Throughout the account, the author at once tries to describe his feelings of remorse for taking part in these actions as well as describing how he, again and again continued to proliferate the agendas set before him. It is described how wars were deemed to be outdated during and after the cold war, so, instead of going to "war" we would instead conduct a sort of economic war on the countries whose resources would help determine the course of the future.
I must say that my reaction to this book is not exactly what I would have thought. Although I enjoyed it, I don't know how heartily I would recommend it. The author's "confessions" seem a bit misplaced for someone who has spent the majority of his life as part of his own story of greed and corruption. It seems a bit to, I don't know, "to little to late" maybe? You can't spend the majority of a book telling me how evil you and your cohorts were, about how you had pangs of guilt for years on end, how you grew to hate yourself, and then try to convince me that you are really a good guy now. I am glad that, at least according to his own tale, John Perkins appears to have turned over a new leaf; That he now spends most of his time with non-profits trying to right some of the wrongs which he helped to create. But I still can't help but feel that this too (the book) is being used to help him profit off of a career which, in the very best of lights, should be despised.
One thing that I must say is that this book helps to get the creative juices flowing, thinking about class struggles, corruption, corporate greed, and sanctity of culture. For that, I must certainly recommend it. But, before giving that recommendation, unless if Mr. Perkins and his publishers, distributors, etc are giving the proceeds to a good charity I don't know that I can honestly recommend anyone else to buy this book for fear that it is just another way to make money for a man who seems to have been driven by nothing more throughout a long career. ...more
I listened to the abridged version of this book. It seemed a bit disjointed, but fairly powerful. It was narrated by both the author and Matt Damon. WI listened to the abridged version of this book. It seemed a bit disjointed, but fairly powerful. It was narrated by both the author and Matt Damon. Worth the listen... comes in at about 9 hours or so....more
This is one I am going to listen to on the commute between Tallahassee and Gainesville on the weekends... So far it's pretty good.
This seems to be foThis is one I am going to listen to on the commute between Tallahassee and Gainesville on the weekends... So far it's pretty good.
This seems to be following three different threads throughout the book (at least so far). The first is based on around a girl who was the lead singer in a band, but is now a writer working for a magazine which hasn't actually published anything yet investigating some strange new style of artwork involving geo-coding events and VR. The second is based on some sort of crime family of cuban descent with some russian heritage. The third is about a drug addict who has been forced to work for someone who he knows little about, but is very interested in the family above......more