{"id":2353,"date":"2013-06-05T06:00:00","date_gmt":"2013-06-05T13:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/06\/05\/sql-server-2014-a-closer-look\/"},"modified":"2024-01-22T22:49:18","modified_gmt":"2024-01-23T06:49:18","slug":"sql-server-2014-a-closer-look","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/","title":{"rendered":"SQL Server 2014: A Closer Look"},"content":{"rendered":"<p><span style=\"font-size:small;\"><a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/sql-server-2014.aspx?WT.mc_id=Blog_SSQL_TechEdNA_SQL2014\" target=\"_blank\" rel=\"noopener\">Microsoft SQL Server 2014<\/a><\/span><span style=\"font-size:small;\"> was announced by <\/span><a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2013\/06\/03\/sql-server-2014-unlocking-real-time-insights.aspx\"><span style=\"font-size:small;\">Quentin Clark<\/span><\/a><span style=\"font-size:small;\"> during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-first principles in mind, SQL Server 2014 builds on the momentum of SQL Server 2012, released just 14 months ago. We are excited to share a closer look at some of the exciting capabilities included in SQL Server 2014 that will help you unlock real-time insights with mission critical and cloud performance.<b><\/b><\/span><\/p>\n<p><b><span style=\"font-size:small;\">SQL Server 2014 helps organizations by delivering:<\/span><\/b><\/p>\n<ul>\n<li><span style=\"font-size:small;\"><b>Mission Critical Performance<\/b> across all database workloads with In-Memory for online transaction processing (OLTP), data warehousing and business intelligence built-in as well as greater scale and availability<\/span><\/li>\n<li><span style=\"font-size:small;\"><b>Platform for Hybrid Cloud <\/b>enabling organizations to more easily build, deploy and manage database solutions that span on-premises and cloud<\/span><\/li>\n<li><span style=\"font-size:small;\"><b>Faster Insights from Any Data <\/b>with a complete BI solution using familiar tools like Excel <\/span><\/li>\n<\/ul>\n<p><b><span style=\"text-decoration:underline;\"><span style=\"font-size:small;\">Mission Critical Performance with SQL Server 2014<\/span><\/span><\/b><\/p>\n<p><span style=\"font-size:small;\">SQL Server 2014 delivers new in-memory capabilities built into the core database for OLTP and data warehousing, which complement existing in-memory data warehousing and business intelligence capabilities for a comprehensive in-memory database solution. In addition to in-memory, there are new capabilities to improve the performance and scalability for your mission critical applications.<\/span><\/p>\n<p><b><span style=\"font-size:small;\">In Memory Built-In<\/span><\/b><\/p>\n<ul>\n<li>\n<span style=\"font-size:small;\">New In-Memory OLTP \u2013 built in to core SQL Server database and uniquely flexible to work with traditional SQL Server tables allowing you to improve performance of your database applications without having to refresh your existing hardware. We are seeing customers such as <\/span><a href=\"https:\/\/youtu.be\/fHTj274pu48\"><span style=\"font-size:small;\">EdgeNet<\/span><\/a><span style=\"font-size:small;\"> and <\/span><a href=\"https:\/\/www.youtube.com\/watch?v=nO200qJ_i-Y\"><span style=\"font-size:small;\">bwin<\/span><\/a><span style=\"font-size:small;\"> achieve significant performance gains to scale and accelerate their business.<\/span>\n<\/li>\n<li><span style=\"font-size:small;\">Enhanced In-Memory ColumnStore for Data Warehousing \u2013 now updatable with even faster query speeds and with greater data compression for more real-time analytics support.<\/span><\/li>\n<li><span style=\"font-size:small;\">New buffer pool extension support to non-volatile memory such as solid state drives (SSDs) \u2013 Increase performance by extending SQL Server in-memory buffer pool to SSDs for faster paging. <\/span><\/li>\n<li><span style=\"font-size:small;\">New Enhanced Query Processing \u2013 speeds all SQL Server queries regardless of workload.<\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-size:small;\">Enhanced Availability, Security and Scalability<\/span><\/b><\/p>\n<ul>\n<li><span style=\"font-size:small;\">Enhanced AlwaysOn \u2013 Built upon the significant capabilities introduced with SQL Server 2012, delivers mission critical availability with up to 8 readable secondaries and no downtime during online indexing operations.<\/span><\/li>\n<li><span style=\"font-size:small;\">Greater scalability of compute, networking and storage with Windows Server 2012 R2 \u2013<\/span><\/li>\n<\/ul>\n<blockquote><p>  <span style=\"font-size:small;\">&#8211; Increased scale \u2013 Continue to benefit from scale for up to 640 logical processors and 4TB of memory in a physical environment and up to 64 virtual processors and 1TB of memory per VM. <\/span> <br \/><span style=\"font-size:small;\">&#8211; Network Virtualization \u2013 Abstracts networking layer so that it you can easily migrate SQL Server from one datacenter to another. <\/span> <br \/><span style=\"font-size:small;\">&#8211; Storage Virtualization with Storage Spaces \u2013 Create pools of storage and storage tiers allowing your hot data to access the premium storage and cold data to access standard storage improving resilience, performance and predictability. <\/span>  <\/p><\/blockquote>\n<ul>\n<li><span style=\"font-size:small;\">Enhanced Resource Governance \u2013 With Resource Governor, SQL Server today helps you with scalability and predictable performance, and in SQL Server 2014, new capabilities allow you to manage IO, in addition to compute and memory to provide more predictable performance.<span style=\"text-decoration:underline;\"><\/span><\/span><\/li>\n<li><span style=\"font-size:small;\">Enhanced Separation of Duties \u2013 Achieve greater compliance with new capabilities for creating role and sub-roles. For example, a database administrator can now manage the data without seeing sensitive data or personally identifiable information.<b><\/b><\/span><\/li>\n<\/ul>\n<p><b><span style=\"text-decoration:underline;\"><span style=\"font-size:small;\">Platform for Hybrid Cloud<\/span><\/span><\/b><\/p>\n<p><span style=\"font-size:small;\">SQL Server 2014 creates a strong platform for hybrid cloud where cloud scale can be leveraged to extend the scalability and availability of on-premises database applications as well as reduce costs.<\/span><\/p>\n<p><b><span style=\"font-size:small;\">Simplified Cloud Backup and Disaster Recovery<\/span><\/b><\/p>\n<ul>\n<li><span style=\"font-size:small;\">Backup to Azure Storage \u2013 reduce costs and achieve greater data protection by backing up your on-premises database to Azure Storage at an instance level. Optimize backup policy with intelligence built in to SQL Server that monitors and tracks backup usage patterns to provide optimal cloud backup. Backups can be automatic or manual, and in case of an on-premises failure, a backup can be restored to a Windows Azure Virtual Machine. <\/span><\/li>\n<li><span style=\"font-size:small;\">AlwaysOn integration with Windows Azure Infrastructure Services \u2013 Benefit from Microsoft\u2019s global data centers by deploying a Windows Azure Virtual Machine as an AlwaysOn secondary for cost-effective global data protection. Increase performance and scale reporting for your global business units by running reporting off the readable secondaries in Windows Azure. Run backups on the secondaries in Windows Azure to increase data protection and performance.<\/span><\/li>\n<li><span style=\"font-size:small;\">SSMS Wizard for deploying AlwaysOn secondaries in Window Azure \u2013 Easily deploy an AlwaysOn secondaries to Windows Azure Virtual Machine with a point and click experience within SQL Server Management Studio (SSMS). <\/span><\/li>\n<\/ul>\n<p><b><span style=\"font-size:small;\">Easy Migration of On-Premises SQL Servers to Windows Azure Virtual Machines<\/span><\/b><\/p>\n<ul>\n<li><span style=\"font-size:small;\">SSMS Migration Wizard for Windows Azure Infrastructure Services \u2013 Easily migrate an on-premises SQL Server database to a Windows Azure Virtual machine with a point and click experience in SSMS. The newly deployed database application can be managed through SSMS or System Center 2012 R2. <\/span><\/li>\n<\/ul>\n<p><b><span style=\"text-decoration:underline;\"><span style=\"font-size:small;\">Faster Insights on Any Data<\/span><\/span><\/b><\/p>\n<p><span style=\"font-size:small;\">SQL Server 2014 is at the heart of our modern data platform which delivers a comprehensive BI solution that simplifies access to all data types big and small with additional solutions like <\/span><a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/solutions-technologies\/business-intelligence\/big-data.aspx?WT.mc_id=Blog_SSQL_TechEdNA_SQL2014\" target=\"_blank\" rel=\"noopener\">HDInsight<\/a><span style=\"font-size:small;\"><\/span><span style=\"font-size:small;\">, Microsoft\u2019s 100% Apache compatible Hadoop distribution and project code name \u201cData Explorer\u201d, which simplifies access to internal or external data. New data platform capabilities like Polybase included in Microsoft Parallel Data Warehouse allows you to integrate queries across relational and non-relational data using your existing SQL Server skills.<\/span><\/p>\n<p><span style=\"font-size:small;\">With SQL Server 2014, you can accelerate insights with our new in-memory capabilities with faster performance across workloads. You can continue to refine and manage data using Data Quality Services and Analysis Services in SQL Server and finally analyze the data and unlock insights with powerful BI tools built into Excel and SharePoint.<\/span><\/p>\n<p><b><span style=\"text-decoration:underline;\"><span style=\"font-size:small;\">Learn more and sign up for the Preview<\/span><\/span><\/b><\/p>\n<p><span style=\"font-size:small;\">SQL Server 2014 brings to market many new exciting capabilities that will deliver tremendous value to customers. SQL Server 2014 can help you unlock real-time insights with mission critical and cloud performance along with one of the most comprehensive BI solutions in the marketplace today.<\/span><\/p>\n<p><span style=\"font-size:small;\">If you are at TechEd North America and want to learn more about SQL Server 2014 you will not want to miss the following key sessions:<\/span><\/p>\n<ul>\n<li>\n<span style=\"font-size:small;\">Thursday, June 6<sup>th<\/sup>: <\/span><a href=\"https:\/\/channel9.msdn.com\/Events\/TechEd\/NorthAmerica\/2013\/DBI-B317\"><span style=\"font-size:small;\">DBI-B317<\/span><\/a><span style=\"font-size:small;\">: <\/span><a href=\"https:\/\/channel9.msdn.com\/Events\/TechEd\/NorthAmerica\/2013\/DBI-B317\"><span style=\"font-size:small;\">Microsoft SQL Server Future and Features<\/span><\/a>\n<\/li>\n<li>\n<span style=\"font-size:small;\">Wednesday, June 5<sup>th<\/sup>: <\/span><a href=\"https:\/\/channel9.msdn.com\/Events\/TechEd\/NorthAmerica\/2013\/DBI-B306\"><span style=\"font-size:small;\">DBI-B306: Microsoft SQL Server High Availability and Disaster Recovery on Windows Azure<\/span><\/a>\n<\/li>\n<\/ul>\n<p><span style=\"font-size:small;\">Learn more about SQL Server 2014 and download new datasheet and whitepapers <\/span><a href=\"http:\/\/www.microsoft.com\/en-us\/sqlserver\/sql-server-2014.aspx?WT.mc_id=Blog_SSQL_TechEdNA_SQL2014\">here<\/a><span style=\"font-size:small;\"><\/span><span style=\"font-size:small;\">.<\/span><\/p>\n<p><span style=\"font-size:small;\">Also if you haven\u2019t already <\/span><a href=\"http:\/\/technet.microsoft.com\/en-us\/evalcenter\/dn205292?WT.mc_id=Blog_SSQL_TechEdNA_SQL2014\" target=\"_blank\" rel=\"noopener\">sign up for the SQL Server 2014 CTP 1<\/a><span style=\"font-size:small;\"><\/span><span style=\"font-size:small;\"> bits coming in a few weeks!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft SQL Server 2014 was announced by Quentin Clark during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-first principles in mind, SQL Server 2014 builds on the momentum of SQL Server 2012, released just 14 months ago.<\/p>\n","protected":false},"author":1457,"featured_media":49836,"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":[2424],"topic":[],"coauthors":[2487],"class_list":["post-2353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","content-type-best-practices"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2014: A Closer Look - 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\/2013\/06\/05\/sql-server-2014-a-closer-look\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014: A Closer Look - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Microsoft SQL Server 2014 was announced by Quentin Clark during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-first principles in mind, SQL Server 2014 builds on the momentum of SQL Server 2012, released just 14 months ago.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/\" \/>\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=\"2013-06-05T13:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"120\" \/>\n\t<meta property=\"og:image:height\" content=\"90\" \/>\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=\"4 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\/2013\/06\/05\/sql-server-2014-a-closer-look\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2014: A Closer Look\",\"datePublished\":\"2013-06-05T13:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/\"},\"wordCount\":1045,\"commentCount\":14,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/\",\"name\":\"SQL Server 2014: A Closer Look - 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\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg\",\"datePublished\":\"2013-06-05T13:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:18+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg\",\"width\":120,\"height\":90},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014: A Closer Look\"}]},{\"@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":"SQL Server 2014: A Closer Look - 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\/2013\/06\/05\/sql-server-2014-a-closer-look\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014: A Closer Look - Microsoft SQL Server Blog","og_description":"Microsoft SQL Server 2014 was announced by Quentin Clark during the Microsoft TechEd 2013 keynote. Designed and developed with our cloud-first principles in mind, SQL Server 2014 builds on the momentum of SQL Server 2012, released just 14 months ago.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-06-05T13:00:00+00:00","article_modified_time":"2024-01-23T06:49:18+00:00","og_image":[{"width":120,"height":90,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.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":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2014: A Closer Look","datePublished":"2013-06-05T13:00:00+00:00","dateModified":"2024-01-23T06:49:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/"},"wordCount":1045,"commentCount":14,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/","name":"SQL Server 2014: A Closer Look - 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\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg","datePublished":"2013-06-05T13:00:00+00:00","dateModified":"2024-01-23T06:49:18+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2024\/01\/sql-server-2014-a-closer-look.jpg","width":120,"height":90},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/06\/05\/sql-server-2014-a-closer-look\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014: A Closer Look"}]},{"@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\/2353","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=2353"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2353\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/49836"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=2353"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=2353"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=2353"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=2353"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=2353"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=2353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}