{"id":3160,"date":"2013-06-25T02:09:00","date_gmt":"2013-06-25T00:09:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/"},"modified":"2013-06-25T02:09:00","modified_gmt":"2013-06-25T00:09:00","slug":"sql-server-2014-in-memory-oltp-project-qhekatonq","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/","title":{"rendered":"SQL Server 2014: In-memory OLTP project &#8220;Hekaton&#8221;"},"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_InMemory.jpg\" alt=\"\" \/><\/p>\n<p>I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I&#8217;m beginning with the SQL Server In-Memory OLTP project &#8220;Hekaton&#8221;! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.<\/p>\n<p>The goal of this new feature is to:<\/p>\n<ul>\n<li>Memory optimized table and index structures<\/li>\n<li>Native compilation of business logic in Stored Procedure<\/li>\n<li>Get rid of Latch and Lock data structures<\/li>\n<li>To be fully integrated into SQL Server<\/li>\n<\/ul>\n<h3>How do they achieve that<\/h3>\n<p>Avoiding latches&#8230; Pages are used to store data rows and in multi-threaded applications you need to ensure that the threads do not trip over each other, latches have been developed to perform the task of thread synchronisation. Once an operation is complete, the thread synchronisation objects (latches) will be released and the other threads will be able to access that page and memory structures again. But some time has been lost&#8230;<\/p>\n<p>With In-memory technology table and index structures are memory optimized. This way, you get rid of pages, b-trees and other latches as the row is the atomic unit!<\/p>\n<p>Of course, as it will not be possible to load all tables in the memory, you will have to choose the ones which are causing the most latching.<br \/>\nFor that, SQL Server 2014 will provide a new tool called: Transaction Performance Analysis Overview.<\/p>\n<p>You will be able to select tables or Stored Procedure and this tool will analyse the workload and find contention. It will give you a chart showing which table should be moved to in-memory OLTP to obtain the maximun gain. The same applies for stored procedure if you choose to analyze Stored Procedures.<\/p>\n<p>Once you have found the table which causes latches you will have to drop it and recreate it with some special attributes<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog_hekaton1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog_hekaton1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog_hekaton1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog_hekaton1.jpg\" alt=\"b2ap3_thumbnail_blog_hekaton1.jpg\" \/><\/a><\/p>\n<ul>\n<li>table is memory optimized, need to be specified during the creation<\/li>\n<li>table is durabe: schema and data are durable by default<\/li>\n<li>nonclustered hash index: new type of index<br \/>\nbucket count: specify how many bucket will be in the hash table<\/li>\n<li>secondary indexes are specified inline, you will not be able to specified them later because this table will be compile and become a DLL.<\/li>\n<\/ul>\n<p>Hash indexes are a set of buckets (8-bytes memory pointers). SQL Server 2014 has a hash function to map values to buckets. It is built into the system.<\/p>\n<p>This process will take place during the script execution:<\/p>\n<ul>\n<li>Create table DLL<\/li>\n<li>Code generation and compilation<\/li>\n<li>Table DLL produced<\/li>\n<li>Table DLL loaded in memory<\/li>\n<\/ul>\n<p>For a Stored Procedure:<\/p>\n<p><a title=\"blog_hekaton2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog_hekaton2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog_hekaton2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog_hekaton2.jpg\" alt=\"b2ap3_thumbnail_blog_hekaton2.jpg\" \/><\/a><\/p>\n<ul>\n<li>native compilation: this proc is natively compiled<\/li>\n<li>schemabinding: native proc should be schema-bounds<\/li>\n<li>execute as owner: execution contect is required: don&#8217;t wan&#8217;t to take care about permission each time this proc is running<\/li>\n<li>begin atomic: atomic block: the procedure is a block, you don&#8217;t need to take care about commit or rollback, it is done automaticaly<\/li>\n<li>transaction level&#8230; : session settings are fixed at create time<\/li>\n<\/ul>\n<p>Approximatively the same process will take place with Stored procedure:<\/p>\n<ul>\n<li>Create table DLL<\/li>\n<li>Query optimization<\/li>\n<li>Code generation and compilation<\/li>\n<li>Table DLL produced<\/li>\n<li>Table DLL loaded in memory<\/li>\n<\/ul>\n<p>Stored procedures are not anymore interpreted, but converted to a C program, compiled with a C compiler to create a DLL which will be directly running in machine code. This new kind of Stored Procedure is calling Native Stored Procedure.<\/p>\n<h3>Conclusion<\/h3>\n<p>For the moment there is some limitation with the first version of SQL Server 2014 CTP1:<\/p>\n<ul>\n<li>row limitation to 8060 bites<\/li>\n<li>no varchar(max) object<\/li>\n<li>no DML Triggers<\/li>\n<li>not possible with AlwaysOn(for CTP2)<\/li>\n<\/ul>\n<p>But this is really an impressive feature that I will test quickly. The very good point is that you don&#8217;t have to rewrite your application or change your hardware to see your performance increase 10- to 30-fold in the best scenario.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I&#8217;m beginning with the SQL Server In-Memory OLTP project &#8220;Hekaton&#8221;! Microsoft has been working for four years on this new technology which will [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":3161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[49,385,52],"type_dbi":[],"class_list":["post-3160","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-microsoft","tag-oltp","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: In-memory OLTP project &quot;Hekaton&quot; - dbi Blog<\/title>\n<meta name=\"description\" content=\"I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I&#039;m beginning with the SQL Server In-Memory OLTP project &quot;Hekaton&quot;! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.\" \/>\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-in-memory-oltp-project-qhekatonq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014: In-memory OLTP project &quot;Hekaton&quot;\" \/>\n<meta property=\"og:description\" content=\"I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I&#039;m beginning with the SQL Server In-Memory OLTP project &quot;Hekaton&quot;! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-06-25T00:09: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_InMemory.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"206\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Savorgnano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Savorgnano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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-in-memory-oltp-project-qhekatonq\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"SQL Server 2014: In-memory OLTP project &#8220;Hekaton&#8221;\",\"datePublished\":\"2013-06-25T00:09:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/\"},\"wordCount\":652,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg\",\"keywords\":[\"Microsoft\",\"OLTP\",\"SQL Server 2014\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/\",\"name\":\"SQL Server 2014: In-memory OLTP project \\\"Hekaton\\\" - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg\",\"datePublished\":\"2013-06-25T00:09:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I'm beginning with the SQL Server In-Memory OLTP project \\\"Hekaton\\\"! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg\",\"width\":206,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014: In-memory OLTP project &#8220;Hekaton&#8221;\"}]},{\"@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\/b6bce7d75118b35bdb3b439ad6a9ca3c\",\"name\":\"St\u00e9phane Savorgnano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Savorgnano\"},\"description\":\"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2014: In-memory OLTP project \"Hekaton\" - dbi Blog","description":"I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I'm beginning with the SQL Server In-Memory OLTP project \"Hekaton\"! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.","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-in-memory-oltp-project-qhekatonq\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014: In-memory OLTP project \"Hekaton\"","og_description":"I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I'm beginning with the SQL Server In-Memory OLTP project \"Hekaton\"! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/","og_site_name":"dbi Blog","article_published_time":"2013-06-25T00:09:00+00:00","og_image":[{"width":206,"height":273,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"SQL Server 2014: In-memory OLTP project &#8220;Hekaton&#8221;","datePublished":"2013-06-25T00:09:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/"},"wordCount":652,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg","keywords":["Microsoft","OLTP","SQL Server 2014"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/","name":"SQL Server 2014: In-memory OLTP project \"Hekaton\" - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg","datePublished":"2013-06-25T00:09:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"I have the chance to be during this week in Madrid to participate in the TechEd Europe 2013. I will give you a feedback of my best sessions along this week and I'm beginning with the SQL Server In-Memory OLTP project \"Hekaton\"! Microsoft has been working for four years on this new technology which will come with SQL Server 2014.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_InMemory.jpg","width":206,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2014-in-memory-oltp-project-qhekatonq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014: In-memory OLTP project &#8220;Hekaton&#8221;"}]},{"@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\/b6bce7d75118b35bdb3b439ad6a9ca3c","name":"St\u00e9phane Savorgnano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/88d2a790f775c52c1012ec644d883431da758f2cbcfc16067ade04d2ef625ef5?s=96&d=mm&r=g","caption":"St\u00e9phane Savorgnano"},"description":"St\u00e9phane Savorgnano has more than fifteen years of experience in Microsoft software development and in SQL Server database solutions. He is specialized in SQL Server installation, performance analysis, best practices, etc. St\u00e9phane Savorgnano is Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. Prior to joining dbi services, he was software engineer at Ciba Specialty Chemicals in Basel. St\u00e9phane Savorgnano holds a Master of Informatics from Mulhouse University (F). His branch-related experience covers Banking \/ Financial Services, Chemicals &amp; Pharmaceuticals, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-savorgnano\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3160","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\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3160"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3160\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3161"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3160"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}