Articles & Content

Henrik Loeser: Thoughts on IT, Life, DB2, and More

IT Professional (IBM), Information Management Architect / DB2 pureXML / Database Kernel Developer, spent 7 years living in California (Bay Area), now back in Germany, living in a passive house in Friedrichshafen

Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.

 

 
Db2 11.5 Mod Pack 4 is availableA quick note that Db2 Version 11.5 and its Mod Pack 4 are now available. You can read more about its new features and changes in the "What's new" section of the Db2 docs.An interesting new security feature is the support for JWT (JSON Web Token) for authentication. It simplifies the integration of S…
Getting started with Db2 on Cloud LiteIt seems to me that during the COVID-19 pandemic there are more hackathons than usual. Great to see that IBM Cloud is the platform of choice for many solutions. Db2 on Cloud is used as database, often the free Lite plan to get started. That's the reason I published a quick guide on the IBM Cloud blo…
Hands-on security: Share resources on IBM CloudArchitecture: Database-driven SlackbotOne of my favorite IBM Cloud solution tutorials is about building a database-driven Slackbot. It is a great example for integrating enterprise resources with an AI-backed user interface and for utilizing serverless technology for the glue. Once you have created …
New performance and security feature in Db2: Authentication cacheNew security feature in Db2The recent release of Db2 11.5.3 (Db2V11.5Mod Pack 3) includes a small gem that impacts both performance and security. It is a cache for User ID and Password-based authentication. That feature is great when your system uses LDAP / Active Directory for authentication becaus…
Use Chromium-based browsers to manage FIDO security keysAdd fingerprint to FIDO keyRecently, I made a discovery that simplified how I manage my FIDO security keys. Instead of using a vendor tool to set a PIN or add fingerprints, I now switched to utilizing a Chrome- / Chromium-based browser for the administration. This works well on my Linux box. In this…
Some advanced SQL to analyze COVID-19 dataLearn to write SQLAll of us are impacted by COVID-19. Looking at daily case numbers, the basic reproduction number or mortality rates has become a routine. But what is behind those numbers? How are they computed and how does SQL help? In this post, I want to discuss how some SQL analytics clauses he…
IBM Watson Studio: Download pandas DataFrame as CSV or Excel fileGist code snippetRight now, I am working with IBM Watson Studio on some analytics side project. It is nice to work with Jupyter Notebooks, Python and pandas and data again. Even Db2 is involved.From working with pandas DataFrames locally, I knew how to turn the data into CSV or Excel files. But work…
All the best combined: Cloud, Db2, Python, Serverless and SecurityAdd a cloud service ID as Db2 userEarlier this year, I wrote about how to use an API key or access token to connect to Db2 (on Cloud). Today, I am going to show you how to set up a service ID (technical user) on IBM Cloud, assign it a Db2 user ID (see screenshot) and grant database privileges. There…
Home office and rubber duck debugging, 5 levelsRubber duck debugging at homeRecently, I shared with you my best practices for working from home. Today, I want to add an angle specific to technical jobs, especially for developers. When you work in co-located teams, you benefit from the direct conversations and exchange. In (software) development …
Key Protect as vault for multi-cloud setupGuard credentials in a vaultIn my previous blog post, I showed how you can easily encode and upload credentials to IBM Cloud Key Protect. Today, I am going to share sample code with you for retrieving the credentials and turning them back into a JSON object. A common use case is a multi-cloud enviro…