Db2 Experts on a Data Science Quest
 |
 |
 |
 |
 |
 |
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 grant CONNECT to before revoking connect from PUBLIC.… Read the rest
Continue reading »
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 rest
Continue reading »
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 learned some of the concepts in college, you learned some things working on the job with other DBAs who knew what they were doing, and you filled in the gaps by going to week-long classes once a year to get some detailed and hands-on official training.… Read the rest
Continue reading »
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 the title.… Read the rest
Continue reading »
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 excellent and it makes getting a new person (me!)… Read the rest
Continue reading »
IBM IDs are completely, 100% free. You pay with a bit of your personal information. You have to provide an email address and a first and last name.
Those of us who have been working with (or for) IBM for years, really don’t even remember signing up because it is just a minor thing.… Read the rest
Continue reading »Welcome readers! I have a friend who has offered to provide Spanish language translations of some blog entries. The list of entries to work through is long, so if you have any articles you’d particularly like to see in Spanish, please comment with them so we can add them to his list.… Read the rest
Continue reading »Note: I’m new to both MS SQL Server and to RDS databases. My base expertise is as a Db2 (LUW) DBA.
There is a really complete document on this available from Amazon.
In this scenario, I have just spun up a new RDS instance for a project using a CloudFormation template.… Read the rest
Continue reading »
SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the rest
Continue reading »
I have left XTIVIA. This is nothing against XTIVIA or the wonderful people there, it’s just an evolution on what I want to do.
5 years ago, when I started at XTIVIA, it was the perfect place for me at that time.… Read the rest
Continue reading »One of the things I most enjoy in my career is speaking – whether it is at conferences or for Users Groups. I’ll be speaking at Users Groups in St. Louis and Milwaukee September 10 and 11.
Also speaking will be one of my favorite speakers – Pavel Sustr.… Read the rest
Continue reading »