{"id":16071,"date":"2024-09-24T17:34:50","date_gmt":"2024-09-24T15:34:50","guid":{"rendered":"https:\/\/www.oradba.ch\/wordpress\/?p=16071"},"modified":"2024-09-24T17:34:50","modified_gmt":"2024-09-24T15:34:50","slug":"its-a-wrap-soug-day-in-zurich-and-romandie","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2024\/09\/its-a-wrap-soug-day-in-zurich-and-romandie\/","title":{"rendered":"It\u2019s a Wrap: SOUG Day in Zurich and Romandie"},"content":{"rendered":"\n<p>The past few days have been an exciting time for Oracle database enthusiasts across Switzerland. The <a href=\"https:\/\/soug.ch\/\" target=\"_blank\" rel=\"noreferrer noopener\">Swiss Oracle User Group (SOUG)<\/a> organized two fantastic events: the larger SOUG Day in Zurich on September 20th, 2024, and a more intimate gathering in French-speaking Switzerland on September 24th, 2024. Both events attracted Oracle professionals from across the country, who came together to discuss the latest advancements in Oracle database security. I had the privilege of presenting on two key topics: the Oracle 23c SQL Firewall and innovative ideas on using AI to enhance database security.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>SOUG Day Z\u00fcrich: Oracle 23c SQL Firewall, here we go<\/strong><\/h2>\n\n\n\n<p>Oracle SQL Firewall is a recent addition to Oracle&#8217;s security toolkit, offering a new approach to database security. In this presentation, I introduced its rule-based data protection features, which give an extra layer of security within the database. The session included demonstrations and practical insights into how the SQL Firewall operates.<\/p>\n\n\n\n<p><strong>Highlights:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Introduction to Oracle 23c SQL Firewall and its unique rule-based protection<\/li>\n\n\n\n<li>Demonstrations of SQL Firewall&#8217;s functionality in securing user data<\/li>\n\n\n\n<li>Best practices for integrating SQL Firewall into broader security strategies<\/li>\n\n\n\n<li>Practical examples showing how SQL Firewall enhances security beyond traditional external database firewalls<\/li>\n<\/ul>\n\n\n\n<p>You can find the slides from the presentation <a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_Oehrli_DBFW_23ai_v1.pdf\">here<\/a>. More information about this SOUG event, including the agenda and slides, is available in the <a href=\"https:\/\/soug.ch\/event\/soug-day-zurich-2024\/\" target=\"_blank\" rel=\"noreferrer noopener\">SOUG event archive<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>SOUG Day Romandie: Oracle DB Security with the Use of AI<\/strong><\/h2>\n\n\n\n<p>In this session, I explored how AI, specifically GenAI and Natural Query Language Prompts, could be used as potential tools for evaluating Unified Audit data and other security-related information in Oracle databases. The presentation focused on the early stages of applying AI to database security, highlighting some new and promising approaches. While these techniques are still in development, they offer a solid starting point for improving security in cloud-based databases.<\/p>\n\n\n\n<p><strong>Highlights:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Introduction to AI-driven techniques as a first test for evaluating Unified Audit data and other security-related information in Oracle databases<\/li>\n\n\n\n<li>Demo of how GenAI and Natural Query Language Prompts could streamline security reporting<\/li>\n\n\n\n<li>Insights into the future potential of AI in Oracle database security<\/li>\n\n\n\n<li>A live prototype demonstration of AI integration for analyzing database security<\/li>\n<\/ul>\n\n\n\n<p>You can access the slides for this session <a href=\"https:\/\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_Oehrli_DBSec-AI_23ai_v1.pdf\">here<\/a>. More information about this SOUG event, including the agenda and slides, is available in the <a href=\"https:\/\/soug.ch\/veranstaltungen-archiv\/\" target=\"_blank\" rel=\"noreferrer noopener\">SOUG event archive<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Event Photos<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"469\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=625%2C469&#038;ssl=1\" alt=\"\" class=\"wp-image-16072\" style=\"width:655px;height:auto\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=1024%2C768&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=300%2C225&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=768%2C576&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?resize=624%2C468&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-zurich.jpeg?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><figcaption class=\"wp-element-caption\">SQL Firewall Presentation in Action at SOUG Day Z\u00fcrich.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"625\" height=\"469\" src=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-lausanne.jpeg?resize=625%2C469&#038;ssl=1\" alt=\"\" class=\"wp-image-16073\" srcset=\"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-lausanne.jpeg?resize=1024%2C768&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-lausanne.jpeg?resize=300%2C225&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-lausanne.jpeg?resize=768%2C576&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-lausanne.jpeg?resize=624%2C468&amp;ssl=1 624w, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/soug2024-lausanne.jpeg?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 625px) 100vw, 625px\" \/><figcaption class=\"wp-element-caption\">Diving into AI-Enhanced Database Security at SOUG Day Romandie.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Looking Ahead<\/strong><\/h2>\n\n\n\n<p>Both events provided a valuable opportunity to connect with the Oracle community, exchange ideas, and explore the future of database technology. AI and the SQL Firewall introduce innovative approaches to data protection and analysis. While AI is still in its early stages, it shows great promise. I&#8217;m looking ahead to seeing how these technologies develop in the coming years.<\/p>\n\n\n\n<p>If you missed the events, you can access the full agenda and presentation slides via the links above.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The past few days have been an exciting time for Oracle database enthusiasts across Switzerland. The Swiss Oracle User Group (SOUG) organized two fantastic events: the larger SOUG Day in Zurich on September 20th, 2024, and a more intimate gathering in French-speaking Switzerland on September 24th, 2024. Both events attracted Oracle professionals from across the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-16071","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-4bd","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":14847,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/its-a-wrap-insights-from-the-soug-espresso-on-oracle-audit\/","url_meta":{"origin":16071,"position":0},"title":"It\u2019s a Wrap: Insights from the SOUG Espresso on Oracle Audit","author":"Stefan","date":"26. January 2024","format":false,"excerpt":"In my latest SOUG Espresso session, Easy Audit Data Analysis with SQL Developer Reports, I focused on Oracle Unified Audit Analysis. This was an opportunity to share my experience and insights into database security and audit data workflow enhancement. Event Highlights Based on my considerable experience with Oracle databases, I\u2026","rel":"","context":"In &quot;19c&quot;","block_context":{"text":"19c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/19c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/SOUG2024_expresso_audit_oehrli.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":14472,"url":"https:\/\/www.oradba.ch\/wordpress\/2023\/11\/doag-2023-debrief-a-speakers-perspective\/","url_meta":{"origin":16071,"position":1},"title":"DOAG 2023 Debrief: A Speaker&#8217;s Perspective","author":"Stefan","date":"24. November 2023","format":false,"excerpt":"It\u2019s a wrap. The DOAG database conference has come to an end. As I sit on the train, I reflect on a week full of excitement and variety. In addition to the many fascinating technical presentations, I had the opportunity to catch up with old friends and colleagues. The conference\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_3152.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":3065,"url":"https:\/\/www.oradba.ch\/wordpress\/2019\/05\/soug-day-2019-oracle-database-in-docker\/","url_meta":{"origin":16071,"position":2},"title":"SOUG Day 2019 &#8211; Oracle Database in Docker","author":"Stefan","date":"22. May 2019","format":false,"excerpt":"Today I did have the opportunity to give a presentation on Oracle Database in Docker at the SOUG day in Olten. It was a great opportunity to discuss how Oracle database engineering can be simplified using Docker. Besides the demo the following topics were discussed: Docker images, container and volumes\u2026","rel":"","context":"In &quot;18c&quot;","block_context":{"text":"18c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/18c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/D7KVdlnXsAAg0aX-300x225.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":988,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/03\/soug-special-intrest-group-baden-march-21st\/","url_meta":{"origin":16071,"position":3},"title":"SOUG Special Intrest Group Baden March 21st","author":"Stefan","date":"5. March 2013","format":false,"excerpt":"In about two weeks I will participate at the SOUG special interest group at Baden. I will present a paper entitled \"New Security Features in latest generation of Oracle Database\". Where latest generation of Oracle Database does not stand for an other Oracle 11g release. But that's an other story...\u2026","rel":"","context":"In &quot;Oracle Database&quot;","block_context":{"text":"Oracle Database","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2642,"url":"https:\/\/www.oradba.ch\/wordpress\/2018\/06\/oracle-18c-new-security-features\/","url_meta":{"origin":16071,"position":4},"title":"Oracle 18c new Security Features","author":"Stefan","date":"14. June 2018","format":false,"excerpt":"Today I had the opportunity to give a presentation on Oracle 18c new Security Features at the SOUG day in Baden. It was a great opportunity to discuss the security enhancements in the latest Oracle database release. This release introduces some new security features that simplify the secure operation of\u2026","rel":"","context":"In &quot;18c&quot;","block_context":{"text":"18c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/18c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/IMG_1555-300x225.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":779,"url":"https:\/\/www.oradba.ch\/wordpress\/2012\/04\/doag-soug-security-lounge-at-basel\/","url_meta":{"origin":16071,"position":5},"title":"DOAG \/ SOUG Security-Lounge at Basel","author":"Stefan","date":"22. April 2012","format":false,"excerpt":"The DOAG regional group is organizing together with SOUG a Security Lounge on the 24th of April. I'll attend this event with two short presentations on Database Security and Oracle Auditing.","rel":"","context":"In &quot;11gR2&quot;","block_context":{"text":"11gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/11gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/16071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=16071"}],"version-history":[{"count":1,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/16071\/revisions"}],"predecessor-version":[{"id":16074,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/16071\/revisions\/16074"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=16071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=16071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=16071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}