{"id":19103,"date":"2022-09-21T14:46:56","date_gmt":"2022-09-21T12:46:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=19103"},"modified":"2022-09-21T14:52:57","modified_gmt":"2022-09-21T12:52:57","slug":"data-platform-virtual-summit-2022-day-3","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/","title":{"rendered":"Data Platform Virtual Summit 2022 &#8211;\u00a0 Day 3"},"content":{"rendered":"\n<p>Today the Data Platform Virtual Summit begin at 06:00 am for us\u2026<br>It\u2019s in our time offset, this time better to wake up! \ud83d\ude09<\/p>\n\n\n\n<p>My schedule for the day:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>D3B1 &#8211; KATMAI &#8211; SQL MI on Kubernetes &#8211; Intermediate &#8211; Dhananjay Mahajan<\/li><li>D3B2 &#8211; KATMAI &#8211; Extent and Page Management in Microsoft SQL Server &#8211; Expert &#8211; Torsten Strau\u00df<\/li><li>D3B3 &#8211; SPHINX &#8211; SQL Server on Linux &amp; Kubernetes! &#8211; From Zero to Hero &#8211; Intermediate &#8211; Tejas Shah &amp; Amit Khandelwal<\/li><li>D3B4 &#8211; SPHINX- How to model and partition data in Azure Cosmos DB to achieve cloud scale &#8211; Intermediate &#8211; Richa Gaur<\/li><li>D3B5 &#8211; HYDRA- Deadlocks \u2013 Analysing, Preventing and Mitigating &#8211; Advanced &#8211; Erland Sommarskog<\/li><li>D3B6 &#8211; SHILOH &#8211; Performance tuning for Azure Cosmos DB &#8211; Intermediate &#8211; Hasan Savran<\/li><li>D3B7 &#8211; HYDRA &#8211; My Favourite New T-SQL in SQL Server 2022&nbsp; &#8211; Intermediate &#8211; Edward Pollack<\/li><li>D3B8 &#8211; KATMAI &#8211; Data Ingestion on Azure: Real-life scenarios and solutions &#8211; Intermediate &#8211; Dustin Vannoy<\/li><\/ul>\n\n\n\n<p>I will begin with the session <strong>SQL Server on Linux &amp; Kubernetes! &#8211; From Zero to Hero <\/strong>from Tejas Shah &amp; Amit Khandelwal because it\u2019s not every day that we work on Linux with SQL Server. I good agenda in perspective:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"403\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png\" alt=\"\" class=\"wp-image-19104\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78-300x129.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78-768x330.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p>We have in Azure already images to create our SQL Server on Linux in Azure:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"501\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-79.png\" alt=\"\" class=\"wp-image-19105\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-79.png 938w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-79-300x160.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-79-768x410.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p>You don\u2019t need to install SQL Server, it\u2019s already there and created in few minutes\u2026<\/p>\n\n\n\n<p>It\u2019s also good to see a remember of the Best Practice for SQL Server VMs:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"524\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-80.png\" alt=\"\" class=\"wp-image-19106\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-80.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-80-300x167.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-80-768x428.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>Forced-Unit-Access is one of the most important configuration to keep in mind and to enable to have good performance.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"497\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-81.png\" alt=\"\" class=\"wp-image-19107\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-81.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-81-300x159.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-81-768x406.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>A good summary to have good performance on Linux with SQL Server<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"496\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-82.png\" alt=\"\" class=\"wp-image-19108\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-82.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-82-300x158.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-82-768x405.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>After the presentation of the installation though Kubernetes, I great demo for the HA<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"400\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-83.png\" alt=\"\" class=\"wp-image-19109\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-83.png 938w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-83-300x128.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-83-768x328.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"475\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-84.png\" alt=\"\" class=\"wp-image-19110\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-84.png 939w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-84-300x152.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-84-768x388.png 768w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure>\n\n\n\n<p>It was a very interesting session.<\/p>\n\n\n\n<p>Now, go to the next one&#8230;<\/p>\n\n\n\n<p>I follow the session of &nbsp;Edward Pollack named &nbsp;<strong>My Favourite New T-SQL in SQL Server<\/strong><\/p>\n\n\n\n<p>On this session I discover a lot of new T-SQL to have better quality of the code:<\/p>\n\n\n\n<p>The first T-SQL is \u201c<strong>IS DISTINCT FROM \/ IS NOT DISTINCT FROM<\/strong>\u201d very useful to use and can replace = and &lt;&gt; but include null (this is the good point). I will write soon a blog on it.<\/p>\n\n\n\n<p>The second is &nbsp;<strong>APPROX_PERCENTILE_<\/strong>xxx where is already used in SQL 2019 for APPROX_COUNT_DISTINCT but extend on SQL Server 2022<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"474\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-85.png\" alt=\"\" class=\"wp-image-19111\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-85.png 938w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-85-300x152.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-85-768x388.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p>The next one is the <strong>DateTrunc()<\/strong> to rounds\/truncates a date\/datetime and can be use in order by and order by<\/p>\n\n\n\n<p>Some new bit manipulation to be useful if you need to manipulate it<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"576\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-86.png\" alt=\"\" class=\"wp-image-19112\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-86.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-86-300x184.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-86-768x471.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>The <strong>Greatest()<\/strong> and the <strong>Least()<\/strong> return the largest or smallest value from any number of expressions.<\/p>\n\n\n\n<p>A great demo to illustrate it with dates to find the first and the last date of modification:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"400\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-87.png\" alt=\"\" class=\"wp-image-19113\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-87.png 938w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-87-300x128.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-87-768x328.png 768w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p><strong>String_Split() <\/strong>to splits up a delimited string into its component elements.<\/p>\n\n\n\n<p><strong>Date_Bucket()<\/strong> returns a rounded date\/time based on a given date part:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"658\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-88.png\" alt=\"\" class=\"wp-image-19114\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-88.png 940w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-88-300x210.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-88-768x538.png 768w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p>This can be very useful to use for date aggregation and group dates.<\/p>\n\n\n\n<p><strong>Generate_ series() <\/strong>builds a number series based on a set of parameters<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"759\" height=\"500\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-89.png\" alt=\"\" class=\"wp-image-19115\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-89.png 759w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-89-300x198.png 300w\" sizes=\"auto, (max-width: 759px) 100vw, 759px\" \/><\/figure>\n\n\n\n<p><strong>Window <\/strong>allows a window function over clause to be reuse and simplify the T-SQL code.<\/p>\n\n\n\n<p><strong>First_value() <\/strong>and <strong>Last_Value()<\/strong> are very useful and return the first or last value for a column over an ordered window<\/p>\n\n\n\n<p>This last session gives me the desire to test some of this new T-SQL commands and blog about it! \ud83d\ude09<\/p>\n\n\n\n<p>See you tomorrow again for this great event with a lot of interesting sessions<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today the Data Platform Virtual Summit begin at 06:00 am for us\u2026It\u2019s in our time offset, this time better to wake up! \ud83d\ude09 My schedule for the day: D3B1 &#8211; KATMAI &#8211; SQL MI on Kubernetes &#8211; Intermediate &#8211; Dhananjay Mahajan D3B2 &#8211; KATMAI &#8211; Extent and Page Management in Microsoft SQL Server &#8211; Expert [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,99,48],"tags":[1338,2550],"type_dbi":[],"class_list":["post-19103","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-sql-server","category-technology-survey","tag-azure","tag-sql-server-2"],"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>Data Platform Virtual Summit 2022 -\u00a0 Day 3 - dbi 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.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Platform Virtual Summit 2022 -\u00a0 Day 3\" \/>\n<meta property=\"og:description\" content=\"Today the Data Platform Virtual Summit begin at 06:00 am for us\u2026It\u2019s in our time offset, this time better to wake up! \ud83d\ude09 My schedule for the day: D3B1 &#8211; KATMAI &#8211; SQL MI on Kubernetes &#8211; Intermediate &#8211; Dhananjay Mahajan D3B2 &#8211; KATMAI &#8211; Extent and Page Management in Microsoft SQL Server &#8211; Expert [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-21T12:46:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-21T12:52:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\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 Haby\" \/>\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\/data-platform-virtual-summit-2022-day-3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Data Platform Virtual Summit 2022 &#8211;\u00a0 Day 3\",\"datePublished\":\"2022-09-21T12:46:56+00:00\",\"dateModified\":\"2022-09-21T12:52:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\"},\"wordCount\":610,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png\",\"keywords\":[\"Azure\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"SQL Server\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\",\"name\":\"Data Platform Virtual Summit 2022 -\u00a0 Day 3 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png\",\"datePublished\":\"2022-09-21T12:46:56+00:00\",\"dateModified\":\"2022-09-21T12:52:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png\",\"width\":939,\"height\":403},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Platform Virtual Summit 2022 &#8211;\u00a0 Day 3\"}]},{\"@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\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as 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. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Platform Virtual Summit 2022 -\u00a0 Day 3 - dbi 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.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/","og_locale":"en_US","og_type":"article","og_title":"Data Platform Virtual Summit 2022 -\u00a0 Day 3","og_description":"Today the Data Platform Virtual Summit begin at 06:00 am for us\u2026It\u2019s in our time offset, this time better to wake up! \ud83d\ude09 My schedule for the day: D3B1 &#8211; KATMAI &#8211; SQL MI on Kubernetes &#8211; Intermediate &#8211; Dhananjay Mahajan D3B2 &#8211; KATMAI &#8211; Extent and Page Management in Microsoft SQL Server &#8211; Expert [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/","og_site_name":"dbi Blog","article_published_time":"2022-09-21T12:46:56+00:00","article_modified_time":"2022-09-21T12:52:57+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png","type":"","width":"","height":""}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Data Platform Virtual Summit 2022 &#8211;\u00a0 Day 3","datePublished":"2022-09-21T12:46:56+00:00","dateModified":"2022-09-21T12:52:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/"},"wordCount":610,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png","keywords":["Azure","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","SQL Server","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/","url":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/","name":"Data Platform Virtual Summit 2022 -\u00a0 Day 3 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png","datePublished":"2022-09-21T12:46:56+00:00","dateModified":"2022-09-21T12:52:57+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/09\/image-78.png","width":939,"height":403},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/data-platform-virtual-summit-2022-day-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Data Platform Virtual Summit 2022 &#8211;\u00a0 Day 3"}]},{"@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\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as 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. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19103","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=19103"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19103\/revisions"}],"predecessor-version":[{"id":19117,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/19103\/revisions\/19117"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=19103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=19103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=19103"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=19103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}