{"id":4343,"date":"2013-04-13T10:01:16","date_gmt":"2013-04-13T09:01:16","guid":{"rendered":"http:\/\/andreas-wolter.com\/conferences-2013-frankfurter-datenbanktage-und-einige-oracle-momente\/"},"modified":"2017-11-15T11:13:27","modified_gmt":"2017-11-15T10:13:27","slug":"conferences-2013-frankfurter-datenbanktage-and-oracle-moments","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/conferences-2013-frankfurter-datenbanktage-and-oracle-moments\/","title":{"rendered":"Conferences 2013: Frankfurt Database Days and a couple of \u201cOracle-Moments\u201d"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-bb4344aa903dbb55278a348e34216ffb\">\n#top .av-special-heading.av-av_heading-bb4344aa903dbb55278a348e34216ffb{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-bb4344aa903dbb55278a348e34216ffb .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-bb4344aa903dbb55278a348e34216ffb .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-bb4344aa903dbb55278a348e34216ffb 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\"  >Conferences 2013: Frankfurt Database Days and a couple of <span class='special_amp'>\u201c<\/span>Oracle-Moments<span class='special_amp'>\u201d<\/span><\/h3><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>I usually try to announce my conference participation in advance in order to give readers a chance to possibly plan them.<\/p>\n<p>Due to a severe lack of time and because I jumped in spontaneously for an absent speaker only a week before the conference, I didn\u2019t manage to give you a heads-up this time.<!--more--><\/p>\n<p>I had the pleasure of giving a presentation on \u201cHigh availability techniques with SQL Server 2012\u201d and also being interviewed on this topic.<\/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-8f53457a7bbba58623a58e33fb69c653\">\n.avia-image-container.av-av_image-8f53457a7bbba58623a58e33fb69c653 img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-8f53457a7bbba58623a58e33fb69c653 .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-8f53457a7bbba58623a58e33fb69c653 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-1057 avia-img-lazy-loading-not-1057 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2014\/10\/1304_FrankfurterDatenbanktage.png\" alt='' title='1304_FrankfurterDatenbanktage'  height=\"100\" width=\"244\"  itemprop=\"thumbnailUrl\"  \/><\/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>I would like to write about this year\u2019s (first) Frankfurt Database Days (next year\u2019s date is already set: 26-28 March 2014) in retrospect because I really like the concept with simultaneous Tracks &#038; Session on Oracle, DB2, MySQL, NoSQL and SQL Server.<\/p>\n<p>It is, for example, always interesting \u2013 but also a shame \u2013 to realize how unknown Snapshot Isolation &#038; RCSI is in SQL Server. It goes so far that in a session in which, in terms of the different database systems\u2019 abilities to write datasets and still simultaneously read a consistent state, the statement was made that only Oracle can do this. That is a shame.<\/p>\n<p>Because apart from the fact that this statement is not accurate \u2013 SQL Server offers 2 versions (the very Snapshot Isolation and Read Committed Snapshot Isolation) to which this applies just as well; the background knowledge that Microsoft gives the developers a choice between many different isolation levels, and why this concept is also better than having no choice (or at least to be fixated on only one in such a way that even Oracle Admins believe there was no choice), does not seem to be as widespread as one would hope.<\/p>\n<p>Another session, which I only read, almost shocked me, a security specialist for SQL Server: It may not be a secret (even if interestingly enough it tends to be ignored especially in the banking field) how vast the number of security gaps is in ORACLE (you can inform yourself at the \u201cNIST\u201d: <a href=\"http:\/\/nvd.nist.gov\/\" target=\"_blank\" rel=\"noopener\">nvd.nist.gov<\/a>), but to which extent one has to carry out a so-called security \u201ctoughening\u201d even without special consideration of these gaps in order to be <u>fairly<\/u> safe from the grossest gateways has quite surprised me after all \u2013 being used to \u201csecure by default\u201d since SQL Server 2005. \u2013 As \u201csoftly\u201d as possible, (session subtitle: \u201csoft toughening\u201d) so that afterwards everything will still be working \u2013 and we don\u2019t want to completely put off attackers now, do we? \ud83d\ude42 (P.S.: of course, it is understandable that one does not \u201cclose\u201d everything \u201cdown,\u201d and afterwards even the valid applications no longer work. The essence is: it is crucial to strike a balance that will at least reduce the vulnerability. And that is of course worth a lot in itself!) It might be good to know which of my data are thus \u201cprotected\u201d in Oracle-DBs\u2026 without malice \u2013 because the individual customer is mostly not to blame. \u2013 Only if he or she is informed and doesn\u2019t act accordingly (nor even take mitigating action).<\/p>\n<p>But to put it out there clearly, too: it is also possible to attack an SQL Server when applications or other connections are running with too many rights, service accounts are being shared, etc. Therefore, here again the two most important security principles: \u201cSeparation of duties\/roles\u201d and \u201cPrinciple of least privilege.\u201d So always separate duties\/roles (service accounts!) and always work with the lowest possible rights. And on top of this, an auditing so that you will know when you overlooked a path.<\/p>\n<p>And not least of all because of the possibility to experience such misunderstandings or comparisons live, or simply to get to know very different possibilities that also exist in other DBMS, I consider the Frankfurt Database Days an enrichment to the conference landscape.<\/p>\n<p>In fact, PASS Germany tries to include a small version of this mix also for the planned <a href=\"http:\/\/www.sqlsaturday.com\/230\/\" target=\"_blank\" rel=\"noopener\">SQLSaturday #230<\/a> in Rheinland, at which I will likely be present. I am curious to see what will come out of it and how it will be received.<\/p>\n<p>See you at the next conference maybe,<\/p>\n<p>Andreas<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-97c650ae075063b375f558a776c570f8\">\n#top .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n.flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n.responsive #top #wrap_all .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-97c650ae075063b375f558a776c570f8 av_one_full  avia-builder-el-4  el_after_av_textblock  el_before_av_hr  first flex_column_div av-zero-column-padding  column-top-margin'     ><section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><div><\/div>\n<div><\/div>\n<\/div><\/section><\/div>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-6  el_after_av_one_full  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-00566587b7355f5f3aec989679437938 av-social-sharing-box-default  avia-builder-el-7  el_after_av_hr  avia-builder-el-last  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Eintrag teilen<\/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\/conferences-2013-frankfurter-datenbanktage-and-oracle-moments\/&#038;t=Conferences%202013%3A%20Frankfurt%20Database%20Days%20and%20a%20couple%20of%20%E2%80%9COracle-Moments%E2%80%9D\" 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=Conferences%202013%3A%20Frankfurt%20Database%20Days%20and%20a%20couple%20of%20%E2%80%9COracle-Moments%E2%80%9D&#038;url=https:\/\/andreas-wolter.com\/en\/?p=4343\" 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=Conferences%202013%3A%20Frankfurt%20Database%20Days%20and%20a%20couple%20of%20%E2%80%9COracle-Moments%E2%80%9D&#038;url=https:\/\/andreas-wolter.com\/en\/conferences-2013-frankfurter-datenbanktage-and-oracle-moments\/\" 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>","protected":false},"excerpt":{"rendered":"I usually try to announce my conference participation in advance in order to give readers a chance to possibly plan them. Due to a severe lack of time and because I jumped in spontaneously for an absent speaker only a week before the conference, I didn\u2019t manage to give you a heads-up this time.","protected":false},"author":4,"featured_media":1057,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[97,42,127,57,64],"tags":[244,198,281,27,232],"class_list":["post-4343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conferences-en","category-locking-blocking","category-oracle","category-security-en","category-sqlpass-en","tag-konferenz-en","tag-locking_blocking-en","tag-oracle-en","tag-security-en","tag-sicherheit-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/4343","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=4343"}],"version-history":[{"count":5,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/4343\/revisions"}],"predecessor-version":[{"id":4490,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/4343\/revisions\/4490"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/1057"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=4343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=4343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=4343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}