{"id":3133,"date":"2013-03-20T16:32:17","date_gmt":"2013-03-20T15:32:17","guid":{"rendered":"http:\/\/andreas-wolter.com\/sql-server-master-class-seminare-fuer-alle-die-es-genau-wissen-wollen\/"},"modified":"2017-10-10T12:43:56","modified_gmt":"2017-10-10T11:43:56","slug":"sql-server-master-class-seminars-for-all-those-who-want-to-know-exactly-whats-what","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/sql-server-master-class-seminars-for-all-those-who-want-to-know-exactly-whats-what\/","title":{"rendered":"SQL Server Master-Class Seminars \u2013 For all those who want to know exactly what\u2019s what \u2013 Starting in May with Extended Events"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-ea44785e5ff67cd4a72d1843e13e4ec5\">\n#top .av-special-heading.av-av_heading-ea44785e5ff67cd4a72d1843e13e4ec5{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-ea44785e5ff67cd4a72d1843e13e4ec5 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-ea44785e5ff67cd4a72d1843e13e4ec5 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-ea44785e5ff67cd4a72d1843e13e4ec5 av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >SQL Server Master-Class Seminars \u2013 For all those who want to know exactly what\u2019s what<\/h3><div class='av-subheading av-subheading_below'><p>\u2013 Starting in May with Extended Events<\/p>\n<\/div><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>My First Blog Post here is partly for my own cause, but on the other hand, it is for You and all those who are inquisitive and eager to learn in terms of SQL Server:<\/p>\n<p>I have often been asked if I wouldn\u2019t want to write a book sometime to share my knowledge, or to offer deep-dive seminars like some other colleagues in the US are doing.<!--more--><\/p>\n<p>Unfortunately, I do not have the time to write a book. A complete book would be keeping me from active practice too much \u2013 and practice is essential \u2013 particularly since there are always new things to learn.<\/p>\n<p>By contrast, seminars and presentations have a short cycle, results are immediately visible. Apart from the fact that I like sharing my knowledge I just enjoy this form of interaction.<\/p>\n<p>I have thought about and asked around among colleagues what other offers were lacking which I or others have seen and came to the following conclusion:<\/p>\n<ol>\n<li>Mere presentation with in fact deep-dive contents but hardly any chance to apply them in exercises on the spot (very typical of the USA, whether PreCon-\u201cWorkshops\u201d or seminars, they are rather always presentation-style and demos but no real \u201chands-on\u201d) \u2013 and after the training week one often lacks the time to practice.<\/li>\n<li>Many sets of themes within one or several weeks, not all of which one still needs, but which are part of the 5 days. \u2013 And these 5 days are completely blocked as a result.<\/li>\n<li>Far and thus expensive journey.<\/li>\n<\/ol>\n<p>And now the time has come: starting this summer, I am offering my own Deep-Dive training series, the \u201c<a href=\"http:\/\/www.insidesql.org\/blogs\/www.sarpedonqualitylab.com\/SQL_Master-Classes.htm\" target=\"_blank\" rel=\"noopener\">SQL Server Master-Classes<\/a>.\u201d<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-ad85f57fba08ccc655c9e7ae8bbf12e0\">\n.avia-image-container.av-av_image-ad85f57fba08ccc655c9e7ae8bbf12e0 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-ad85f57fba08ccc655c9e7ae8bbf12e0 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-ad85f57fba08ccc655c9e7ae8bbf12e0 av-styling- avia-align-center  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-3002 avia-img-lazy-loading-not-3002 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/Sarpedon_logo.jpg\" alt='' title='Sarpedon_logo'  height=\"63\" width=\"602\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/Sarpedon_logo.jpg 602w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/Sarpedon_logo-600x63.jpg 600w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/Sarpedon_logo-300x31.jpg 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/Sarpedon_logo-450x47.jpg 450w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>And what\u2019s different here?:<\/p>\n<ol>\n<li>Exercises and time for exercises is always included so that one can test right away what one has just learned. In the <em>SQL Server Master-Classes<\/em> that contain \u201cworkshop\u201d in their title, the practical content is about 40%.<\/li>\n<li><em>SQL Server Master-Classes<\/em> are 1 to max. 3-day events that cover one set of themes each. E.g. 1 day \u201cConcurrency\u201d with everything related to the topic Transaction Isolation, Locking &#038; Blocking, or 2 days \u201cIndexes, Statistics and Partitioning,\u201d because this topic cannot be covered in one day. However, both topics can be booked separately even though of course it all belongs to the topic \u201cPerformance.\u201d<\/li>\n<li>\u201cLearn from a Master\u201d \u2013 For one, these are the first open seminars offered on a regular basis with a Certified Master (MCM + MCT) as instructor <u>in and from Germany<\/u> &#8211;<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-3004\" src=\"http:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/10\/MicrosoftCertified_Master.png\" alt=\"\" width=\"153\" height=\"80\" \/>&#8211; and on the other hand, for the seminars taking in place in Frankfurt, train riders benefit from the absolute hit price of 99.00 Euros for the return-trip (Germany-wide). (For details, see website: <a href=\"http:\/\/www.sarpedonqualitylab.com\/SQL_Master-Classes.htm\" target=\"_blank\" rel=\"noopener\">www.sarpedonqualitylab.com\/SQL_Master-Classes.htm<\/a>)<\/li>\n<li>Just to make sure: the comparison with MOC course is not even attempted. Here, it is not only about Best Practices, but it is about learning what is behind all this so as to learn the BEST way rather than the \u201cgeneral best practice.\u201d<\/li>\n<li>Of course, the well-being is also looked after. The seminars take place in a high-quality location, and a lunch menu as well as coffee breaks with snacks (coffee, tea, cake etc.) and unlimited soft drinks are also included.<\/li>\n<\/ol>\n<p>And now turning to the content:<\/p>\n<p>The following sets of themes are currently being prepared:<\/p>\n<ul>\n<li>Workshop Tracing with Extended Events in SQL Server (1 day)<\/li>\n<li>Workshop Advanced Techniques for Tracing with Extended Events in SQL Server (1 day)<\/li>\n<li>Concurrency &#8211; Transactions, Isolation Level and Sperren (1 day)<\/li>\n<li>Indexes, Statistics and Partitioning (2 days)<\/li>\n<li>Optimization of Procedures and Functions (1 day)<\/li>\n<li>Performance and Analysis Techniques &#038; Tools + Workshop (2 days)<\/li>\n<li>Baselining &#038; Benchmarking (1 day)<\/li>\n<li>Security Workshops (Essentials, Deep-Dive for Developers, Deep-Dive for Administrators, 1 day each)<\/li>\n<li>Restoration Strategies and Techniques (1 day)<\/li>\n<li>Workshop High Availability (2 days)<\/li>\n<li>Beyond Relational with SQL Server &#8211; Filestream, FileTable, FullTextSearch, Geospatial (1 day)<\/li>\n<li>Workshop Replication (1 day)<\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>The new Master-Class series kicks off with XEvents:<\/p>\n<ul>\n<li>Workshop Tracing with Extended Events in SQL Server (1 day)\n<ul>\n<li>Frankfurt am Main, 17 May 2013<\/li>\n<\/ul>\n<\/li>\n<li>Workshop Advanced Techniques for Tracing with Extended Events in SQL Server (1 day)\n<ul>\n<li>Frankfurt am Main, 18 May 2013<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span style=\"text-decoration: line-through;\">The Super Early Bird is still on until 29 March, and the Early Bird is on until 22 April! <\/span>There are no longer spots available for the first date. That is why we have scheduled a 2<sup>nd<\/sup> date for the 13<sup>th<\/sup> and 14<sup>th<\/sup> of June. Registration is possible as of now (an Early Bird offer is also available again). Members of the PASS Deutschland e.V. get a 10% discount.<\/p>\n<p>You can find the current list and registration information here: <a href=\"http:\/\/www.sarpedonqualitylab.com\/SQL_Master-Classes.htm\" target=\"_blank\" rel=\"noopener\">www.sarpedonqualitylab.com\/SQL_Master-Classes.htm<\/a><\/p>\n<p>happy learning,<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-6  el_after_av_textblock  el_before_av_social_share '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-7  el_after_av_hr  el_before_av_comments_list  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share<\/h5><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook' ><a target=\"_blank\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https:\/\/andreas-wolter.com\/en\/sql-server-master-class-seminars-for-all-those-who-want-to-know-exactly-whats-what\/&#038;t=SQL%20Server%20Master-Class%20Seminars%20%E2%80%93%20For%20all%20those%20who%20want%20to%20know%20exactly%20what%E2%80%99s%20what%20%E2%80%93%20Starting%20in%20May%20with%20Extended%20Events\" aria-hidden=\"false\" data-av_icon=\"\ue8f3\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Facebook\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-twitter' ><a target=\"_blank\" aria-label=\"Share on Twitter\" href=\"https:\/\/twitter.com\/share?text=SQL%20Server%20Master-Class%20Seminars%20%E2%80%93%20For%20all%20those%20who%20want%20to%20know%20exactly%20what%E2%80%99s%20what%20%E2%80%93%20Starting%20in%20May%20with%20Extended%20Events&#038;url=https:\/\/andreas-wolter.com\/en\/?p=3133\" aria-hidden=\"false\" data-av_icon=\"\ue8f1\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Twitter\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Twitter<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=SQL%20Server%20Master-Class%20Seminars%20%E2%80%93%20For%20all%20those%20who%20want%20to%20know%20exactly%20what%E2%80%99s%20what%20%E2%80%93%20Starting%20in%20May%20with%20Extended%20Events&#038;url=https:\/\/andreas-wolter.com\/en\/sql-server-master-class-seminars-for-all-those-who-want-to-know-exactly-whats-what\/\" aria-hidden=\"false\" data-av_icon=\"\ue8fc\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on LinkedIn\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><\/ul><\/div><\/div>\r\n\r\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"My First Blog Post here is partly for my own cause, but on the other hand, it is for You and all those who are inquisitive and eager to learn in terms of SQL Server: I have often been asked if I wouldn\u2019t want to write a book sometime to share my knowledge, or to [&hellip;]","protected":false},"author":4,"featured_media":3002,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[119,55,66,64,56],"tags":[200,201,65,182],"class_list":["post-3133","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-certification-mcm-mcsm-mvp","category-extended-events-en","category-seminare","category-sqlpass-en","category-tracing-monitoring-en","tag-mcm_mcsm-en","tag-seminare-en","tag-sqlpass-en","tag-tracing-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/3133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=3133"}],"version-history":[{"count":2,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/3133\/revisions"}],"predecessor-version":[{"id":3136,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/3133\/revisions\/3136"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/3002"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=3133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=3133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=3133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}