{"id":82116,"date":"2011-09-28T23:28:52","date_gmt":"2011-09-28T23:28:52","guid":{"rendered":"https:\/\/www.webstaging.red-gate.com\/simple-talk\/?p=73392"},"modified":"2018-12-12T13:21:01","modified_gmt":"2018-12-12T13:21:01","slug":"chapters-9-10-11-and-12","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/chapters-9-10-11-and-12\/","title":{"rendered":"Chapters 9, 10, 11, and 12"},"content":{"rendered":"<p>So I have been a bit remiss on my blogging the book duties. The fact is, the first 8 chapters were fairly heavy rewrites and reworkings, and even a good amount of new material.&#160; But when doing a new version of a book that has already existed, you do need to reuse a good deal of the material from previous version.&#160; Chapters 9, 10, and 11 are these chapters for this edition of the book.&#160; The chapters are:<\/p>\n<ul>\n<li>Chapter 9 &#8211; Database Security and Security Patterns \u2013 The biggest change to this chapter was the differences that Contained Database bring to the picture.      <\/li>\n<li>Chapter 10 &#8211; Table Structures and Indexing \u2013 Minimal changes to this chapter, mostly concerning some of the changes to compression. Since columnstore indexes aren\u2019t really pertinent to OLTP databases, I didn\u2019t do anything with them. An example of a columnstore index will appear in Chapter 12     <\/li>\n<li>Chapter 11 &#8211; Coding for Concurrency \u2013 Again, not a tremendous difference for Denali, so just a bit of touch up.<\/li>\n<\/ul>\n<p>Then comes Chapter 12. Back in the original version of the book, I had a reporting chapter, and I wasn\u2019t amazingly pleased with it. So in 2005 I cut it, and decided to leave it out.&#160; But it always felt like a bit of a hole in the book, having to say to \u201cdon\u2019t denormalize and do reporting in your OLTP database, build a data warehouse, which I won\u2019t talk about\u201d.&#160; Since those early years, I have learned a lot about data warehousing, attended a Kimball class on on dimensional modeling, and have designed our corporate data warehouse (with the requisite original \u201cfailure\u201d before training, naturally.)&#160; But I had to face facts, I was not the right person to write even a chapter on reporting\/dimensional modeling.<\/p>\n<p>I had made a decision to not have cowriters for this version, a bit for space reasons (I loved having Kevin Kline as a cowriter for the past two versions, but I just didn\u2019t have space last time, and we made it a download), a bit for coordination reasons (I had a devil of a time with a spatial section for the last book), and a bit for selfish reasons (you can figure that out for your own self.)&#160; But a few months ago, as the outline gelled, I decided I just needed something about dimensional modeling\u2026<\/p>\n<p>So I reached out to a particular writer named Jessica Moss (<a href=\"http:\/\/twitter.com\/#!\/jessicammoss\" target=\"_blank\">@jessicammoss<\/a>) that I have known for a while, and had recently worked with on my data warehouse project as a mentor to help our team grow quite a bit in our ETL skills and to help mold our design.&#160; So I asked her if she wanted to write a chapter on dimensional modeling, and she accepted.&#160; I have seen her early version of the chapter, and I am very excited to add it as chapter 12. <\/p>\n<p>Only one more chapter to write, number 13, which I will blog about in the next day or two once I get my ideas down on \u201cpaper\u201d (and if assuming I don\u2019t decide to split the chapter, will annoy my editor, so probably not!)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So I have been a bit remiss on my blogging the book duties. The fact is, the first 8 chapters were fairly heavy rewrites and reworkings, and even a good amount of new material.&#160; But when doing a new version of a book that has already existed, you do need to reuse a good deal&#8230;&hellip;<\/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-82116","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\/82116","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=82116"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82116\/revisions"}],"predecessor-version":[{"id":82324,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82116\/revisions\/82324"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=82116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=82116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=82116"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=82116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}