{"id":3472,"date":"2013-12-06T01:27:00","date_gmt":"2013-12-06T00:27:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/"},"modified":"2013-12-06T01:27:00","modified_gmt":"2013-12-06T00:27:00","slug":"sql-server-2014-an-overview-of-the-new-features","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/","title":{"rendered":"SQL Server 2014: An overview of the New Features"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg\" alt=\"\" \/><\/p>\n<p>The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1&#8217;000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from <a href=\"http:\/\/www.microsoft.com\/fr-ch\/events\/techdays\/default.aspx\">Lausanne<\/a> or <a href=\"http:\/\/www.microsoft.com\/de-ch\/events\/techdays\/default.aspx\">Basel<\/a>. In this blog, I will summarize the presentation of <a href=\"http:\/\/download.microsoft.com\/download\/8\/C\/E\/8CE2758C-2404-4644-89AA-CC0594162E6C\/TD13Lausanne2-31.pptx\">SQL Server 2014: les nouveaut\u00e9s<\/a> by Tien Dung Thoi at the TechDays in Lausanne.<\/p>\n<h3>In-Memory OLTP<\/h3>\n<p>The main new feature in SQL Server 2014 is In-Memory OLTP, which grants you a significant speed improvement. This flagship feature stores all the data in the memory to improve access time &#8211; which is now nearly 1000 times faster than that of a hard drive disk. You can also choose to duplicate the data into the disk to make it persistent.<\/p>\n<p>In-Memory OLTP has the following characteristics:<\/p>\n<ul>\n<li>Only hash and range indexes are available;<\/li>\n<li>No buffer pool;<\/li>\n<li>Stream-based storage for durability;<\/li>\n<li>Full ACID support;<\/li>\n<li>Core engine uses lock-free algorithms;<\/li>\n<li>No lock manager, latches or spinlocks;<\/li>\n<li>Use of T-SQL compiled to machine code, via C code generator (C compiler integrated in SQL Server 2014 engine);<\/li>\n<li>Invoking procedure is just a DLL entry-point;<\/li>\n<li>Aggressive optimization at compile-time.<\/li>\n<\/ul>\n<p>Databases gains the same manageability, administration and development experience with SQL Server Integration:<\/p>\n<ul>\n<li>Integrated queries and transactions;<\/li>\n<li>Integrated High Availability and backup\/restore.<\/li>\n<\/ul>\n<p>For more information, please have a look at St\u00e9phane Savorgnano&#8217;s posting\u00a0 <a href=\"\/sql-server-2014-in-memory-oltp-project-qhekatonq\">SQL Server 2014: In-memory OLTP project \u201cHekaton\u201d<\/a>.<\/p>\n<h3>ColumnStore<\/h3>\n<p>The query speed has been significantly improved when using column store indexes, with the use of a new batch mode.<br \/>\nThis batch mode improves CPU utilization by:<\/p>\n<ul>\n<li>Minimizing instructions per row;<\/li>\n<li>Taking advantage of cache structures;<\/li>\n<li>Highly efficient algorithms;<\/li>\n<li>A better parallelism.<\/li>\n<\/ul>\n<h3>AlwaysOn<\/h3>\n<p>AlwaysOn has been enhanced with two minor changes. The first one is the number of secondaries that has been increased from four to eight, but the number of synchronized secondaries is still two. The second one is that it now allows FCI customers to configure CSV paths for system and user databases.<\/p>\n<p>have a look at St\u00e9phane Haby&#8217;s posting <a href=\"\/sql-server-2014-alwayson-verfuegbarkeitsgruppen-jetzt-mit-microsoft-cloud\">SQL Server 2014: AlwaysOn-Verf\u00fcgbarkeitsgruppen \u2013 jetzt mit Microsoft Cloud!<\/a>.<\/p>\n<h3>Permissions<\/h3>\n<p>There are four new permissions in SQL Server 2014:<\/p>\n<ul>\n<li>CONNECT ANY DATABASE: is a server level permissions which allows to connect all current databases and any new databases that might be created in the future;<\/li>\n<li>IMPERSONATE ANY LOGIN: is a server level permissions which allows a middle-tier process to impersonate the account of clients connecting to it, as it connects to databases;<\/li>\n<li>SELECT ALL USERS SECURABLES: is a server level permission which allows to view data in all databases that the login has the permission to connect to;<\/li>\n<li>ALTER ANY DATABASE EVENT SESSION: is a database level permission which allows a role to read all metadata.<\/li>\n<\/ul>\n<h3>Backup Encryption<\/h3>\n<p>You can encrypt your data while you are performing a backup, independently of the destination &#8211; whether internal or external. You have to specify the encryption algorithm and the encryptor when creating the backup.<\/p>\n<p>The supported encryptions are:<\/p>\n<ul>\n<li>AES 128;<\/li>\n<li>AES 192;<\/li>\n<li>AES 256;<\/li>\n<li>Triple DES.<\/li>\n<\/ul>\n<p>The supported encryptors are:<\/p>\n<ul>\n<li>A Certificate;<\/li>\n<li>An Asymmetric Key.<\/li>\n<\/ul>\n<h3>Microsoft Power BI<\/h3>\n<p><strong>Power Query <\/strong>permits to search and access specific data across multiple sites, whether internal or external from your organization.<br \/>\nYou can also transform and combine this data for relevant analysis, such as:<br \/>\n\u2022 Clean, transform, and shape;<br \/>\n\u2022 Merge and combine.<\/p>\n<p><strong>Power Pivot <\/strong>is an Excel feature for faster analytics and flexible modeling of large data sets, with in-memory technology.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerPivot-Example_20131126-140202_1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerPivot-Example_20131126-140202_1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"PowerPivot-Example_20131126-140202_1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerPivot-Example_20131126-140202_1.png\" alt=\"PowerPivot-Example_20131126-140202_1.png\" width=\"250\" height=\"147\" \/><\/a><\/p>\n<p><strong>Power View<\/strong> allows to see the data in new ways with an interactive virtualization, such as a 3 D geospatial analysis with Power Map.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"PowerPivot-Example_20131126-141859_1.png\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerPivot-Example_20131126-141859_1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"PowerPivot-Example_20131126-141859_1.png\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/PowerPivot-Example_20131126-141859_1.png\" alt=\"PowerPivot-Example_20131126-141859_1.png\" width=\"250\" height=\"185\" \/><\/a><\/p>\n<h3>Hybrid Cloud<\/h3>\n<p>Cloud backup, manual or automatic, has been simplified with point in time restore at instance level, and measures databases usage patterns to set backup frequency.<br \/>\nMoreover there is a fast disaster recovery with a low Recovery Time Objective, which is easy to deploy and manage.<\/p>\n<p>Furthermore, a new wizard has been delivered to deploy database to SQL Server in Windows Azure Virtual Machine for easier use.<\/p>\n<h3>SQL Server 2014 CTP2: what is new from the CTP1?<\/h3>\n<p>In-Memory OLTP is now present into the SQL Server Engine: it does not require any additional actions to be installed. It allows some in-memory performance benefits: you do not need to rewrite your database application or to refresh your hardware. Moreover CTP2 enhancements include AlwaysOn support, increased T-SQL surface area, and ability to migrate existing objects to In-Memory OLTP.<\/p>\n<p>In-Memory Updateable ColumnStore provides higher compression, richer query support and updateability of the existing ColumnStore for data warehousing workloads. It gives you even faster load speed, query performance, concurrency, and even lower price per terabyte.<br \/>\nSQL Server uses SSDs as an extension to the database buffer pool, allowing more in-memory processing and reducing disk I\/O.<br \/>\nFor the Resource Gouvernor, Resource pools now support configuration of minimum and maximum IOPS per volume.<\/p>\n<h3>Conclusion<\/h3>\n<p>There is a very strong will on the part of Microsoft to provide BI tools, in order to easily access, analyze and share data from any source.<br \/>\nMoreover, Microsoft has a real desire to strenghten Cloud utilization through Windows Azure and AlwaysOn.<\/p>\n<p>But without a doubt, the flagship product of this new edition of SQL Server is In-Memory OLTP. It improves significantly performance and rapidity of your databases.<br \/>\nFor more information have a look at the presentation of <a href=\"http:\/\/download.microsoft.com\/download\/8\/C\/E\/8CE2758C-2404-4644-89AA-CC0594162E6C\/TD13Lausanne2-63.pptx\">SQL Server 2014: In-Memory OLTP<\/a> by St\u00e9phane Haby &amp; St\u00e9phane Savorgnano.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1&#8217;000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":3189,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[23,50,52],"type_dbi":[],"class_list":["post-3472","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-dba","tag-microsoft-techdays","tag-sql-server-2014"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2014: An overview of the New Features - dbi Blog<\/title>\n<meta name=\"description\" content=\"The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1&#039;000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveaut\u00e9s by Tien Dung Thoi at the TechDays in Lausanne.\" \/>\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.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014: An overview of the New Features\" \/>\n<meta property=\"og:description\" content=\"The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1&#039;000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveaut\u00e9s by Tien Dung Thoi at the TechDays in Lausanne.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-06T00:27:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"245\" \/>\n\t<meta property=\"og:image:height\" content=\"149\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"SQL Server 2014: An overview of the New Features\",\"datePublished\":\"2013-12-06T00:27:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\"},\"wordCount\":911,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg\",\"keywords\":[\"DBA\",\"Microsoft TechDays\",\"SQL Server 2014\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\",\"name\":\"SQL Server 2014: An overview of the New Features - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg\",\"datePublished\":\"2013-12-06T00:27:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1'000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveaut\u00e9s by Tien Dung Thoi at the TechDays in Lausanne.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg\",\"width\":245,\"height\":149},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014: An overview of the New Features\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2014: An overview of the New Features - dbi Blog","description":"The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1'000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveaut\u00e9s by Tien Dung Thoi at the TechDays in Lausanne.","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.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014: An overview of the New Features","og_description":"The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1'000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveaut\u00e9s by Tien Dung Thoi at the TechDays in Lausanne.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/","og_site_name":"dbi Blog","article_published_time":"2013-12-06T00:27:00+00:00","og_image":[{"width":245,"height":149,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg","type":"image\/jpeg"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"SQL Server 2014: An overview of the New Features","datePublished":"2013-12-06T00:27:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/"},"wordCount":911,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg","keywords":["DBA","Microsoft TechDays","SQL Server 2014"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/","name":"SQL Server 2014: An overview of the New Features - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg","datePublished":"2013-12-06T00:27:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1'000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveaut\u00e9s by Tien Dung Thoi at the TechDays in Lausanne.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_sqlserver2014_20130625-144612_1.jpg","width":245,"height":149},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-an-overview-of-the-new-features\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014: An overview of the New Features"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3472"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3472\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3189"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3472"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}