Kategoriarkiv: Uncategorized

Real-World Database Upgrade and Migration 19c and 23c – workshop

On May 8th, Mike Dietrich and Daniel Overby Hansen are giving a full day’s workshop at Oracle Denmark in Hellerup. Don’t miss this fantastic opportunity to learn from the masters about upgrade, migration and consolidation techniques and strategies.

Spaces on the workshop are limited. So don’t hang about, read all about the workshop and register now with Oracle here: https://eventreg.oracle.com/profile/web/index.cfm?PKwebID=0x867845abcd

Generalforsamling 2024

Opdateret 12/3/2024: Beskrivelse af det faglige indlæg. Opdateret 10/3/2024: Tilføjelse til afsnittet om valg af bestyrelse.

I år afholdes DOUGs generalforsamling onsdag d. 20/3 kl. 15-17 hos SimCorp i København. Der vil være mulighed for både personligt fremmøde og online deltagelse. Tilmelding skal ske senest den 17/3 ved at sende en mail til president@doug.dk. I mailen bedes du oplyse, om du vil deltage ved personligt fremmøde eller online. Herefter vil du modtage en mail tilbage med SimCorp’s adresse eller online-mødelink.

Der vil også være et spændende fagligt indlæg. Asger Solvang vil give os en “Crash introduktion” til den nye Oracle AI Vector Search feature i 23c. Det kommer til at handle om:

  • Vector databases for high-dimensional data
  • Embedding models to vectorize unstructured data
  • Vector search combined with large language models
  • Oracle 23c features:
    • Vector datatype
    • Embedding data process
    • Vector indexing for similarity searches

DOUG generalforsamling 2024, dagsorden ifølge vedtægterne:

1. Valg af dirigent

2. Beretning fra formanden

3. Beretning(er) fra evt. udvalg/grupper

4. Fremlæggelse af regnskab

5. Forslag fra bestyrelsen

    • Det kommende års budget

    • Fastlæggelse af kontingent

6. Behandling af indkomne forslag

7. Valg af bestyrelse

8. Valg af revisorer

9. Eventuelt

Ad pkt 3:

Der er pt. ingen udvalg eller grupper

Ad pkt 4:

Ad pkt 5:

Bestyrelsen indstiller til generalforsamlingen at kontingentet fastholdes på nuværende niveau: Nul kroner.

Ad pkt 6:

Andre forslag, der ønskes behandlet på generalforsamlingen, skal være formanden i hænde senest otte dage før generalforsamlingen. Forslag kan sendes til president@doug.dk. Indkomne forslag vil blive gjort tilgængelige på siden her.

Ad pkt 7:

Efter vedtægterne træder bestyrelsen tilbage.

Bestyrelsens medlemmer har meddelt at de gerne modtager genvalg.

Desuden har Mogens Nørgaard meldt sit kandidatur

Følgende er dermed på valg:

  • Charlotte Hansen
  • Dimitri van de Ven
  • Jeannette Holland
  • Kim Berg Hansen
  • Mogens Nørgaard
  • Robert Johannesson
  • Steen Bartholdy
  • Tove Horn

Hvis du kunne tænke dig at indtræde i bestyrelsen, eller bare være del af arbejdet, send en mail til president@doug.dk.

Ad pkt 8:

Revisor Lone Aalekjær vil gerne fortsætte

Coffee meeting: Cloudy with a Chance of Overpaying: Demystifying Oracle Sizing in Azure

On February 6th 15.00-17.00, Ori Weizman will visit us in DOUG and share his technical and practical insights on how you size Oracle workloads in Azure. This promises to be an insightful afternoon and we have set plenty of time off for interactions.

The meeting has been arranged in collaboration with Silk. We will host the meeting at SimCorp, Copenhagen, for those of you who would like to attend physically and meet Ori. If you are not close to Copenhagen, there is also a possibility to join virtually via Zoom. In both cases, registration is required and can be done from: https://silk.us/events/doug-coffee-meeting-ori/. Here you can also find more details about the event and the location.

Coffee meeting: Dynamic scaling – Delivering one of the key promises of Oracle Cloud@Customer

