{"id":3166,"date":"2013-07-01T07:44:00","date_gmt":"2013-07-01T05:44:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/"},"modified":"2013-07-01T07:44:00","modified_gmt":"2013-07-01T05:44:00","slug":"microsoft-teched-madrid-day-2","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/","title":{"rendered":"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and 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_TechEd.jpg\" alt=\"\" \/><\/p>\n<p>Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.<\/p>\n<p>There are 3 three different ways to run SQL:<\/p>\n<ul>\n<li>Physical machine\n<ul>\n<li>can be scale-up<\/li>\n<li>full control<\/li>\n<li>roll your own HA\/DR scale<\/li>\n<\/ul>\n<\/li>\n<li>Virtualized machine\n<ul>\n<li>100% of API Virtualized<\/li>\n<li>roll your own HA\/DR scale<\/li>\n<\/ul>\n<\/li>\n<li>Virtualized Database\n<ul>\n<li>auto HA fault tolerance<\/li>\n<li>friction free-scale<\/li>\n<li>self-provisioning management and scale<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>The problem is to find the good balance between dedicated\/shared resource and high\/lower Friction or Control.<br \/>\nTaking one of these ways depends on your applications and needs. The older an application is, the more difficult it is too optimize it so we will scale up the machine to boost performance.<\/p>\n<p>It&#8217;s good when you have just one major application working on a machine but if you have lot of application on this machine it will be difficult to buy scale-up all or it will cost a lot. In this case the best scenario should be to go for VM.<\/p>\n<p>Lots of companies have said that you do not have the right to buy new hardware&#8230; they want to push you to the virtualized world.<br \/>\nAlso if you need lots of databases with a short life cycle you can also virtualize the databases, it will be cheaper and will provide an easy way to create and delete each database.<br \/>\nWe have the possibility to virtualize, which is really cost saving.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog1.jpg\" alt=\"b2ap3_thumbnail_blog1.jpg\" \/><\/a><\/p>\n<p>Best practices:<\/p>\n<ul>\n<li>\u00a0instrument your application: easier to know if you have a problem and from where it is coming\n<ul>\n<li>use DMV to retrieve information periodically: You can automate a dmv execution each 5 minutes to monitor a problem<\/li>\n<li>Capture trace to XML file for monitoring trends you need and want check<\/li>\n<\/ul>\n<\/li>\n<li>automate, automate, and automate: the more you do it the more you can spend your time intelligently instead of searching for problems&#8230;<\/li>\n<li>minimize roundtrip: the less roundtrip you have the less problem you have\n<ul>\n<li>do one select instead of multiple selects<\/li>\n<li>batch updates should also be done in one time when it&#8217;s possible instead of sending multiple&#8230;<a title=\"blog2.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog2.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog2.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog2.jpg\" alt=\"b2ap3_thumbnail_blog2.jpg\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>take care to connection reliability: you have to manage that in your code\n<ul>\n<li>multiple commit<\/li>\n<li>safe reply<br \/>\n<a class=\"easyblog-thumb-preview\" title=\"blog3.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog3.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog3.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog3.jpg\" alt=\"b2ap3_thumbnail_blog3.jpg\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>This is a resume of this session, I hope it will help.<br \/>\nAnother very interesting session, done by Jos de Bruijn, was the SQL Server 2014 Futures and Features.<br \/>\nThis session was about all new features of SQL Server 2014. There was a spectacular demo using columnstore indexes and buffer pool extension.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog1_20130626-125414_1.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog1_20130626-125414_1.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog1_20130626-125414_1.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog1_20130626-125414_1.jpg\" alt=\"b2ap3_thumbnail_blog1_20130626-125414_1.jpg\" \/><\/a><\/p>\n<p>Mission critical performance<\/p>\n<ul>\n<li>In-memory Built-In: quickly obtain 10x speed performance &#8211; even 60x has been seen<\/li>\n<li>Secure &amp; scalable: most secure with enterprise scale with using windows server<\/li>\n<li>High Availability: AlwaysOn and Availability Group<\/li>\n<li>Mission Critical Support: Live support designed to mission critical solutions<\/li>\n<\/ul>\n<p>Here is a small picture:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog5.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog5.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog5.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog5.jpg\" alt=\"b2ap3_thumbnail_blog5.jpg\" \/><\/a><\/p>\n<p>As you can read above, columnstore indexes have been enhanced to be even more powerful.<br \/>\nColumnstore index put tables in readonly state before SQL Server 2014, now it will not be the case anymore.<br \/>\nSQL Server 2014 will also be able to take advantage of the new Windows Server 2012 R2 feature: the buffer pool extension to SSD drive.<br \/>\nWe saw an impressive demo based on a table with twelve millions rows which is queried to create a report. This report creation takes two minutes with a normal table.<\/p>\n<p>First, Jos added a nonclustered columnstore index based on all rows.<br \/>\nThe report with this nonclustered columnstore index takes 2 seconds to finish and the place used by the table is 300MB. With SQL Server 2014 we are now able to create a clustered columns store index. With a clustered columnstore index, the response is immediate and when you check the place taken by the table on the disk you see that initially the table took 400MB and now just 220MB.<\/p>\n<p>So it is not only very fast: it is also less place-consuming due to the fact that data is stored by rows instead of pages and also because of better performance compression mechanism.<\/p>\n<p>Afterwards, Jos showed us an interesting picture:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"blog4.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/99\/blog4.jpg\"><img decoding=\"async\" title=\"b2ap3_thumbnail_blog4.jpg\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_blog4.jpg\" alt=\"b2ap3_thumbnail_blog4.jpg\" \/><\/a><\/p>\n<p>Yes! You don&#8217;t dream: SQL Server is the most secure database since a long time. It is also for that reason that a number of clients have moved from Oracle to SQL Server!<\/p>\n<p>For scalability, a good point is that Resource Governor adds IO governance.<br \/>\nNow, for High Availability, we can have up to 8 secondary replicas, back-ups on secondary and you have a replica wizard to quickly create replicas.<\/p>\n<p>The Geoflow feature is also amazing when you see a worldwide travel drawn in a 3-dimensional earth. You can also create a small animation with a cursor to show moves per period of time&#8230;<\/p>\n<p>The platform for Hybrid Cloud has also been enhanced with<\/p>\n<ul>\n<li>Simplified Cloud backup\n<ul>\n<li>manual or automatic<\/li>\n<li>at an instance level with point in time restore<\/li>\n<\/ul>\n<\/li>\n<li>Cloud disaster recovery\n<ul>\n<li>Fast disaster recovery<\/li>\n<li>easy to deploy manage<\/li>\n<\/ul>\n<\/li>\n<li>Extend On-premise Apps<\/li>\n<\/ul>\n<p>Here is the new features which will come with SQL Server 2014. You are already able to download the CTP1 version <a href=\"http:\/\/technet.microsoft.com\/en-US\/evalcenter\/dn205290.aspx\">here<\/a>.<\/p>\n<p>Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on [&hellip;]<\/p>\n","protected":false},"author":21,"featured_media":3167,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[48],"tags":[280,51,54],"type_dbi":[],"class_list":["post-3166","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology-survey","tag-database","tag-sql-server","tag-sql-server-2012"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features - dbi Blog<\/title>\n<meta name=\"description\" content=\"Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.\" \/>\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\/microsoft-teched-madrid-day-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features\" \/>\n<meta property=\"og:description\" content=\"Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-01T05:44: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_TechEd.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"220\" \/>\n\t<meta property=\"og:image:height\" content=\"95\" \/>\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=\"4 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\\\/microsoft-teched-madrid-day-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/\"},\"author\":{\"name\":\"St\u00e9phane Savorgnano\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"headline\":\"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features\",\"datePublished\":\"2013-07-01T05:44:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/\"},\"wordCount\":876,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_TechEd.jpg\",\"keywords\":[\"database\",\"SQL Server\",\"SQL Server 2012\"],\"articleSection\":[\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/\",\"name\":\"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_TechEd.jpg\",\"datePublished\":\"2013-07-01T05:44:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/b6bce7d75118b35bdb3b439ad6a9ca3c\"},\"description\":\"Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_TechEd.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/2e1ax_default_entry_TechEd.jpg\",\"width\":220,\"height\":95},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/microsoft-teched-madrid-day-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and 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\\\/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":"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features - dbi Blog","description":"Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.","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\/microsoft-teched-madrid-day-2\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features","og_description":"Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.","og_url":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/","og_site_name":"dbi Blog","article_published_time":"2013-07-01T05:44:00+00:00","og_image":[{"width":220,"height":95,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_TechEd.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Savorgnano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Savorgnano","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/"},"author":{"name":"St\u00e9phane Savorgnano","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"headline":"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features","datePublished":"2013-07-01T05:44:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/"},"wordCount":876,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_TechEd.jpg","keywords":["database","SQL Server","SQL Server 2012"],"articleSection":["Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/","url":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/","name":"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and Features - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_TechEd.jpg","datePublished":"2013-07-01T05:44:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/b6bce7d75118b35bdb3b439ad6a9ca3c"},"description":"Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternstr\u00f6m, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_TechEd.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_TechEd.jpg","width":220,"height":95},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/microsoft-teched-madrid-day-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft TechEd Madrid: Optimizing T-SQL &amp; SQL Server 2014 Futures and 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\/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\/3166","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=3166"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3166\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3167"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3166"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}