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 several years.… Read the rest
Continue reading »
Author: Ember Crooks
- Certifications and Badges
Lead Database Administrator
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 18 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science.
Ember lives in Denver and work from home
 |
 |
 |
 |
 |
 |
Posts:
Using LDAP for Db2 Authentication in a Docker Container
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 LDAP, either transparent LDAP or security plugins can be used.… Read the rest
Continue reading »
Update on Ember’s Data Science Journey – June 2020
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.
… Read the rest Continue reading »Long-term goal (by 2035): Work on data science in a way that makes the world a better place.
Free Digital Education Opportunity: IBM User Group Days!
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 from various technologies.… Read the rest
Continue reading »
DB2 Administrative SQL Cookbook: List Privileged IDs that do not Have the Connect Authority
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 grant CONNECT to before revoking connect from PUBLIC.… Read the rest
Continue reading »
How do I Install SQL?
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 »
SQL+RDBMS Basics: What is a Commit?
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 »
Packaging and Licensing of Db2 for LUW – Version 11.5
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 »
Practice Good Documentation
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 »
Db2 Basics: IBM IDs – How to Sign Up for One
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.
Purpose
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 »DataGeek to Start Offering Some Spanish Language Translations
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 »Backing up an RDS MS SQL Server Database to an S3 Bucket
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.
Scenario
In this scenario, I have just spun up a new RDS instance for a project using a CloudFormation template.… Read the rest
Continue reading »