{"id":587,"date":"2013-10-21T12:49:44","date_gmt":"2013-10-21T17:49:44","guid":{"rendered":"http:\/\/www.cognitiveinfo.com\/?p=587"},"modified":"2013-10-21T12:49:44","modified_gmt":"2013-10-21T17:49:44","slug":"pass-summit13","status":"publish","type":"post","link":"https:\/\/cognitiveinfo.com\/?p=587","title":{"rendered":"PASS Summit 2013 &#8211; A First-timer&#8217;s Experience"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit2013-Registration.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium wp-image-598\" alt=\"Summit2013 Registration\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit2013-Registration-300x168.jpg\" width=\"300\" height=\"168\" \/><\/a><\/p>\n<p>First let me say I came to Summit with a few plans, but no set expectations.\u00a0 After SQLkaraoke with Jason Horner in KC,MO, I learned to just show up to see what happens. I really came to learn from people who are better at their craft than I and catch up with friends I\u2019ve made through SQL Saturdays.<\/p>\n<p>There were only about four sessions on my must-see list.\u00a0 My plans did include visits to the Microsoft Certification and testing area.\u00a0\u00a0 Overall, I enjoyed the few sessions I attended, really loved the SQLfamily, learned from Itzik Ben Gan, met Dave Pinal, passed one test and failed another (but still learned from it).\u00a0 I\u2019ll be back.<\/p>\n<h2>Preconference &#8211; Monday<\/h2>\n<ul>\n<li>Monday\u2019s \u2018Practical TSQL\u2019 session with Itzik Ben Gan gave me brain cramps within the first two hours.\u00a0 I left to take a call and when I returned he was navigating indexes in binary.\u00a0 Obviously his idea of practical is much more involved than mine. It will take me some time to read his material and try the design techniques he taught.\u00a0 Still, I learned some new ways to think about solving problems in SQL.<\/li>\n<li>Itzik and Joe Celko are the only speakers that I have seen pull out the SQL standard to explain the concepts they teach.\u00a0 My goal for speaking next year is to pull out some kind of standard, though it may be the international <a href=\"http:\/\/www.iso.org\/iso\/products\/standards\/catalogue_ics_browse.htm?ICS1=67&amp;ICS2=190&amp;\" target=\"_blank\" rel=\"noopener\">chocolate standards<\/a>.<\/li>\n<\/ul>\n<h2>Tuesday<\/h2>\n<ul>\n<li>\n<h3>SQL Saturday Roundtable<\/h3>\n<\/li>\n<li>Good feedback from the groups hosting SQL Saturdays and good info from the PASS members about coming changes to the website.<\/li>\n<li>\n<h2>First-Timers Welcome Party.<\/h2>\n<\/li>\n<li>Beanie hats! Ok, maybe you need a visual.\n<p><figure id=\"attachment_595\" aria-describedby=\"caption-attachment-595\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"size-medium wp-image-595\" alt=\"Summit First Timer Beanies\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit_Beanies-300x168.jpg\" width=\"300\" height=\"168\" \/><figcaption id=\"caption-attachment-595\" class=\"wp-caption-text\">Allen Smith and Matt Brimer at PASS Summit 2013 First Timer welcome party.<\/figcaption><\/figure><\/li>\n<li>\n<h2>Cisco Welcome Party<\/h2>\n<\/li>\n<li>They really needed a better PA speaker system for the Quiz Bowl. It looked entertaining, but I have no idea what was said up there. But thank you Cisco.<\/li>\n<li>\n<h2>Linchpin Party<\/h2>\n<\/li>\n<li>I enjoyed bowling with Johan and Gerb.\u00a0 Best of all we got to meet <a href=\"http:\/\/www.pinaldave.com\/\">Pinal Dave<\/a>.\u00a0 Props to him for all the times his <a href=\"http:\/\/blog.sqlauthority.com\">blog<\/a> has helped me out.\u00a0 Photo time. <img decoding=\"async\" class=\"aligncenter size-medium wp-image-592\" alt=\"Summit_Pinal\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit_Pinal-e1382373223586-300x196.jpg\" width=\"300\" height=\"196\" \/><\/li>\n<\/ul>\n<h2>Wednesday<\/h2>\n<ul>\n<li>Started early with a few dozen others for SQLRun and SQLwalk, organized by <a href=\"http:\/\/www.brentozar.com\/team\/jes-borland\/\">Jes Borland<\/a>.\u00a0 <a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit-SQLWalk.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-596\" alt=\"Summit SQLWalk 2013\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit-SQLWalk-300x168.jpg\" width=\"300\" height=\"168\" \/><\/a><\/li>\n<li>\n<h3>Opening session.<\/h3>\n<\/li>\n<li>It was great to see our own community mentor Ryan Adams receive PASS recognition for &#8216;Passion Award, Honorable Mention&#8217;.<\/li>\n<li>Great news for those of us ready to try out SQL 2014 CTP1.\u00a0\u00a0 People gave applause for Zoomit, but not for in-memory improvements or updatable Columnstore Indexes.\u00a0 Ok&#8230;<\/li>\n<li>The first BI Session and other sessions I attended were very overcrowded.\u00a0 I did not get turned away because I was there very early for each session, but many did get turned away.\u00a0\u00a0 Also, the overlapping schedule was confusing so sometimes had to skip the end of one session to make it to another.<\/li>\n<li>\n<h3>Certification Central<\/h3>\n<\/li>\n<li>This was NOT well publicized in the schedule or registration info, but once I found it in the Westin they had some good Exam Prep classes. This is an amazing resource for first-timers and old-timers as well. I\u2019ve spent over a decade doing BI in the IBM Cognos world where SQL is just another data source. The past three years have been a steep learning curve on a quickly developing Microsoft BI platform. I really want to thank Telmo Sampaio, Chris Randall, Michael Corkery and Russ Loski for sharing their knowledge and spending their days at Cert Central.<\/li>\n<li>Skipped out on SQLKaraoke to study. As a BI Developer studying for the MCSE path, I focused my study time on my weak areas, namely installation and administration. That is usually someone else\u2019s job.<\/li>\n<\/ul>\n<h2>Thursday<\/h2>\n<ul>\n<li>I took two tests this week and passed one. On exam <a href=\"http:\/\/www.microsoft.com\/learning\/en-us\/exam-70-457.aspx\" target=\"_blank\" rel=\"noopener\">70-457<\/a>, I passed the DBA section which I studied, but failed on the SQL querying. Doh!\u00a0 The exam subject list includes a whole section on &#8216;row-based processing&#8217;, which does not fly well in my world of billion row tables.\u00a0 Note to self, study cursors.<\/li>\n<li>Sessions on my must see list today, <a href=\"http:\/\/www.varigence.com\/Products\/Biml\/Capabilities\">BIML<\/a> BIML was popular at Summit for all BI developers. This is definitely on my list of &#8216;Action Items&#8217; to try.<\/li>\n<li>I did not spend a lot of time in the vendor exhibitions area, but it was huge.\u00a0 I did visit with Dun &amp; Bradstreet and won their twitter challenge one evening.\u00a0 Thank you D&amp;B.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit-Vendors.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-597\" alt=\"Summit Vendors\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit-Vendors-300x79.jpg\" width=\"300\" height=\"79\" \/><\/a><\/p>\n<ul>\n<li>\n<h2>Community Appreciation Dinner<\/h2>\n<\/li>\n<li>The NASCAR Hall of Fame was a great venue.\u00a0 I enjoyed meeting people from around the world.<\/li>\n<\/ul>\n<figure id=\"attachment_601\" aria-describedby=\"caption-attachment-601\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit-Party.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-601\" alt=\"Summit Party\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit-Party-300x168.jpg\" width=\"300\" height=\"168\" \/><\/a><figcaption id=\"caption-attachment-601\" class=\"wp-caption-text\">Summit 2013 Community Appreciation Dinner at the NASCAR Hall of Fame.<\/figcaption><\/figure>\n<h2>Friday<\/h2>\n<ul>\n<li>The other exam I took was <a href=\"http:\/\/www.microsoft.com\/learning\/en-us\/exam-70-458.aspx\">70-458<\/a>.\u00a0 I read over the test requirements for an hour the night before and figured why not. At worst I figured it was half price and good practice.\u00a0 I left some constructive criticism in the comment section on a few choice questions.\u00a0 Really, I was polite.\u00a0 Then I pressed \u2018End Exam\u2019 and passed.\u00a0 Sweet.<\/li>\n<li>Final must-see session on my list was Tim Mitchell and then catch a late flight home.<\/li>\n<\/ul>\n<p>Overall, a great first time experience.\u00a0 Thank you PASS.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit_OKCSQL.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" alt=\"Summit OKCSQL UG\" src=\"http:\/\/www.cognitiveinfo.com\/wp-content\/uploads\/2013\/10\/Summit_OKCSQL-300x168.jpg\" width=\"300\" height=\"168\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An overview of PASS Summit 2013 from the eyes of a first timer.  <\/p>\n","protected":false},"author":2,"featured_media":594,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[65,71,110],"class_list":["post-587","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoftsql","tag-microsoft-sql-server","tag-pass","tag-user-group"],"_links":{"self":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=587"}],"version-history":[{"count":0,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/wp\/v2\/posts\/587\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cognitiveinfo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}