DOUG-day is here again! Come and join us on Monday October 2nd 2023. A full day of insightful sessions, networking and in the evening dinner, including our famous DOUG-quiz with a fabulous prize for the last one standing.
We are thrilled this year to be joined by Jeff Smith, Sandesh Rao, Julian Dontcheff, Mirela Ardelean, Patrick Barel, Daniel Overby Hansen, and Kim Berg Hansen. Further down the page you see the entire program as well as detailed information about sessions and speakers.
As so many times before, Oracle Denmark has kindly allowed us to use their premises in Hellerup. At the end of the page you will find the address and how to get there easily.
Price and registration
The price is DKK 650 for the whole day incl. breakfast, lunch, coffee and dinner in the evening. Registration must be made no later than September 22nd.
Registration using this link: NemTilmeld, where you can pay by credit card.
Note, if you need an e-invoice from Virk, you must not use NemTilmeld. Instead, you must send an email (link here) containing the following information:
Participant’s: E-mail
Participant’s: Name
GLN/EAN number
Company
Address
If applicable Contact person in company
If you are not already a member of DOUG, you can become a member by sending an email to president@doug.dk. It is free to be a member of DOUG.
Program
The DOUG-day is part of the EMEA Oracle Community Tour 2023.
It would not be possible for us to keep the price for this event as low as it is without our sponsors. DOUG is grateful and thanks this years sponsors:
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||
| 0900-0930 | Registration and breakfast | |
| 0930-0945 | Welcome | |
| 0945-1030 | Julian Dontcheff: The Oracle database in a market of 400 database brands | |
| DBA track | Developer track | |
| 1045-1130 | Julian Dontcheff: Oracle 23c New Features for DBAs | Patrick Barel: Get your money’s worth out of your Database |
| 1145-1230 | Sandesh Rao: Oracle Database performance tuning using oratop and a terminal | Patrick Barel: A Collection’s a Collection, no matter how small |
| 1230-1330 | Lunch | |
| 1330-1415 | Sandesh Rao: Oracle AHF Insights 23c – deeper diagnostic insights for your Oracle Database | Jeff Smith: SQL Developer Web, Command-Line, VS Code – everything you need to know! |
| 1430-1515 | Sandesh Rao: What’s in the world of the Autonomous Database in 2023 | Jeff Smith: Performant, Secure, & Useful REST APIs for your Oracle Database |
| 1515-1545 | Coffee break | |
| 1545-1630 | Daniel Overby Hansen: Help! My database is running 8i | Mirela Ardelean: Play against vulnerability with APEX |
| 1645-1730 | Daniel Overby Hansen: Patch Me If You Can | Kim Berg Hansen: Invitation to the Wedding of JSON and Relational Data |
| 1745-2030 | Dinner | |
Pr. 2023-08-25. We reserve the right to make changes.
Abstracts
The Oracle database in a market of 400 database brands
Since its brief pause in 2015, the DBMS market has reeled off 7 consecutive years of growth, with the last 6 years all growing in the teens. There are more than 400 database brands right now. The Database market has seen enormous change with the transition to cloud-based systems. Cloud platform providers lead the way and continue to make gains based on their performance. There is one database brand that not only stays dominant throughout the years but increases constantly it is significance among clients both on premises and in the cloud: The Converged Oracle Database.
Oracle 23c New Features for DBAs
The presentation covers examples of the new 23c features for DBAs including: all new init.ora parameters, the new PL/SQL packages, how SAGA works in the database, the new security and DataGuard features, and few others.
Get your money’s worth out of your Database
The database is one of the most important assets to your application. Besides being one of the most important assets it is also one of the most expensive parts in your application. Most organizations don’t get the most out of their database license and treat it like a simple bit bucket. The modern Oracle database can do so much more than just store data. Features you can use ‘in the database’ include:
– Flashback queries (what did my data look like at a certain moment in time)
– Data Security (only read and write data you are authorized for)
– Performance increase (Set based operations, regular expressions, analytics)
– Data integrity/quality (Single Point Of Data Integrity)
– Special SQL features like paginating your result.
This presentation will show these features as well as some of the enhancements in the Oracle 19c Database including:
– Identity columns (12c)
– Invisible columns (12c)
– Whitelisting PL/SQL program units (12c)
– Improvement of execution of PL/SQL in a SQL query (12c)
– Cross session Result cache (both SQL and PL/SQL) (11g)
– Polymorphic Table Functions (18c)
– SQL Macros (19c)
Oracle Database performance tuning using oratop and a terminal
Oratop is a text-based user interface tool for monitoring basic database operations in real time. This presentation will go into depth on how to use the tool and some example scenarios. It can be used for both RAC as well as single-instance database and can be used in combination with top to get a more holistic view of system performance and identify any bottlenecks.
A Collection’s a Collection, no matter how small
Oracle Database provides us with collections since a long as I can remember (Oracle 7.3.6.4). First as PL/SQL Tables in PL/SQL only. They have been been renamed (Index-by Tables, Associative arrays) and new implementations have been added since (Varrays, Nested Tables [SQL and PL/SQL]). Also the original Asscociative arrays have been updated, making them available in SQL as well. They play a key role in many of the newer Oracle features like BULK Processing (BULK COLLECT and FORALL) and Table functions. Using the bulk processing capabilities of your Oracle Database they can speed up your processing by an order of magnitude.
This session will show a little bit of history, how to use the collections, how to make collections available in SQL so they can be processed in other languages. How things can be done in what version and how things become easier with the newer versions of the database.
Oracle AHF Insights 23c – deeper diagnostic insights for your Oracle Database
AHF Insights provides a bird’s eye view of the entire system with the ability to further drill down for root cause analysis and correlation. It provides the ability to check aspects like Configuration, Environment Topology, Metrics, Logs, System Configuration, System State, Anomalies in the Operating System, Best Practices Compliance, Root cause for issues and fixes in some of the anomalous cases among its many other things. Come along and watch how to use this powerful tool to gain better insights of your system, how to analyze large amounts of data in a short period of time. This presentation will provide a demo and some examples of how you can use this in your environment to solve issues faster.
SQL Developer Web, Command-Line, VS Code – everything you need to know!
The Database Tools product manager will give you a complete update on the future of SQL Developer, and a complete tour of our new desktop tool for working with your Oracle Database. Live demos, tips & tricks, and of course all the Q&A you can handle!
What’s in the world of the Autonomous Database in 2023
This covers the new features and happenings in the Autonomous database world and will help answer more questions DBA’s, Developers will have on the Autonomous Database from provisioning to backups, troubleshooting, tips and tricks, security, multicloud and HA. This is a good introduction for on-prem DBA’s who want to learn how to migrate their databases to Cloud. Questions like how to scale up and down, how to secure their environment, how to use mtls, how to use implement data connections and equivalence between azure and to move data between clouds, all in a quick 45 minute session which might take weeks to pickup reading documentation or spanning several presentations.
Performant, Secure, & Useful REST APIs for your Oracle Database
Learn how to easily leverage your Oracle Database with HTTPS. Our ORDS product manager will give an overview of how our technology works and share some practical examples.
Help! My database is running 8i
Do you have an old Oracle database? No, not 10g; I mean REALLY old Oracle database like 9i, 8i, or even Oracle7?
The Oracle Database upgrade development team will give you insights into handling old databases that are no longer under premier or extended support. How can you modernize them? Let’s find out by migrating from 8i into a modern-day PDB. While we do that, we can also talk about the many risks of running on these old releases. If you need ammo to convince your management to allocate the necessary migration resources, we have plenty to share with you. We are migration experts and have plenty of horror stories to share.
Come to this session to get useful, practical information for your oldest databases, and let’s walk down memory lane together and see if we remember how an 8i database works.
Play against vulnerability with APEX
Do you know that half of the cyber-attacks are never detected?
Can you tell if your APEX application is secured? We CAN!
Do you know why? Because we included in the development lifecycle a process to check vulnerabilities and verify the security of our APEX application. This process can and should be included into your development process as well.
In this session we’ll discuss the type of security risks an APEX application can expose, and how our team is doing the evaluation of these risks.
You will find out about the free tools, paid tools and do-it-yourself tools you can use to verify the vulnerability of the system during the development process or gather information on a running system to identify intruders.
The session is inspired by security-check processes we are using in a few projects. It covers technical details as well as project planning, and it is addressed to developers, team leaders, and project managers.
Patch Me If You Can
You don’t like patching? Does it seem too complex? Or it takes too long? No worries. Tell us about your Oracle Database or Grid Infrastructure patching experience, and we’ll explain how you can optimize and improve it. We’ll share insights about patching and secrets you may have never heard or seen before, and we’ll even listen to your complaints. We’ll interactively do this with flipcharts, pens, and a demo environment. You don’t need to bring anything except your questions.
Invitation to the Wedding of JSON and Relational Data
“The happy Data couple cordially invites you to the Wedding of Mr. JSON and Ms. Relational.”
Mr. JSON began courtship in Oracle version 12.1.0.2 to the delight of Ms. Relational. In every Oracle version since then, the two have grown closer, right up to the JSON Relational Duality marriage in 23c.
Native support of JSON within Oracle Database became available in version 12.1.0.2 and has greatly expanded and improved in every version since. This session will give you an overview and examples of the various functionalities to marry JSON and Relational data across the versions from 12.1.0.2 until 23c including:
– Different datatypes to store JSON
– Discover content of schemaless JSON with Dataguide
– Validate JSON with a JSON Schema
– Querying JSON data in different ways
– Creating JSON data in different ways
– Modifying JSON data
– Using JSON Relational Duality view to work with same data both as JSON and as relational
– JSON in PL/SQL GeoJSON and Spatial
Speakers
Daniel Overby Hansen
Daniel is a Senior Principal Product Manager for Cloud Migrations at Oracle. He is part of Database Upgrade, Patching & Utilities and thus works with the entire portfolio of the team.
Before joining Oracle, Daniel had a long career as operational database administrator and database developer at a global provider of financial services.
Daniel’s motto is that databases are fun but when he is not messing with databases, he takes care of his family in Denmark and enjoys the outdoor life with farming, running, and hiking.
Jeff Smith
Jeff Smith is a Distinguished Product Manager at Oracle for Oracle Database, publishing tips and tricks for SQL Developer, SQLcl, Data Modeler, and REST Data Services (ORDS). Known to many of us as That Jeff Smith (which is also the title of his blog), database productivity and tools advocate.
Julian Dontcheff
Julian Dontcheff is the Global Database Lead of Accenture and has more than 30 years of database experience. He is the first Oracle Certified Master in Europe (back in 2002) and he is also an Oracle ACE Director.
Kim Berg Hansen
Kim Berg Hansen is a database developer from Middelfart in Denmark. Originally wanting to work with electronics, he almost coincidentally tried computer programming and discovered where his talent lay, as the programs he did worked well – unlike the electronics projects he soldered that often failed. After that experience he progressed from Commodore Basic on VIC-20 over Modula-2 and C at Odense University to Oracle SQL and PL/SQL, which last two languages he now has worked with extensively since the year 2000. His professional passion is to work with data inside the database utilizing the SQL language to the fullest to achieve the best application experience for the users. Kim shares his experience and knowledge by writing the Practical Oracle SQL book, blogging, presenting at various Oracle User Group conferences, and being the SQL quizmaster at the Oracle Dev Gym. His motivation is when peers go “now I understand” after his explanations, or when end users “can’t live without” his application coding. He is certified Oracle OCE in SQL as well as awarded Oracle ACE Director. Outside the coding world Kim is married, loves to cook, and is a card-carrying member of Danish Beer Enthusiasts association.
Mirela Ardelean
Mirela Ardelean started developing in PL/SQL and Oracle Forms back in 2000 and she is currently working as an APEX and PL/SQL developer for a consultancy company. She is co-founder of Romanian Oracle User Group, President of EOUC e.V., meetup organizer, speaker at conferences, part of the team who initiate the Mentor and Speaker Hub Program, editor-in-chief for ORAWORLD.
Patrick Barel
Patrick Barel is a PL/SQL Developer for Qualogy in the Netherlands. Besides working with SQL and PL/SQL he has written different plug-ins for the product PL/SQL Developer from Allround Automations. He publishes articles on his own blog.
In 2015 he received the Oracle Developer Choice Award in the PL/SQL Category. In 2019 he was promoted to Oracle ACE Director.
In 2023 he published his first book: Modern Oracle Database Programming.
Sandesh Rao
Sandesh Rao is a VP running the AIOps Automation for the Autonomous Database Group at Oracle Corporation specializing using AI/ML for different usecases from predicting faults before they happen to Anomaly Detection within log data, metrics data. His previous positions have focused on performance tuning, high availability, disaster recovery and architecting cloud based solutions using the Oracle Stack. With more than 20 years of experience working in the HA space and having worked on several versions of Oracle with different application stacks he is a recognized expert in RAC, Database Internals, PaaS, SaaS and IaaS solutions and solving Big Data related problems. Most of his work involves working with customers in the implementation of public and hybrid cloud projects in the financial, retailing, scientific, insurance, biotech and the tech space. He is also responsible for developing assessments for best practices for the Oracle Grid Infrastructure 19c including products like RAC (Real Application Clusters), Storage (ASM, ACFS).
Location
The Cube, Tuborg Havnevej 15, 2900 Hellerup
Parking is available in the area (see here). But it is not always easy to find a free parking space. On the other hand, it is easy to get to The Cube via public transport.
If you come by train or S-train:
From Hellerup St. you can take bus 1A (towards Avedøre) or bus 21 (towards Rødovre) to Tuborg Boulevard (Strandvejen) and walk approx. 500 m. Or bus 164 (towards Oceankaj) to Experimentarium and walk approx. 200m.
From Svanemøllen St. you can take bus 1A (towards Hellerup) to Tuborg Boulevard (Strandvejen) and walk approx. 500m. Or bus 164 (towards Ballerup) to the Experimentarium and walk approx. 200m.
Alternatively, there are approx. 1.5km to walk from the stations.
If you come by metro (Cityringen): From Poul Henningsens Plads St. you can take bus 1A (towards Hellerup) to Tuborg Boulevard (Strandvejen) and walk approx. 500 m.