{"id":35018,"date":"2024-10-14T06:59:46","date_gmt":"2024-10-14T04:59:46","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=35018"},"modified":"2024-10-14T06:59:48","modified_gmt":"2024-10-14T04:59:48","slug":"sql-konferenz-2024-sql-server-stuff-and-ai","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/","title":{"rendered":"SQL Konferenz 2024 &#8211; SQL Server stuff and AI"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"412\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg\" alt=\"\" class=\"wp-image-35045\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg 320w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo-233x300.jpg 233w\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><\/figure>\n<\/div>\n\n\n<p>I had the opportunity to participate the SQL Server conference event (<a href=\"https:\/\/sqlkonferenz.de\/\">SQL KONFERENZ 2024<\/a>) with my collegue Nathan Courtine.<br>Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI).<\/p>\n\n\n\n<p>For me, it was a great pleasure to see all those guys \u2013 from which I read books, read blogs and hung around within many video-sessions late at night \u2013 now live on stage! Those are great people from the SQL Server community. Some of them I\u2019ve listed here in alphabetic order:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bob Ward<\/li>\n\n\n\n<li>Daniel Hutmacher<\/li>\n\n\n\n<li>Enrico van der Laar<\/li>\n\n\n\n<li>Erland Sommarskog<\/li>\n\n\n\n<li>Grant Fritchey<\/li>\n\n\n\n<li>Hugo Kornelis<\/li>\n\n\n\n<li>Joey D\u2019Antoni<\/li>\n<\/ul>\n\n\n\n<p>They were really great, especially <strong>Bob Ward<\/strong> (as he is a fantastic entertainer with an enormous presence on stage). Bob Ward was talking about AI-Support within Azure and GitHub and showed the capabilities of \u201cCopilot\u201d when we are working with Azure SQL Database. \u201cCopilot\u201d is actually in preview and available for free. Microsoft begs for feedback from customer so that they can continue to train and improve the product \u2013 see the blog from Nathan Courtine as he went into details in this topic <a href=\"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-microsoft-copilots\/\">dbi Blog (dbi-services.com)<\/a><br>\u201cCopilot\u201d is now part of the azure portal:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"35\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot-1024x35.jpg\" alt=\"\" class=\"wp-image-35046\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot-1024x35.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot-300x10.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot-768x26.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot.jpg 1317w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"760\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot_1.jpg\" alt=\"\" class=\"wp-image-35047\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot_1.jpg 680w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot_1-268x300.jpg 268w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<p>Here the small communication box which provides big output &#8211; the portal to another dimension:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"147\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot_2.jpg\" alt=\"\" class=\"wp-image-35049\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot_2.jpg 680w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Copilot_2-300x65.jpg 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<p>I will definitely look into this tool (can we still speak of a tool here at all&#8230;?) to see how well AI works in this context and what it\u2019s possible to reach with it.<\/p>\n\n\n\n<p><strong>Daniel Hutmacher<\/strong> talked about an old, yet highly topical subject in SQL Server \u2013 A C I D. He walked through the different isolation levels and showed the behaviour of concurrent transactions and the influence of each one of them.<br>Well known stuff, smart guy, great session!<\/p>\n\n\n\n<p><strong>Enrico van der Laar<\/strong> has written one of the greatest books from my point of view: SQL Server 2012 Wait Statistics (now available also for 2022 of course). This book inspired me back in the early days to do SQL Server Performance Tuning with Wait Stats. I don&#8217;t use this as my only tool, but I do use Wait Stats as one of many arrows I have in my quiver.<br>I was afraid that Enrico van der Laar a) did a session with another guy together about \u201cCrazy Data Science\u201d and b) just in this time slot a session from Matt Gordon took place, in which he talked about the migration steps and concerns to move data von OnPrem to the cloud.<br>I chose the session from Matt Gorden because \u2013 as an Azure Solution Architect \u2013 I\u2019m also very interested in topics around the cloud.<br><strong>Matt Gorden<\/strong> did a great job. He pointed out that in cloud migration projects (as he has already accompanied many projects of this kind) communication between all involved teams and proper testing are the main success factors.<\/p>\n\n\n\n<p><strong>Grant Fritchey<\/strong> had \u2013 for whatever reasons \u2013 only a 20 minutes session in which he explained the keypoints for a successful database devops circle.<br>Short, hairy (he\u2019s wearing an increadable beard), great as always!<\/p>\n\n\n\n<p><strong>Hugo Kornelis<\/strong> did a session about reading the execution plan.<br>Maybe you tend to say: \u201cOk, reading an execution plan is no rocket science Roger, wright? As a DBA and SQL Server consultant you should be able to get light on its feet into it\u2026\u201d<br>Yes, that\u2019s true, but Hugo Kornelis pointed out some pitfalls when we are interpreting those patchwork of JOIN-Operators, Warnings, Seeks and Scans, Table Spools, Stream Aggregates and so on and so forth\u2026 which are misleading you to wrong assumptions.<br>For example, the costs relative to the batch, which shows \u2013 even we are dealing with the actual execution plan \u2013 only the estimates:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/ExecutionPlans-1024x683.jpg\" alt=\"\" class=\"wp-image-35056\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/ExecutionPlans-1024x683.jpg 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/ExecutionPlans-300x200.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/ExecutionPlans-768x512.jpg 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/ExecutionPlans.jpg 1180w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Joey D\u2019Antoni<\/strong> took us with him on a cloud journey. He spoke about the security concept in Azure.<br>Conditional Access, PIM, Access Reviews, Management Groups, Managed Identities, IAM, RBAC, Contributor etc. \u2013 he guided us through all these topics with some explanations.<br>However, it was only a high flight altitude without comments and experience reports. From my point of view a great pity, I would have expected more from such an experienced man\u2026<\/p>\n\n\n\n<p>But beyond this, there was a guy I didn\u2019t no so far. His name is <strong>Mladen Prajdic<\/strong>. He is an MVP from Slovenia.<br>His session at this conference was not directly related to SQL Server \u2013 he spoke about Social Engineering and how to hack people \u2013 but was extremely exciting.<br>As I mentioned, I\u2019m interested in Security as well and looking at this topic on a completely different level was very pleasant for me. He pointed out, that every human being is vulnerable and under given circumstances open in a way, that he or she is willing to share personal information.<br>Mladen Pjajdic explained, that when you are sitting in a bar, and after a while a beautiful woman sits down next to you and starts flirting with you (if you are a man and admire beautiful women like I do) this would be in most of the cases a social attack to figure out who you are and collect information about you to do further nasty things. So hmmm, maybe I was hacked a week ago while I thought she really wanted something from me&#8230; well, life is not always sunny \ud83d\ude0a<\/p>\n\n\n\n<p><strong>Erland Sommarskog<\/strong> (as he is a wandering encyclopaedia of flesh and blood when it comes to topics like SQL Server Collation) had an amazing, impressive speech about a topic which is well known, but somehow very opaque and confusing for many people.<br>He mentioned, what kind of collation and codepages produces what kind of side effects in what circumstances. In his home country Sweden for example, a \u201cV\u201d is the same as a \u201cW\u201d &#8211; is this also the case in other countries&#8230;? Of course not! So this can lead to unexpected SORT or JOIN results if you are dealing with the wrong Collation. Furthermore he pointed out, that there can be Collation conflicts when you are joining TempTables and Usertables if Server- and Database Collations are not inline, which then has to be fixed within the code as an unnecessary extra workload. Below, you&#8217;ll find a little example of it.<br>First of all, let\u2019s check the Server Collation:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"227\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_1.jpg\" alt=\"\" class=\"wp-image-35051\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_1.jpg 610w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_1-300x112.jpg 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\n\n\n\n<p>Then we will create a database with a different Collation than the Server has, create a table and fill in some date:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"672\" height=\"488\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_2.jpg\" alt=\"\" class=\"wp-image-35052\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_2.jpg 672w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_2-300x218.jpg 300w\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" \/><\/figure>\n\n\n\n<p>If we try to JOIN now the Usertable \u201cPlace\u201d with the TempTable \u201cPlace\u201d we will get the mentioned Collation conflict:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"887\" height=\"272\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_3.jpg\" alt=\"\" class=\"wp-image-35053\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_3.jpg 887w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_3-300x92.jpg 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_3-768x236.jpg 768w\" sizes=\"auto, (max-width: 887px) 100vw, 887px\" \/><\/figure>\n\n\n\n<p>To resolve this conflict, we have to do this code change at the TempTable side using COLLATE:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"253\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_4.jpg\" alt=\"\" class=\"wp-image-35054\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_4.jpg 652w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Collation_4-300x116.jpg 300w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<p>From this conference I take with me several ideas and tips to increase the knowledge in SQL Server to be able to better support my customers during consulting and topics to dive into deeper new technologies as well as topics around cloud and AI.<\/p>\n\n\n\n<p>Thanks to dbi-services to let me follow these type of event!<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI). For me, it was a great pleasure to see all those [&hellip;]<\/p>\n","protected":false},"author":138,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[99],"tags":[3419,3423],"type_dbi":[],"class_list":["post-35018","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-copilot","tag-sql-konferenz"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Konferenz 2024 - SQL Server stuff and AI - 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\/sql-konferenz-2024-sql-server-stuff-and-ai\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Konferenz 2024 - SQL Server stuff and AI\" \/>\n<meta property=\"og:description\" content=\"I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI). For me, it was a great pleasure to see all those [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-14T04:59:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-14T04:59:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"320\" \/>\n\t<meta property=\"og:image:height\" content=\"412\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Roger Sch\u00f6nmann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Roger Sch\u00f6nmann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 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-konferenz-2024-sql-server-stuff-and-ai\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/\"},\"author\":{\"name\":\"Roger Sch\u00f6nmann\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/fd2a9801ad83d36521b3af1428abc2c6\"},\"headline\":\"SQL Konferenz 2024 &#8211; SQL Server stuff and AI\",\"datePublished\":\"2024-10-14T04:59:46+00:00\",\"dateModified\":\"2024-10-14T04:59:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/\"},\"wordCount\":1173,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/10\\\/Logo.jpg\",\"keywords\":[\"Copilot\",\"SQL Konferenz\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/\",\"name\":\"SQL Konferenz 2024 - SQL Server stuff and AI - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/10\\\/Logo.jpg\",\"datePublished\":\"2024-10-14T04:59:46+00:00\",\"dateModified\":\"2024-10-14T04:59:48+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/fd2a9801ad83d36521b3af1428abc2c6\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/10\\\/Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/10\\\/Logo.jpg\",\"width\":320,\"height\":412},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/sql-konferenz-2024-sql-server-stuff-and-ai\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Konferenz 2024 &#8211; SQL Server stuff and AI\"}]},{\"@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\\\/fd2a9801ad83d36521b3af1428abc2c6\",\"name\":\"Roger Sch\u00f6nmann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c887ebbff56054cbf9c1ca629a82c4821d58f8eaac23147702bbd5254d642fc6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c887ebbff56054cbf9c1ca629a82c4821d58f8eaac23147702bbd5254d642fc6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c887ebbff56054cbf9c1ca629a82c4821d58f8eaac23147702bbd5254d642fc6?s=96&d=mm&r=g\",\"caption\":\"Roger Sch\u00f6nmann\"},\"honorificPrefix\":\"Mr\",\"gender\":\"male\",\"knowsLanguage\":[\"German\",\"English\",\"French\",\"Italian\"],\"jobTitle\":\"Senior SQL Server Consultant\",\"worksFor\":\"Roger Sch\u00f6nmann\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/rogerschonmann\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Konferenz 2024 - SQL Server stuff and AI - 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\/sql-konferenz-2024-sql-server-stuff-and-ai\/","og_locale":"en_US","og_type":"article","og_title":"SQL Konferenz 2024 - SQL Server stuff and AI","og_description":"I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI). For me, it was a great pleasure to see all those [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/","og_site_name":"dbi Blog","article_published_time":"2024-10-14T04:59:46+00:00","article_modified_time":"2024-10-14T04:59:48+00:00","og_image":[{"width":320,"height":412,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg","type":"image\/jpeg"}],"author":"Roger Sch\u00f6nmann","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Roger Sch\u00f6nmann","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/"},"author":{"name":"Roger Sch\u00f6nmann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2a9801ad83d36521b3af1428abc2c6"},"headline":"SQL Konferenz 2024 &#8211; SQL Server stuff and AI","datePublished":"2024-10-14T04:59:46+00:00","dateModified":"2024-10-14T04:59:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/"},"wordCount":1173,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg","keywords":["Copilot","SQL Konferenz"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/","name":"SQL Konferenz 2024 - SQL Server stuff and AI - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg","datePublished":"2024-10-14T04:59:46+00:00","dateModified":"2024-10-14T04:59:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/fd2a9801ad83d36521b3af1428abc2c6"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/10\/Logo.jpg","width":320,"height":412},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-konferenz-2024-sql-server-stuff-and-ai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Konferenz 2024 &#8211; SQL Server stuff and AI"}]},{"@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\/fd2a9801ad83d36521b3af1428abc2c6","name":"Roger Sch\u00f6nmann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c887ebbff56054cbf9c1ca629a82c4821d58f8eaac23147702bbd5254d642fc6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c887ebbff56054cbf9c1ca629a82c4821d58f8eaac23147702bbd5254d642fc6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c887ebbff56054cbf9c1ca629a82c4821d58f8eaac23147702bbd5254d642fc6?s=96&d=mm&r=g","caption":"Roger Sch\u00f6nmann"},"honorificPrefix":"Mr","gender":"male","knowsLanguage":["German","English","French","Italian"],"jobTitle":"Senior SQL Server Consultant","worksFor":"Roger Sch\u00f6nmann","url":"https:\/\/www.dbi-services.com\/blog\/author\/rogerschonmann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35018","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\/138"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=35018"}],"version-history":[{"count":9,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35018\/revisions"}],"predecessor-version":[{"id":35221,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/35018\/revisions\/35221"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=35018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=35018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=35018"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=35018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}