{"id":4233,"date":"2011-09-13T13:29:08","date_gmt":"2011-09-13T20:29:08","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/"},"modified":"2024-01-22T22:49:58","modified_gmt":"2024-01-23T06:49:58","slug":"streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/","title":{"rendered":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3"},"content":{"rendered":"<p><font face=\"Calibri\"><font style=\"font-size: 11pt\" color=\"#000000\">       <br \/><font size=\"2\" face=\"Segoe UI\">With Microsoft StreamInsight in SQL Server 2008 R2, we started to make Complex Event Processing capabilities available in Microsoft\u2019s data platform. We are excited that the upcoming SQL Server Code Name \u201cDenali\u201d<\/font><\/font><\/font><font color=\"#000000\" size=\"2\" face=\"Segoe UI\"> release will include key improvements for StreamInsight. In this video, I will go over the highlights of the following four areas that are also available as part of SQL Server Code Name &#8220;Denali\u201d CTP3:<\/font><\/p>\n<p style=\"line-height: 13pt; list-style-type: disc; text-indent: -0.25in; margin: 0in 0in 0pt 0.5in; mso-list: l0 level1 lfo1\" class=\"MsoListParagraphCxSpFirst\"><span style=\"mso-ascii-font-family: calibri; mso-fareast-font-family: calibri; mso-hansi-font-family: calibri; mso-bidi-font-family: calibri\"><span style=\"mso-list: ignore\"><font color=\"#000000\"><font size=\"2\" face=\"Segoe UI\"><\/font><\/font><\/span><\/span><\/p>\n<p style=\"line-height: 13pt; list-style-type: disc; text-indent: -0.25in; margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1\" class=\"MsoListParagraphCxSpFirst\"><font face=\"Segoe UI\"><font size=\"2\"><span style=\"mso-ascii-font-family: calibri; mso-fareast-font-family: calibri; mso-hansi-font-family: calibri; mso-bidi-font-family: calibri\"><span style=\"mso-list: ignore\"><font color=\"#000000\">&#8211;<span style=\"line-height: normal; font-family: \">\u00a0\u00a0\u00a0\u00a0 <\/span><\/font><\/span><\/span><b style=\"mso-bidi-font-weight: normal\"><font color=\"#000000\">Resiliency against planned and unplanned downtime through checkpointing<\/font><\/b><\/font><\/font><font size=\"2\" face=\"Segoe UI\">      <br \/><font color=\"#000000\">The new resiliency features in StreamInsight let you run your mission-critical applications with tolerance to system failures and minimal operational downtime. It supports query recovery from failure by periodically checkpointing query state during normal operations. After the outage, the query recovers its query state from the last persisted checkpoint.<\/font>       <br style=\"mso-special-character: line-break\"><br style=\"mso-special-character: line-break\"><\/font><\/p>\n<p style=\"line-height: 13pt; list-style-type: disc; text-indent: -0.25in; margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1\" class=\"MsoListParagraphCxSpMiddle\"><span style=\"mso-ascii-font-family: calibri; mso-fareast-font-family: calibri; mso-hansi-font-family: calibri; mso-bidi-font-family: calibri\"><span style=\"mso-list: ignore\"><font color=\"#000000\"><font face=\"Segoe UI\"><font size=\"2\">&#8211;<span style=\"line-height: normal; font-family: \">\u00a0\u00a0\u00a0\u00a0 <\/span><\/font><\/font><\/font><\/span><\/span><font face=\"Segoe UI\"><font size=\"2\"><font color=\"#000000\"><b style=\"mso-bidi-font-weight: normal\">Improved development experience through support for nested event type structures and additional LINQ expressions            <br \/><\/b>Previously, StreamInsight event types needed to be flat lists of payload fields. The new version of StreamInsight enables users to express event types as nested structures, reducing the friction between your native event schemas and their representation in StreamInsight. A number of other improvements \u2013 like n-way joins, nested queries, and support for query macros \u2013 enhance the developer experience.<\/font>         <br style=\"mso-special-character: line-break\"><br style=\"mso-special-character: line-break\"><b style=\"mso-bidi-font-weight: normal\"><\/b><\/font><\/font><\/p>\n<p style=\"line-height: 13pt; list-style-type: disc; text-indent: -0.25in; margin: 0in 0in 0pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1\" class=\"MsoListParagraphCxSpMiddle\"><font face=\"Segoe UI\"><font size=\"2\"><span style=\"mso-ascii-font-family: calibri; mso-fareast-font-family: calibri; mso-hansi-font-family: calibri; mso-bidi-font-family: calibri\"><span style=\"mso-list: ignore\"><font color=\"#000000\">&#8211;<span style=\"line-height: normal; font-family: \">\u00a0\u00a0\u00a0\u00a0 <\/span><\/font><\/span><\/span><b style=\"mso-bidi-font-weight: normal\"><font color=\"#000000\">Better support for predictive modeling and pattern matching scenarios through new user-defined stream operators<\/font><\/b><\/font><\/font><font size=\"2\" face=\"Segoe UI\">      <br \/><font color=\"#000000\">A user-defined stream operator, or UDSO as the team affectionately calls the feature, lets you interact with an event stream in a procedural way. Unlike previous extensibility interfaces, UDSOs are not bound to StreamInsight windows, and can maintain their own state. <\/font>      <br style=\"mso-special-character: line-break\"><br style=\"mso-special-character: line-break\"><\/font><\/p>\n<p style=\"line-height: 13pt; list-style-type: disc; text-indent: -0.25in; margin: 0in 0in 10pt 0.25in; mso-add-space: auto; mso-list: l0 level1 lfo1\" class=\"MsoListParagraphCxSpLast\"><font face=\"Segoe UI\"><font size=\"2\"><span style=\"mso-ascii-font-family: calibri; mso-fareast-font-family: calibri; mso-hansi-font-family: calibri; mso-bidi-font-family: calibri\"><span style=\"mso-list: ignore\"><font color=\"#000000\">&#8211;<span style=\"line-height: normal; font-family: \">\u00a0\u00a0\u00a0\u00a0 <\/span><\/font><\/span><\/span><b style=\"mso-bidi-font-weight: normal\"><font color=\"#000000\">Improved administrator experience through performance counters<\/font><\/b><\/font><\/font><font color=\"#000000\" size=\"2\" face=\"Segoe UI\">      <br \/><b style=\"mso-bidi-font-weight: normal\">and event log<\/b>       <br \/>In previous versions, StreamInsight runtime diagnostics were only available through StreamInsight\u2019s diagnostic views. In this release, StreamInsight introduces support for diagnostics through the standard Windows performance counter infrastructure. This makes it easy to monitor the health and performance of StreamInsight applications using well-established tools, such as Performance Monitor. The new administrative event log in turn records administrative events and errors, which can be discovered, explored, and used via system tools such as Windows Event Viewer. <\/font><\/p>\n<p style=\"list-style-type: disc; margin: 0in 0in 10pt\" class=\"MsoNormal\"><font color=\"#000000\"><strong>       <br \/><font size=\"2\" face=\"Segoe UI\">Get SQL Server Code Name \u201cDenali\u201d CTP 3 and StreamInsight 1.2 today!<\/font><\/strong><font size=\"2\" face=\"Segoe UI\">        <br \/><\/font><\/font><font face=\"Segoe UI\"><font size=\"2\"><font color=\"#000000\">Download SQL Server Code Name \u201cDenali\u201d CTP3 at:<\/font> <u><a href=\"http:\/\/www.microsoft.com\/denali\">http:\/\/www.microsoft.com\/denali<\/a> <\/u>        <br \/><font color=\"#000000\">Download StreamInsight 1.2 directly at: <\/font><\/font><\/font><a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=26720\"><\/a><a href=\"http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=26720We%E2%80%99d\"><font size=\"2\" face=\"Segoe UI\">http:\/\/www.microsoft.com\/download\/en\/details.aspx?id=26720<\/font><\/a><font color=\"#000000\">       <\/p>\n<p><font size=\"2\" face=\"Segoe UI\">We\u2019d<\/font><\/font><font size=\"2\" face=\"Segoe UI\"> love to hear your feedback on how the new features are working for you!<\/font><font face=\"Calibri\"><font style=\"font-size: 11pt\" color=\"#000000\"><font size=\"2\" face=\"Segoe UI\">\u00a0 <\/font>        <\/p>\n<p><\/font><\/font><\/p>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:5737277B-5D6D-4f48-ABFC-DD9C333F4C5D:e4837dea-b36f-45f4-a351-ca7d2853416c\" class=\"wlWriterEditableSmartContent\">\n<div id=\"f30561af-11a0-4596-ad35-825382cba581\" style=\"margin: 0px; padding: 0px; display: inline;\">\n<div><a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/3771.videodd6766a28f40.jpg\" target=\"_new\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/3771.videodd6766a28f40.jpg\" original-url=\"http:\/\/blogs.technet.com\/cfs-file.ashx\/__key\/communityserver-blogs-components-weblogfiles\/00-00-00-60-54-metablogapi\/3771.videodd6766a28f40.jpg\" style=\"border-style: none\" galleryimg=\"no\" onload=\"var downlevelDiv = document.getElementById('f30561af-11a0-4596-ad35-825382cba581'); downlevelDiv.innerHTML = &quot;&lt;div&gt;&lt;object width=\\&quot;524\\&quot; height=\\&quot;294\\&quot;&gt;&lt;param name=\\&quot;movie\\&quot; value=\\&quot;https:\/\/www.youtube.com\/v\/7V6yqZFbjbw?hl=en&amp;hd=1\\&quot;&gt;&lt;\\\/param&gt;&lt;embed src=\\&quot;https:\/\/www.youtube.com\/v\/7V6yqZFbjbw?hl=en&amp;hd=1\\&quot; type=\\&quot;application\/x-shockwave-flash\\&quot; width=\\&quot;524\\&quot; height=\\&quot;294\\&quot;&gt;&lt;\\\/embed&gt;&lt;\\\/object&gt;&lt;\\\/div&gt;&quot;;\" alt=\"\" srcset=\"\"><\/a><\/div>\n<\/div>\n<\/div>\n<p style=\"list-style-type: disc; margin: 0in 0in 10pt\" class=\"MsoNormal\"><font color=\"#000000\" face=\"Calibri\"><\/font><\/p>\n<p style=\"list-style-type: disc; margin: 0in 0in 10pt\" class=\"MsoNormal\"><font color=\"#000000\" size=\"2\" face=\"Segoe UI\">     <br \/>Torsten Grabs       <br \/>Program Manager       <br \/>Microsoft StreamInsight Team<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"<p>With Microsoft StreamInsight in SQL Server 2008 R2, we started to make Complex Event Processing capabilities available in Microsoft\u2019s data platform. We are excited that the upcoming SQL Server Code Name \u201cDenali\u201d release will include key improvements for StreamInsight.<\/p>\n","protected":false},"author":1457,"featured_media":49938,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-4233","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog<\/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.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"With Microsoft StreamInsight in SQL Server 2008 R2, we started to make Complex Event Processing capabilities available in Microsoft\u2019s data platform. We are excited that the upcoming SQL Server Code Name \u201cDenali\u201d release will include key improvements for StreamInsight.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2011-09-13T20:29:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3\",\"datePublished\":\"2011-09-13T20:29:08+00:00\",\"dateModified\":\"2024-01-23T06:49:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\"},\"wordCount\":407,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\",\"name\":\"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg\",\"datePublished\":\"2011-09-13T20:29:08+00:00\",\"dateModified\":\"2024-01-23T06:49:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg\",\"width\":1280,\"height\":720,\"caption\":\"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/","og_locale":"en_US","og_type":"article","og_title":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog","og_description":"With Microsoft StreamInsight in SQL Server 2008 R2, we started to make Complex Event Processing capabilities available in Microsoft\u2019s data platform. We are excited that the upcoming SQL Server Code Name \u201cDenali\u201d release will include key improvements for StreamInsight.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2011-09-13T20:29:08+00:00","article_modified_time":"2024-01-23T06:49:58+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg","type":"image\/jpeg"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3","datePublished":"2011-09-13T20:29:08+00:00","dateModified":"2024-01-23T06:49:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/"},"wordCount":407,"commentCount":3,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/","name":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg","datePublished":"2011-09-13T20:29:08+00:00","dateModified":"2024-01-23T06:49:58+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/streaminsight-1-2-new-in-sql-ser.jpg","width":1280,"height":720,"caption":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2011\/09\/13\/streaminsight-1-2-new-in-sql-server-code-name-denali-ctp3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"StreamInsight 1.2 \u2013 New in SQL Server Code Name \u201cDenali\u201d CTP3"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=4233"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/4233\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/49938"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=4233"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=4233"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=4233"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=4233"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=4233"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=4233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}