Update 10/1/2024: Here is a link to the slides from Thorbjørn and Martin:

Come and join us for the first onsite meeting of 2024, when we meet at SimCorp on Tuesday January 9th, from 15.00-16.30. See how to sign up at the end of this page.

Martin Jensen and Thorbjørn Johnsøn will share their experiences from working with Oracle Cloud@Customer:

At the meeting we will discuss how we have set up the needed communication with the Oracle datacenter in Frankfurt in order to have Dynamic scaling at the cluster level and how we have managed to have a single server covering a number of clusters. We will also discuss differences between normal dynamic scaling and the usage of a fixed schedule.

We have also tried to add automation og adjusting CPU_COUNT on all databases on a cluster to be dependent on the changing OCPUs – and why we have found that this feature does conflict with ‘instance caging’.

Last but not least, we will highlight some of the typical points of interest to be understood, on what the database kernel is doing on weekends when you thought the system could enjoy a nice down-scaled period.

The coffee meeting will take place at SimCorp, Weidekampsgade 16, 2300 Copenhagen S.

Public transport is recommended, as parking can be difficult in the area. Bus 5c, 68 and 33 stops just round the corner. Islands Brygge metro station is approx. a 10 minutes’ walk.  

To be able to provide catering for the meeting, we need your registration in advance, and no later than Wednesday January 3rd.   

You sign-up by sending an email to president@doug.dk using the below link:

Sign-up here!

In the email, please provide your name. Once you have signed up, you will get a confirmation reply.

Online coffee meeting with Patrick Barel, November 28th at 15.00 CET

Update 30/11-2023: Patrick has kindly provided these links to download his presentation and demo-scripts.

As an Oracle developer would you like to know what’s coming in Oracle Database 23c?

Then join us for this afternoon session, where Patrick will present (mostly live demos) some of the new features coming in Oracle Database 23c.

Learn about features like:

  • Boolean datatype
  • Group by Alias
  • Developer role
  • SQL Domains
  • JSON Relational Duality Views
  • … and more..


We have scheduled the meeting for 75 minutes, so there will also be good time for questions.


No need to sign-up. Just book your calendar and use the Zoom link below on the day:


Join Zoom Meeting
https://us06web.zoom.us/j/88272829485?pwd=73vxYSLit3vC1WZ34GnfljFr5rPcKk.1

Meeting ID: 882 7282 9485
Passcode: 488881

One tap mobile
+4532728011,,88272829485#,,,,488881# Denmark
+4547372575,,88272829485#,,,,488881# Denmark

Dial by your location
• +45 32 72 80 11 Denmark
• +45 47 37 25 75 Denmark
• +45 89 88 37 88 Denmark
• +45 32 70 12 06 Denmark
• +45 32 71 31 57 Denmark
• +45 32 72 80 10 Denmark
• +31 20 794 6520 Netherlands
• +31 20 794 7345 Netherlands
• +31 707 006 526 Netherlands
• +31 20 241 0288 Netherlands
• +31 20 794 0854 Netherlands
• +31 20 794 6519 Netherlands

Find your local number: https://us06web.zoom.us/u/ktCd0TAo4

MySQL Webinar

Would you like to learn about MySQL and MySQL Heatwave?

On Tuesday November 7th Oracle is hosting a one hour Live Webinar focused on the latest MySQL features and innovations. This is a great opportunity for us in DOUG to learn directly from Ted Wennmark and Valentin Ilie.

Follow the link here to read more and register.

Slides from DOUG-day 2023

Patrick Barel:

Get your money’s worth out of your Database

A Collection’s a Collection, no matter how small

Daniel Overby Hansen:

Help! My database is running 8i

Kim Berg Hansen:

Invitation to the Wedding of JSON and Relational Data

Script

Sandesh Rao (zip for download):

Oracle AHF Insights 23c, Performance Tuning Using oratop and What’s new in Autonomous Database Oct 2023

Nordic Oracle APEX Tour is coming to Copenhagen

Update: Some slides are now available from here.

After too long a break we will once again take up the concept of an APEX-day in DOUG. We are very happy to be able to welcome the Nordic Oracle APEX tour when they visit us on Wednesday August 30th at Oracle Denmark’s office location (see further down this page for details).

