\u201cIt\u2019s book writing time in Tennessee!\u201d Ok, so I am actually in the Seattle airport waiting for my flight in around 3 hours, watching the TN \u2013 Mississippi game on my Slingbox, which was the inspiration for the title of the post (John Ward, the radio \u201cvoice of the Vols\u201d before Bob Kessling (who does a great job too) used to proclaim it to be \u201cFootball Time in Tennessee on the radio before every game.) Enough of that.<\/p>\n
My blogging has been very lean for a while now, mostly due to writing a book on the DMVs with Tim Ford, and a large part of that was that I just didn\u2019t love the DMV subject on the level I do design. Design is so exciting to me because it is a topic that is gets things going. Do it wrong, and you need DMVs, profiler, and a lot of work to keep things going. Performance tools, for the average dba, are about survival. And survival is a fun challenge occasionally, but it gets really tedious.<\/p>\n
This isn\u2019t to knock good survival skills\u2026 In fact, it is the unprepared person who often needs these skills the most. And it is the designer that doesn\u2019t understand the platform he is designing for that is most likely to get it wrong. I am not just talking about the academic living in his glass house telling you how you are wrong (I have no particular person in mind when saying that, I promise), but rather the more likely scenario is the functional architect\/coder designing a user interface\/object model (even a wonderful one) just tries to translate that directly into a relational database. They are wildly different things created for wildly different reasons.<\/p>\n
So this impedance mismatch between the two technologies opens a chasm between the two camps that you could drive an aircraft carrier through. And it needn\u2019t be this way. Over the years, the ORM technologies have gotten better and better, and to build a reasonable system with them isn\u2019t rocket science. Unfortunately, the problem is that we can\u2019t get along, and when the dba tries to articulate why the implementation isn\u2019t particularly excellent, they can\u2019t do it in a convincing manner. The book I produce is for especially for you. Even if you never get a chance to be the architect of the database (the book is definitely for aspiring architects as well) knowing what a database should look like and WHY it should be that way may help you convince the architect that there is a better way. And I know from talking to the people who use correctly and build at least one of the ORMs out there that it is definitely possible to build a proper ORM-Relational mapping that will leverage both platforms well, if not perfectly.<\/p>\n
Then, your DMVs, profiler, performance monitoring tools, etc can be relegated to real emergencies, generally happy emergencies like when your website has near denial of service levels of activity because your company\u2019s business shoots to the moon overnight instead of daily trying to let one of your users attempt to do day to day business without an extreme amount of contention, looping, cursoring, etc.<\/p>\n
Over the next 12 months (+\/- N months, of course) I will be rewriting much of the book to make it more natural to use, more valuable to people who have previous editions, and more valuable to people who want a higher page count because they own a parakeet and want to line the cage with only the best technical manuals. So why should you care? Well, I am going to be asking for your help in a few ways.<\/p>\n
1. I will be posting the outline\/table of contents for opinions over the rest of 2010<\/p>\n
2. I will be posting bits and pieces of the book that I am \u201cuncomfortable\u201d with to see what people think. <\/p>\n
3. I hope to get a reasonable number of people to review the book ahead of printing <\/p>\n
So here I go again\u2026only this time it\u2019s personal\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"
\u201cIt\u2019s book writing time in Tennessee!\u201d Ok, so I am actually in the Seattle airport waiting for my flight in around 3 hours, watching the TN \u2013 Mississippi game on my Slingbox, which was the inspiration for the title of the post (John Ward, the radio \u201cvoice of the Vols\u201d before Bob Kessling (who does……<\/p>\n","protected":false},"author":56085,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"coauthors":[19684],"class_list":["post-82089","post","type-post","status-publish","format-standard","hentry","category-blogs"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/56085"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=82089"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82089\/revisions"}],"predecessor-version":[{"id":82331,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82089\/revisions\/82331"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=82089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=82089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=82089"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=82089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}