{"id":82129,"date":"2012-08-30T20:27:13","date_gmt":"2012-08-30T20:27:13","guid":{"rendered":"https:\/\/www.webstaging.red-gate.com\/simple-talk\/?p=73431"},"modified":"2018-12-12T13:17:18","modified_gmt":"2018-12-12T13:17:18","slug":"sqlpass-db-design-precon-preview","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/sqlpass-db-design-precon-preview\/","title":{"rendered":"SQLPASS DB Design Precon Preview"},"content":{"rendered":"<p align=\"left\">It is just a few months left before SQLPASS and I am pushing to get my precon prepped for you. While it will be the second time I produce this on the year, I listened to the feedback and positive comments I have heard from potential attendees, so I am making a couple of big changes to fit what people really liked.<\/p>\n<ol>\n<li>\n<div align=\"left\">Lots more design time. We will do more designs in some form, as a group, teams, and individually, depending on the room and people in attendance. (Figure on a lot of databases centered around toys, theme parks, and other situations that are not exactly serious, since they provide a limited enough case where no one will get hung up on how their company does it, but broad enough to mimic real business cases. ) <\/div>\n<\/li>\n<li>\n<div align=\"left\">Pattern and code walkthroughs. I have a set of patterns (like uniqueness, hierarchies, and data driven design) that we can walk through and see how to translate from a database design to a physical implementation. It is based on the presentations I have done for the Data Architecture Virtual Chapter, and at Devlink this year, but we will not blast through any of it and will cover the code and designs in a deliberate pace and then consider designs where the pattern would make sense.<\/div>\n<\/li>\n<\/ol>\n<p align=\"left\">So if you want an interactive experience where you get a chance to think for yourself (at least part of the time) come join me on November 5 in Seattle, Washington, don&#8217;t think it, just do it: <a href=\"http:\/\/www.sqlpass.org\/summit\/2012\/Registration.aspx\">http:\/\/www.sqlpass.org\/summit\/2012\/Registration.aspx<\/a> (Not responsible if you actually get carried away and your employer won&#8217;t cover your expenses)<\/p>\n<p align=\"left\">As a bonus, I have at least 30 books I will give away to attendees, 15 electronic and 15 ex-tree versions to share with you. The precon is largely taken from the book, but it would take me more than 7 hours to just read the book to, and I am afraid that would not impress anyone at all.<\/p>\n<p align=\"left\">If you want to see more of my thoughts on the pre-con, check out the interview PASS did for the pre-con here, it is wordy, but if it wasn&#8217;t it would be mathematics: <a href=\"http:\/\/www.sqlpass.org\/summit\/2012\/Sessions\/PreConferenceSessions\/PreConPreviews\/LouisDavidson.aspx\">http:\/\/www.sqlpass.org\/summit\/2012\/Sessions\/PreConferenceSessions\/PreConPreviews\/LouisDavidson.aspx<\/a><\/p>\n<p align=\"left\">If you have any questions to ask me about what we will cover, or what you want to cover, or want to know I think I am funny, don&#8217;t hesitate to go ahead and register\u2026send me an email to <a href=\"http:\/\/mailto:drsql@hotmail.com\">drsql@hotmail.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It is just a few months left before SQLPASS and I am pushing to get my precon prepped for you. While it will be the second time I produce this on the year, I listened to the feedback and positive comments I have heard from potential attendees, so I am making a couple of big&#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-82129","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\/82129","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=82129"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82129\/revisions"}],"predecessor-version":[{"id":82310,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82129\/revisions\/82310"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=82129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=82129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=82129"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=82129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}