Welcome to My Blog

Introduction Python Pandas is a powerful package used by data scientists to analyze data. My recent use case was far more pedestrian. I had one vendor that was providing a data file in Excel format, and another vendor that needed to consume that data in a completely different schema as a CSV file. As is often the case, the file I was receiving was formed oddly. I’m sure you can relate. The primary problem was that the columns were not all defined. They were unnamed and formatted for some previously defined form, such that the first column might be a person’s name, the second column might be the first line of the address, or a second person’s name. ...

Introduction I have long waffled on whether a GUID or integer make for the best primary key. I wrote this with the goal of refining or challenging my current opinion. The identity, or primary key, uniquely identifies an entity or record. To be clear, ‘identity’ is a Domain Driven Design concept that describes an immutable identifying attribute of an entity (not to be confused with a SQL Server identity column, which is an automatically incrementing integer). A ‘primary key’ is a database concept that serves the same purpose for a record and enforces referential integrity. In this post, I will use the term ‘primary key’, since we are focusing on the database. The concept of an identity attribute is more than just a database concern, it is a domain concern, but it is important to consider where these concerns intersect. ...

I know the inventor of the disposable toothbrush. They would stay at hotels that provided soap, shampoo, conditioner, etc., but a recurring issue was that they would forget their toothbrush, and hotels didn’t furnish a solution. It seemed obvious that hotels should have individually wrapped toothbrushes, just as they had other toiletries. Why didn’t anyone make an inexpensive short-term use toothbrush with toothpaste already applied? So, this person invented it – only they didn’t. They did in fact come up with the idea, as I’m sure did many others, but they never acted on it. Someone else eventually did. To this day, every time this person sees one, they declare how it was their invention. ...