Half a Thousand Quizzes
Passed a minor milestone 😁 Sign in to https://devgym.oracle.com/ Go to Quizzes Go to Explore All Quizzes Scroll down to Author filters Put a checkmark at Kim Berg Hansen Result: (In fact, as you read this, the number will already have increased – it grows steadily…
SQL Tuning Golf, anyone?
Golf is one of the very few sports where the goal is the lowest possible score. Code golf is about solving a given algorithm using the fewest possible characters. It can be very fun indeed to play code golf, also in SQL. But for real…
MASH – Mentor And Speaker Hub – is here for you
Thursday 11th of March 2021 saw the birth of the MASH Program – Mentor And Speaker Hub. A program dedicated to give new tech speakers an easier way into the speaking community by connecting to an experienced speaker as mentor to provide guidance in the first…
SQL Survey and Christmas Book Raffle Results
Over the last weeks I’ve conducted a little Christmas survey with a few SQL related questions, raffling off one copy of Practical Oracle SQL among those who participated in the survey. The survey is over and I did a single call to DBMS_RANDOM.VALUE to find…
Game Of Life in MODEL clause – revisited
Long time ago I blogged about Conways’s Game of Life in a MODEL clause, which also made it into Chapter 6 of my book Practical Oracle SQL. Today Samuel Nitsche applied this approach to solve Day 11 of Advent of Code 2020 (follow Sam’s blog for…
OSX show used ports or listening applications with their PID
On OSX you can display applications listening on a given port using the lsof the commands described below will show listening applications as well as the PID for each application lsof -nP -i4TCP | grep LISTEN lsof -nP -i4TCP:[PORT] | grep LISTEN Where [PORT] is…
Midsummer Midsomer SQL Winner
In June I launched the Midsummer Midsomer Murder SQL Challenge and Book Competition. I promised to announce a winner within a week of the deadline – that was yesterday, so I’m afraid I’m one day late, sorry about that but better late than never 😇….
Midsummer Midsomer Murder SQL Challenge and Book Competition
It’s getting close to Midsummer, where in Denmark we traditionally burn witches on Saint John’s Eve. If we misspell it slightly to Midsomer, we have the Midsomer Murders series with loads of dead. So let’s have a little murderous SQL challenge for Midsummer to give…
Soap WebService NTLM Authentication with Apache CXF and Spring
Recently I had the “chance” to consume an old school WebService in good old SOAP on top of that it was a C# WebService using the dataset construct which is in itself a world of pain… but we will not talk about that here A…
And the winner is…
10 days ago I started a raffle, where you could complete a SQL Workout and win a copy of Practical Oracle SQL. The deadline was end of April UTC, so today I found the winner… 9 raffle participants had completed the workout, so I had…