{"id":82087,"date":"2010-11-11T01:52:18","date_gmt":"2010-11-11T01:52:18","guid":{"rendered":"https:\/\/www.webstaging.red-gate.com\/simple-talk\/?p=73332"},"modified":"2018-12-12T13:26:21","modified_gmt":"2018-12-12T13:26:21","slug":"pass-day-2-in-which-my-head-began-to-hurt","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/pass-day-2-in-which-my-head-began-to-hurt\/","title":{"rendered":"PASS Day 2\u2013In which my head began to hurt"},"content":{"rendered":"<p>This morning, keeping to my typical method I missed the keynote in person but kept up via twitter feed (<a title=\"http:\/\/twitter.com\/#!\/search\/%23sqlpass\" href=\"http:\/\/twitter.com\/#!\/search\/%23sqlpass\">http:\/\/twitter.com\/#!\/search\/%23sqlpass<\/a>). Knew about most of the new stuff, and seriously could have used a few more hours of sleep (I nodded off in a few sessions later in the day)<\/p>\n<p>My first session was Conor Cunningham\u2019s (<a title=\"http:\/\/blogs.msdn.com\/b\/conor_cunningham_msft\/\" href=\"http:\/\/blogs.msdn.com\/b\/conor_cunningham_msft\/\">http:\/\/blogs.msdn.com\/b\/conor_cunningham_msft\/<\/a>) session on UPDATEs and how they are done in a query engine. Great stuff when I could pay attention (my house cleaners set off the alarm and no one was around to help them so pandemonium ensued\u2026I was supposed to cancel this week, but I forgot\u2026). I love to get the internal view of what is going on in SQL Server so I can visualize why a query isn\u2019t working.&#160; I have a high level understanding, and for me, Conor helped to adjust some things I thought I knew and taught me some new stuff. When I get the DVD\u2019s I plan to watch this one again when I have a pause button and his scripts to play with.<\/p>\n<p>During lunch I more or less sat alone and loaded the Denali CTP on my machine so I could get the new interface to make a joke seem more initially credible.&#160; Hey, I was going to install it soon enough anyhow, but the new VS2010 interface lends a bit of credibility to the build up of a really weak joke.<\/p>\n<p>After lunch, I got to talking with some people at the Red Gate booth (again \ud83d\ude42 and missed Chuck Hawkins session on extended events.&#160; I wanted to go, and would have had I remembered it was him giving it (He used to be my boss 5 years ago).&#160; We had dinner at Charlie\u2019s On Broadway (guess what street), and it was quite good.&#160; He is a very adventurous person, unlike myself. Without some impetus I would eat a frozen dinner in my room at night \ud83d\ude42<\/p>\n<p>At 2:30, it was off to the well hidden Room 2AB for a couple of sessions (both of which I was quite sleepy during). First up was Ken Simmons\u2019 (<a title=\"http:\/\/twitter.com\/#!\/kensimmons\" href=\"http:\/\/twitter.com\/#!\/kensimmons\">http:\/\/twitter.com\/#!\/kensimmons<\/a>) Art of Indexing.&#160; It was kind of high level, but still interesting. Another of the sessions where the queries will be definitely worth it. Finally, Bob Ward\u2019s (<a title=\"http:\/\/twitter.com\/#!\/bobwardms\" href=\"http:\/\/twitter.com\/#!\/bobwardms\">http:\/\/twitter.com\/#!\/bobwardms<\/a>) latch session was outstanding and really deep. Just like Conor\u2019s session I will be watching it, checking out the scripts, and pressing pause over and over. <\/p>\n<p>Tomorrow I plan to finally get to at least most of Andy Leonard\u2019s (<a title=\"http:\/\/twitter.com\/#!\/andyleonard\" href=\"http:\/\/twitter.com\/#!\/andyleonard\">http:\/\/twitter.com\/#!\/andyleonard<\/a>) Database Design for Developers session. Annoyingly it is RIGHT before my database design session, so two things are true. 1. I may lose some people due to not wanting to see 3 hours of design 2. Not enough time to steal any of his material for my slides<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This morning, keeping to my typical method I missed the keynote in person but kept up via twitter feed (http:\/\/twitter.com\/#!\/search\/%23sqlpass). Knew about most of the new stuff, and seriously could have used a few more hours of sleep (I nodded off in a few sessions later in the day) My first session was Conor Cunningham\u2019s&#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-82087","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\/82087","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=82087"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82087\/revisions"}],"predecessor-version":[{"id":82333,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/82087\/revisions\/82333"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=82087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=82087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=82087"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=82087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}