Tim Hoolihan

When altering a table to an Oracle reduce a columns size, you’ll get a ORA-01440 error, indicating that you can’t make the adjustment because of the potential data loss. I had to do this to recently to a bunch of columns, as I had incorrectly specified the size of numbers that would end up as [...]

According to Wikipedia, Single Source of the Truth “refers to the practice of structuring information models and associated schemata, such that every data element is stored exactly once” (emphasis is mine). This would mean, for example, a customer’s first name to be stored in once repository, not in every system that refers to the customer. [...]

Yesterday, I left downtown Cleveland at 3:45 headed to a 4 o’clock meeting. I was probably going to be 5-10 minutes late. Instead I ended up calling to reschedule, and still didn’t make it home till 6:15. Two and half hours, for a drive that usually takes me 45-55 minutes. Google maps says 38 minutes, [...]

I am working on a project that uses Oracle 11g, and we were standing up a db for proof of concept in one of the dev environments. I configured listener.ora to point to the instance, but still was having connection problems. Apparently in your init file, you need the line: local_listener=’MySidName’ To make sure it [...]

I have been working several applications lately at work that use Domain-Driven Design. I had a couple of questions about design choices I saw made in the applications I’m working with. I recently talked to an architect who uses DDD a lot (Model first), and had the chance to pick his brain. Here’s what I [...]

Background: Linq to Sql is a lightweight data access protocol for the .Net framework.  It supports filtering and other lambda features in code, allowing the programmer to treat their data source as if it were a collection of objects that support flexible features.  In this way, it can be thought of as an ORM mapper, [...]