This is a unique opportunity to come and spend time with and learn from some of the most talented in the APEX community:

  • Shakeeb Rahman
  • Vladislav Uvarov (Vlad)
  • Alex Nuijten
  • Roel Hartman
  • Robert Johannesson

On top of that, there will be no fee for attending.

Sign-up

For catering reasons, registration must be done no later than 20/8. You register by sending a mail to president@doug.dk using the below link:

Sign-up here

In the mail, please provide your full name and your place of work. You will receive a confirmation mail back.

Agenda

8.30-9.00 Registration, coffee

9.00-9.45 APEX 23.1: What’s New (Vlad and Shakeeb)

Oracle APEX continues its momentum both within the global Low Code development community and inside Oracle. In this session, we’ll take a retrospective of significant milestones over the past years, and explore what lies ahead. We’ll also cover several of the new features introduced in APEX 23.1 and showcase how it will improve developer productivity.

9.50-10.35 APEX: For Your Eyes Only (Alex)

Data Protection is becoming more relevant, especially now that GDPR is a thing. Of course it is easy enough to add predicates to your reports and restrict the data shown. But how do you handle data entry?

Implementing this level of security can be handled by the application, but we all know this is not the way to do it. What if the user downloads SQLcl or SQLDeveloper and sets up a connection to the database? What if we want to expose part of the data as REST Services?

The most logical place to protect data is as close to where the data is stored, being the database.

The Oracle database offers several methods to keep data private, such as Virtual Private Database, Redaction and Label Security to name a few.

This session will cover these techniques and will show you how to interact with APEX applications.

10.45-11.30 APEX CI/CD from the trenches (Roel)

The debate on how to incorporate a repository based development tool like APEX in a file based development and deployment process is already going on for years. Usually a solution is found in throwing in more rules, guidelines, tools and complexity. And most of the time that reduces the well known development speed of APEX.

Learn how we set up a development process using just SQLcl and GitLab to match most of the CI/CD requirements without giving in on development speed.

11.40-12.25 Rapid UI Prototyping in APEX (Shakeeb)

Oracle APEX enables developers to build beautiful, responsive, accessible apps, without having to become user interface or design experts. In this session, you will witness firsthand how you can customize APEX apps and apply the same design patterns that even the most popular apps today use. However, we’ll do all of this in a fraction of the time, using native out-of-the-box capabilities of APEX 23.1 with a pinch of CSS. Along the way, we’ll also explore several new features and improvements to APEX and Universal Theme so you can build apps that are a delight to use.

12.25-13.10 Lunch

13.10-13.55 Oracle APEX high Code (Robert)

Oracle APEX is cutting edge low code Framework for Rapid development and UI prototyping. What about High performant and secure development for bigger system solutions. How does APEX support this? Low code rapid development for Data drive UI, high code development for Function driven UI. In this session we will look at, different aspects of how low code APEX can be combined with more complex demands, like Function driven pages, related database updates, combination of multiple applications into single UI, as well as authentication and authorization.

14.00-14.45 Cookie Cutter APEX Applications (Alex, Roel)

In a perfect world your APEX SAAS solution would be deployed with a click of a button, have a separate database for each customer, and can a customer choose when they want to upgrade to the next version. In this perfect world, the customer don’t have to worry about default lookup data, because the SAAS provider does that.

This perfect world can be created with Application Containers and Oracle APEX. In this session you will learn the basics of Application Containers, how data is shared and separated in each container and how a new version is rolled out.

14.45-15.15 Coffee

15.15-16.00 APEX + Cloud: What’s New (Vlad)

Oracle APEX on Autonomous Database continues to evolve. In addition to bringing you the latest product features with every APEX release, we keep introducing improvements to the cloud development experience, many based on customer feedback. Did you know you can now upgrade APEX in your Autonomous Database at the same time a new release becomes available for download? This session will review this and other most notable recent improvements. And we will also look at how Oracle is migrating its internal and public APEX apps to the Oracle Cloud.

16.00 Wrap-up

(Pr. 2023-06-20. We reserve the right to make changes)

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.