{"id":2655,"date":"2014-02-13T14:38:47","date_gmt":"2014-02-13T22:38:47","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/kimberly\/?p=2655"},"modified":"2014-02-20T15:08:55","modified_gmt":"2014-02-20T23:08:55","slug":"20140225nyc","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/20140225nyc\/","title":{"rendered":"New York .Net and SQL Server User Groups &#8211; We&#8217;re back!!"},"content":{"rendered":"<h2><b>Date &amp; Time: <\/b>Tuesday, February 25, 2014 &#8211; 6:30-9pm<\/h2>\n<h3><b>Evening theme\/title: SQL Server \u2013 Are you talking to me?<\/b><\/h3>\n<h3><b>Groups\/Target Audience: <\/b>SQL Server and .NET User Groups, anyone that works with SQL Server that wants to talk techie on Tuesday evening<\/h3>\n<h3>Cost: FREE (but, you must register; link at the end of this post)<\/h3>\n<p><b>Presenters: <\/b>Kimberly L. Tripp &amp; Jonathan Kehayias, SQLskills.com<\/p>\n<p><b>Abstract:<\/b> Our title seems strange but it runs across multiple themes. First we\u2019ll take a look at Service Broker in SQL Server and how it can extend service oriented architectures into the data tier with asynchronous message processing. As for the other theme, database developers, DBAs, architects \u2013 don\u2019t always talk to each other. In this evening session, we\u2019ll cover a mix of really interesting topics that help bridge the gap across these disciplines. Reading plans and understanding plans with Plan Explorer (both the free and the Pro versions will be discussed) \u2013 this is something everyone should be able to do. And, we&#8217;ll raffle off a PE Pro Edition (<b>thanks SQL Sentry<\/b>) in addition to talking about the FREE Plan Explorer. Then, we&#8217;ll dive into statement execution methods and plan cache. Different coding strategies on our servers can have a profound effect on both cache and performance. But, how can you write more effective code that takes less caching and has better plans? Some of this content comes from a newly released Pluralsight course titled: SQL Server \u2013 Optimizing Ad Hoc Statement Performance and for those of you that attend \u2013 Pluralsight will give you a monthly trial. And, we\u2019ll also raffle off two Annual Plus subscriptions (<b>thanks Pluralsight<\/b>)!<\/p>\n<p>How can we all just get along? Come to this fast-paced, demo-packed session led by industry-experts Kimberly L. Tripp and Jonathan Kehayias of SQLskills. And, after the presentation, Kimberly, Jonathan, and Paul Randal (also of SQLskills) will hang out for an open Q&amp;A on almost-anything-SQL. We\u2019ll post a list of topics and open up the floor!<\/p>\n<h3><b>Sponsors:<\/b><\/h3>\n<ul>\n<li>Pluralsight: <a href=\"http:\/\/www.pluralsight.com\">www.pluralsight.com<\/a><\/li>\n<li>SQL Sentry: <a href=\"http:\/\/www.sqlsentry.net\">www.sqlsentry.net<\/a><\/li>\n<li>SQLskills: <a href=\"http:\/\/www.SQLskills.com\">www.SQLskills.com<\/a><\/li>\n<\/ul>\n<h3><b>Rough Agenda:<\/b><\/h3>\n<ul>\n<li>6:30pm \u2013 Pizza (thanks Pluralsight &amp; SQL Sentry), networking, settling in<\/li>\n<li>7:00pm\n<ul>\n<li>Service Broker (~15 mins) \u2013 Jonathan Kehayias<\/li>\n<li>SQL Sentry\u2019s Plan Explorer (~15 mins) \u2013 Jonathan Kehayias<\/li>\n<li>Statement Execution (~15 mins) \u2013 Kimberly L. Tripp<\/li>\n<li>Plan Cache (~15 mins) \u2013 Kimberly L. Tripp<\/li>\n<\/ul>\n<\/li>\n<li>8:15pm \u2013 Raffles (<em>must be present to win<\/em>)\n<ul>\n<li>SQL Sentry Plan Explorer Pro License<\/li>\n<li>Pluralsight Annual Plus Subscriptions<\/li>\n<li>$100 off (per day) for an Immersion Event of your choice\u00a0(maximum value $500 for a 5-day event)<\/li>\n<li>Everyone \u2013 30-day trial subscription to Pluralsight<\/li>\n<\/ul>\n<\/li>\n<li>8:30pm \u2013 Open Q&amp;A (all 3 of us)<\/li>\n<\/ul>\n<h3><b>Location:<\/b><\/h3>\n<h2 style=\"padding-left: 30px;\">Microsoft<br \/>\n11 Times Square (<i>west 41st street and 8th avenue<\/i>)<br \/>\nNew York, NY 10036<\/h2>\n<p><i>Check-in with security in the lobby and then you\u2019ll proceed to the 9<sup>th<\/sup> floor. Our meeting will be held in the Music Box\/Winter Garden MPR.<\/i><\/p>\n<h2><b>And a final, big thanks to our evening hosts!<\/b><\/h2>\n<h3 style=\"padding-left: 30px;\"><b>Microsoft contact: <\/b>Jesus Aguilar, <a href=\"http:\/\/www.giventocode.com\/\" class=\"broken_link\">http:\/\/www.giventocode.com\/<\/a><b><br \/>\nSQL Server User Group contact:<\/b> Joe Lax, <a href=\"http:\/\/nycsqlusergroup.com\/\" class=\"broken_link\">http:\/\/nycsqlusergroup.com\/<\/a><br \/>\n<b>.NET User Group Contact:<\/b> Andrew Brust, <a href=\"http:\/\/www.nycdotnetdev.com\/\" class=\"broken_link\">http:\/\/www.nycdotnetdev.com\/<\/a><\/h3>\n<h1>Want to join us &#8211; register here (cost: free):<\/h1>\n<h2><a href=\"https:\/\/clicktoattend.microsoft.com\/en-us\/Pages\/EventDetails.aspx?EventId=179143\" target=\"_blank\" class=\"broken_link\">https:\/\/clicktoattend.microsoft.com\/en-us\/Pages\/EventDetails.aspx?EventId=179143<\/a><\/h2>\n","protected":false},"excerpt":{"rendered":"<p>Date &amp; Time: Tuesday, February 25, 2014 &#8211; 6:30-9pm Evening theme\/title: SQL Server \u2013 Are you talking to me? Groups\/Target Audience: SQL Server and .NET User Groups, anyone that works with SQL Server that wants to talk techie on Tuesday evening Cost: FREE (but, you must register; link at the end of this post) Presenters: [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,53,1,81],"tags":[],"class_list":["post-2655","post","type-post","status-publish","format-standard","hentry","category-events","category-plan-cache","category-uncategorized","category-user-group-presentations"],"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/2655","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/comments?post=2655"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/posts\/2655\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/media?parent=2655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/categories?post=2655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/kimberly\/wp-json\/wp\/v2\/tags?post=2655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}