{"id":485,"date":"2012-06-18T14:03:00","date_gmt":"2012-06-18T14:03:00","guid":{"rendered":"\/blogs\/bobb\/post\/Immersion-Events-IEDev-IE4-and-similar-(but-not-the-same)-topics.aspx"},"modified":"2013-01-03T23:59:23","modified_gmt":"2013-01-04T07:59:23","slug":"immersion-events-iedev-ie4-and-similar-but-not-the-same-topics","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/","title":{"rendered":"Immersion Events: IEDev, IE4, and similar (but not the same) topics"},"content":{"rendered":"<p>\n<a href=\"http:\/\/www.sqlskills.com\/immersionevents.asp\" class=\"broken_link\">SQL Server Immersion Events<\/a> are coming up in <a href=\"http:\/\/www.sqlskills.com\/immersioneventsschedule.asp\">August<\/a>. I deal with two different groups of people, developers and DBAs, on a variety of topics. When it comes to the specialized SQL Server topics (like SQLCLR, SQLXML, Service Broker,&nbsp;etc), I though that it would be best to address the seperate groups, each with a different focus. And I&#39;ve been asked &quot;what&#39;s the difference&quot; in coverage? Both groups may have input into feature usage, so they both want to know WHAT it is they are dealing with for planning purposes. And both want to know &quot;how do you make it run fast&quot;? That&#39;s where the similarity ends.\n<\/p>\n<p>\nDevelopers want the know how to program using a feature and learn about the use cases where it makes sense.&nbsp; Does it have it&#39;s own non-SQL language (like .NET or XQuery)? And how do I program that, what is the new syntax, new DML statements? Where do I look if I don&#39;t get the &quot;right answer&quot;? When is it best to use this feature as opposed to rolling my own equivalent in SQL? Does an equivalent in SQL even exist? How is this feature exposed within SQL (i.e. full-text CONTAINS, etc) and do these predicates, TVFs, etc, work well with other SQL constructs? Are there special constructs in the APIs I use, like ODBC or ADO.NET?\n<\/p>\n<p>\nDBAs want to know how a feature affects a running server, and special considerations for backup\/restore\/reorganization and capacity planning. They look at a feature and think, how much disk space does this use and how much memory? What does the DDL look like? Are there new database objects, especially indexes? How about DMVs, metadata, trace events, and performance monitor counters to troubleshoot when things go wrong? What are the security repercussions?\n<\/p>\n<p>\nThat&#39;s why I&#39;ve divided the topics more-or-less in two for the Immersion Events. IEDev is all about development, where IE4 covers some of the same topics for the more administratively inclined. Each one contains additional topics of interest to the corresponding group.\n<\/p>\n<p>\nHope this clears things up&#8230;\n<\/p>\n<p>\n@bobbeauch<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Immersion Events are coming up in August. I deal with two different groups of people, developers and DBAs, on a variety of topics. When it comes to the specialized SQL Server topics (like SQLCLR, SQLXML, Service Broker,&nbsp;etc), I though that it would be best to address the seperate groups, each with a different [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-485","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Immersion Events: IEDev, IE4, and similar (but not the same) topics - Bob Beauchemin<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Immersion Events: IEDev, IE4, and similar (but not the same) topics - Bob Beauchemin\" \/>\n<meta property=\"og:description\" content=\"SQL Server Immersion Events are coming up in August. I deal with two different groups of people, developers and DBAs, on a variety of topics. When it comes to the specialized SQL Server topics (like SQLCLR, SQLXML, Service Broker,&nbsp;etc), I though that it would be best to address the seperate groups, each with a different [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/\" \/>\n<meta property=\"og:site_name\" content=\"Bob Beauchemin\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-18T14:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-01-04T07:59:23+00:00\" \/>\n<meta name=\"author\" content=\"Bob Beauchemin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bob Beauchemin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/\",\"name\":\"Immersion Events: IEDev, IE4, and similar (but not the same) topics - Bob Beauchemin\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\"},\"datePublished\":\"2012-06-18T14:03:00+00:00\",\"dateModified\":\"2013-01-04T07:59:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uncategorized\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/uncategorized\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Immersion Events: IEDev, IE4, and similar (but not the same) topics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/\",\"name\":\"Bob Beauchemin\",\"description\":\"SQL Server Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e\",\"name\":\"Bob Beauchemin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g\",\"caption\":\"Bob Beauchemin\"},\"sameAs\":[\"http:\/www.sqlskills.com\/blogs\/bobb\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Immersion Events: IEDev, IE4, and similar (but not the same) topics - Bob Beauchemin","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/","og_locale":"en_US","og_type":"article","og_title":"Immersion Events: IEDev, IE4, and similar (but not the same) topics - Bob Beauchemin","og_description":"SQL Server Immersion Events are coming up in August. I deal with two different groups of people, developers and DBAs, on a variety of topics. When it comes to the specialized SQL Server topics (like SQLCLR, SQLXML, Service Broker,&nbsp;etc), I though that it would be best to address the seperate groups, each with a different [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/","og_site_name":"Bob Beauchemin","article_published_time":"2012-06-18T14:03:00+00:00","article_modified_time":"2013-01-04T07:59:23+00:00","author":"Bob Beauchemin","twitter_misc":{"Written by":"Bob Beauchemin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/","name":"Immersion Events: IEDev, IE4, and similar (but not the same) topics - Bob Beauchemin","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website"},"datePublished":"2012-06-18T14:03:00+00:00","dateModified":"2013-01-04T07:59:23+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/immersion-events-iedev-ie4-and-similar-but-not-the-same-topics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/"},{"@type":"ListItem","position":2,"name":"Uncategorized","item":"https:\/\/www.sqlskills.com\/blogs\/bobb\/category\/uncategorized\/"},{"@type":"ListItem","position":3,"name":"Immersion Events: IEDev, IE4, and similar (but not the same) topics"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/","name":"Bob Beauchemin","description":"SQL Server Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/bobb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/62bfa986c5b5d28fcffd8b4fc409c73e","name":"Bob Beauchemin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/bobb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6f80e6cc667410857fa6a21931dc528b8092f4d112bf7a8ff7c267674d44ee37?s=96&d=mm&r=g","caption":"Bob Beauchemin"},"sameAs":["http:\/www.sqlskills.com\/blogs\/bobb\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/bobb\/author\/bobb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/comments?post=485"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/posts\/485\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/media?parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/categories?post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/bobb\/wp-json\/wp\/v2\/tags?post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}