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 Python, I went and downloaded Anaconda.… Read the restContinue reading »
How to investigate Db2 copies installed on a Windows system
According to one of the definitions from the UrbanDictionary, adding the words “in bed” to any sentence can make that sentence “more interesting”. I like to think that the Db2 LUW world equivalent of that is taking a task – such as working with Db2 copies – and adding words “…on Windows”.… Read the restContinue reading »
This is a new series that has been percolating in my head for a while. When I help clients with SQL, we’re often adding (or removing) indexes to help SQL performance. It has been said (though not by me) that SQL re-write is obsolete because the Db2 Optimizer will take care of that.… Read the restContinue reading »
I’ve been moving along well this year on my data science journey. I’ve been thoroughly enjoying an edX class: Python for Data Science from UC San Diego. I started using Jupyter Notebooks (Python Kernel) over a year and a half ago, so I am enjoying the course on three levels:
- It seems easy because I have a background in Python, basic programming, and Linux systems
- I’m learning more about the Python libraries I use for Db2 health checks, and more about DataFrames that builds on my self-taught knowledge.