{"id":12150,"date":"2012-03-07T10:40:07","date_gmt":"2012-03-07T10:40:07","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=12150"},"modified":"2012-03-07T10:40:07","modified_gmt":"2012-03-07T10:40:07","slug":"sql-server-2012-rtm","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=12150","title":{"rendered":"SQL Server 2012 RTM"},"content":{"rendered":"<p>I read yesterday that SQL Server 2012 had RTMd.&#160; It\u2019s not on MSDN yet.&#160; The <a href=\"http:\/\/www.sqlserverlaunch.com\/WW\/Agenda\" target=\"_blank\">online launch event<\/a> is later today at 16:00 GMT.&#160; There\u2019s lots more information about this new release on <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/hh231622(v=sql.110).aspx\" target=\"_blank\">TechNet<\/a>.&#160; There\u2019s a lot of <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/bb500435(v=sql.110).aspx\" target=\"_blank\">new features<\/a>, way too many for me to cover here, but the best one might be <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh510230(v=SQL.110).aspx\" target=\"_blank\">AlwaysOn<\/a>.&#160; That\u2019s a new database (or group of databases) availability feature, similar to DAG in Exchange.&#160; <\/p>\n<p>Please take note that <a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/future-editions\/sql2012-licensing.aspx\" target=\"_blank\">SQL 2012 licensing<\/a> is very different from what you are used to and there is a migration path for those with Software Assurance\/upgrade rights.<\/p>\n<p>Before you go upgrading your SQL, make sure that your products support SQL Server 2012.&#160; Don\u2019t just go assuming that they will, e.g. System Center.<\/p>\n<p>EDIT1:<\/p>\n<p>SQL 2012 <a href=\"http:\/\/blogs.technet.com\/b\/stbnewsbytes\/archive\/2012\/03\/06\/microsoft-releases-sql-server-2012-drives-advancements-in-big-data.aspx\" target=\"_blank\">general availability<\/a> will be April 1st.&#160; Please, no jokes <img decoding=\"async\" style=\"border-bottom-style: none; border-left-style: none; border-top-style: none; border-right-style: none\" class=\"wlEmoticon wlEmoticon-smile\" alt=\"Smile\" src=\"https:\/\/aidanfinn.com\/wp-content\/uploads\/2012\/03\/wlEmoticon-smile4.png\" \/><\/p>\n<div style=\"padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; display: inline; float: none; padding-top: 0px\" id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:9f3abaa2-6fe8-4dcc-9ffc-239ad09586b7\" class=\"wlWriterEditableSmartContent\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/SQL\" rel=\"tag\">SQL<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I read yesterday that SQL Server 2012 had RTMd.&#160; It\u2019s not on MSDN yet.&#160; The online launch event is later today at 16:00 GMT.&#160; There\u2019s lots more information about this new release on TechNet.&#160; There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.&#160; &hellip; <a href=\"https:\/\/aidanfinn.com\/?p=12150\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQL Server 2012 RTM&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_wpcom_ai_launchpad_first_post":false,"footnotes":""},"categories":[39],"tags":[192],"class_list":["post-12150","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"AFinn\"\/>\n\t<meta name=\"google-site-verification\" content=\"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aidanfinn.com\/?p=12150\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_GB\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"SQL Server 2012 RTM | Aidan Finn, IT Pro\" \/>\n\t\t<meta property=\"og:description\" content=\"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aidanfinn.com\/?p=12150\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-03-07T10:40:07+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2012-03-07T10:40:07+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@joe_elway\" \/>\n\t\t<meta name=\"twitter:title\" content=\"SQL Server 2012 RTM | Aidan Finn, IT Pro\" \/>\n\t\t<meta name=\"twitter:description\" content=\"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@joe_elway\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#article\",\"name\":\"SQL Server 2012 RTM | Aidan Finn, IT Pro\",\"headline\":\"SQL Server 2012 RTM\",\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/wp-content\\\/uploads\\\/2012\\\/03\\\/wlEmoticon-smile4.png\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150\\\/#articleImage\",\"width\":19,\"height\":19},\"datePublished\":\"2012-03-07T10:40:07+00:00\",\"dateModified\":\"2012-03-07T10:40:07+00:00\",\"inLanguage\":\"en-GB\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#webpage\"},\"articleSection\":\"SQL, SQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#listItem\",\"name\":\"SQL Server 2012 RTM\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#listItem\",\"position\":3,\"name\":\"SQL Server 2012 RTM\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?cat=39#listItem\",\"name\":\"SQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1\",\"name\":\"AFinn\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"AFinn\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#webpage\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150\",\"name\":\"SQL Server 2012 RTM | Aidan Finn, IT Pro\",\"description\":\"I read yesterday that SQL Server 2012 had RTMd. It\\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\\u2019s lots more information about this new release on TechNet. There\\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.\",\"inLanguage\":\"en-GB\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?p=12150#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/?author=1#author\"},\"datePublished\":\"2012-03-07T10:40:07+00:00\",\"dateModified\":\"2012-03-07T10:40:07+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#website\",\"url\":\"https:\\\/\\\/aidanfinn.com\\\/\",\"name\":\"Aidan Finn, IT Pro\",\"description\":\"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...\",\"inLanguage\":\"en-GB\",\"publisher\":{\"@id\":\"https:\\\/\\\/aidanfinn.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"SQL Server 2012 RTM | Aidan Finn, IT Pro","description":"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.","canonical_url":"https:\/\/aidanfinn.com\/?p=12150","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"TDKjbi2McB2eLIfL6KwPB3aQqv5E-mbcb2QYIcovGaI","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aidanfinn.com\/?p=12150#article","name":"SQL Server 2012 RTM | Aidan Finn, IT Pro","headline":"SQL Server 2012 RTM","author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"publisher":{"@id":"https:\/\/aidanfinn.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/aidanfinn.com\/wp-content\/uploads\/2012\/03\/wlEmoticon-smile4.png","@id":"https:\/\/aidanfinn.com\/?p=12150\/#articleImage","width":19,"height":19},"datePublished":"2012-03-07T10:40:07+00:00","dateModified":"2012-03-07T10:40:07+00:00","inLanguage":"en-GB","mainEntityOfPage":{"@id":"https:\/\/aidanfinn.com\/?p=12150#webpage"},"isPartOf":{"@id":"https:\/\/aidanfinn.com\/?p=12150#webpage"},"articleSection":"SQL, SQL"},{"@type":"BreadcrumbList","@id":"https:\/\/aidanfinn.com\/?p=12150#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/#listItem","position":1,"name":"Home","item":"https:\/\/aidanfinn.com\/","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","position":2,"name":"SQL","item":"https:\/\/aidanfinn.com\/?cat=39","nextItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=12150#listItem","name":"SQL Server 2012 RTM"},"previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?p=12150#listItem","position":3,"name":"SQL Server 2012 RTM","previousItem":{"@type":"ListItem","@id":"https:\/\/aidanfinn.com\/?cat=39#listItem","name":"SQL"}}]},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/#person","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=12150#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"Person","@id":"https:\/\/aidanfinn.com\/?author=1#author","url":"https:\/\/aidanfinn.com\/?author=1","name":"AFinn","image":{"@type":"ImageObject","@id":"https:\/\/aidanfinn.com\/?p=12150#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/65fde4aa9f2ab1cf1514ae320a37ec682d9398ce5791d3c2dd1e8670a71ceea0?s=96&d=mm&r=g","width":96,"height":96,"caption":"AFinn"}},{"@type":"WebPage","@id":"https:\/\/aidanfinn.com\/?p=12150#webpage","url":"https:\/\/aidanfinn.com\/?p=12150","name":"SQL Server 2012 RTM | Aidan Finn, IT Pro","description":"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.","inLanguage":"en-GB","isPartOf":{"@id":"https:\/\/aidanfinn.com\/#website"},"breadcrumb":{"@id":"https:\/\/aidanfinn.com\/?p=12150#breadcrumblist"},"author":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"creator":{"@id":"https:\/\/aidanfinn.com\/?author=1#author"},"datePublished":"2012-03-07T10:40:07+00:00","dateModified":"2012-03-07T10:40:07+00:00"},{"@type":"WebSite","@id":"https:\/\/aidanfinn.com\/#website","url":"https:\/\/aidanfinn.com\/","name":"Aidan Finn, IT Pro","description":"A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","inLanguage":"en-GB","publisher":{"@id":"https:\/\/aidanfinn.com\/#person"}}]},"og:locale":"en_GB","og:site_name":"Aidan Finn, IT Pro - A blog covering Azure, Hyper-V, Windows Server, desktop, systems management, deployment, and so on ...","og:type":"article","og:title":"SQL Server 2012 RTM | Aidan Finn, IT Pro","og:description":"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.","og:url":"https:\/\/aidanfinn.com\/?p=12150","article:published_time":"2012-03-07T10:40:07+00:00","article:modified_time":"2012-03-07T10:40:07+00:00","twitter:card":"summary","twitter:site":"@joe_elway","twitter:title":"SQL Server 2012 RTM | Aidan Finn, IT Pro","twitter:description":"I read yesterday that SQL Server 2012 had RTMd. It\u2019s not on MSDN yet. The online launch event is later today at 16:00 GMT. There\u2019s lots more information about this new release on TechNet. There\u2019s a lot of new features, way too many for me to cover here, but the best one might be AlwaysOn.","twitter:creator":"@joe_elway"},"aioseo_meta_data":{"post_id":"12150","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 03:53:18","updated":"2025-06-04 14:55:51","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aidanfinn.com\/?cat=39\" title=\"SQL\">SQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSQL Server 2012 RTM\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/aidanfinn.com\/"},{"label":"SQL","link":"https:\/\/aidanfinn.com\/?cat=39"},{"label":"SQL Server 2012 RTM","link":"https:\/\/aidanfinn.com\/?p=12150"}],"amp_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/12150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12150"}],"version-history":[{"count":0,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=\/wp\/v2\/posts\/12150\/revisions"}],"wp:attachment":[{"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aidanfinn.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}