The IDUG Virtual conference kicked off today, and I thought I’d share my excitement and a few observations. Content Today Today was mostly the opening keynote and the spotlight sessions. Recordings of Monday’s sessions will be available on-demand for conference…
If you’ve read the blog for a while, you realize I’m a big fan of the IDUG conferences. I’ve gone to the North American one every year for the better part of a decade now, and the European one for…
Db2 is a bit unusual among RDBMSes in that it does not perform authentication. No matter what, you need some external authority to perform authentication. Usually that is either the OS or LDAP, though there are other options. If using…
It has been a while since I wrote one of these, and it’s about time! Recap In June of 2018, I set a new goal for myself. Long-term goal (by 2035): Work on data science in a way that makes…
I recently discovered an interesting (and frustrating) issue while running PostgreSQL in Kubernetes. While the issue technically isn’t specific to Kubernetes, per se, it is certainly easy to encounter in Kubernetes for users of the official PostgreSQL Docker image (and…
What is IBM User Group Days? On May 19 and 20, IBM is hosting several tracks of great sessions. Some of these come out of content that would have happened at THINK, and others are collaborations with the user groups…
Purpose To list IDs that have one or more privileges, but do not have the CONNECT authority through a direct grant, a group, or a role, either explicitly or implicitly. I used this to find IDs I might need to…
Introduction I would like to begin by thanking Ember for allowing me to be a guest blogger and explaining the motivation behind writing this blog. The “need for speed” in today’s world has led to a sweeping reform where old…
I have seen the question several times on various groups or forums – “How do I install SQL?”. From a DBA standpoint, this isn’t even a properly formed question. From a developer learning standpoint the question makes sense. I needed…
This post is cross-platform and applies to all RDBMSes. It is interesting to see, as a person experienced with a technical tool, some of the disadvantages of the newer ways of learning technical topics. When I started in IT, you…
Edit 2020-01-02: corrected limit for free Db2 on Cloud to the correct 200 MB. Original text is still in the document, in strikeout. This is one of the few blog entries where I include the Db2 version number right in…
Having worked on teams of Db2 DBAs, largely in consulting roles, the value of good documentation is huge. This is once again clear to me as I start a position with a new company. The documentation here happens to be…
