Category: Programming
Communication in Software Development
At a meetup I was at recently, the speaker asked what we thought were the most important soft skills. My answer was English, or more generally, communication. Programming can be thought of as communicating with the computer...
Read MoreMissing indexes in Oracle
Some little details cause trouble entirely disproportionate to their importance. One such thing is a little quirk in how Oracle handles indexes. I have some code which gets a list of tables using a particular criteria and then...
Read MoreParsing doubles in Finland
One problem I had this week is that a piece of code which had, for the previous few years, been perfectly behaved suddenly started crashing for a new customer. This was the first time I’d seen the code run on a Finnish...
Read MoreImproving query performance in SQL Server with recompile
This week I ran across a new-to-me option in some T-SQL code I was reviewing: OPTION (RECOMPILE). It turns out that this option improves performance by forcing SQL Server to recompile the query rather than using the plan it...
Read MoreAccessibility and HTML5: Semantic Elements and More
A div for everything and everything is in its div… If you’ve been working on websites for a while, you’ve no doubt had a few that seem to be just div after div, where the div explosion serves to place or style...
Read MoreTesting for accessibility: Web Content Accessibility Guidelines
What makes a website accessible? The answer, of course, is that a website is accessible if it is usable by all people, regardless of disability. When building a website, however, we need something a little more concrete; we need...
Read MoreMaking your site screen reader accessible
One of the things I’ve been working on lately is ensuring that our web apps are accessible, which primarily means that those with visual impairments can use them. Partially that means making sure to use high-contrast...
Read More
The Value of Design
When I first started as a developer, the process was simple. You picked (or were assigned) a bug...
Read More
Quantifying Value
What is the value in what you do? As programmers, we tend to do what we do for two main reasons:...
Read More
Ensuring Goodness
I heard a phrase I liked recently: software testing is ensuring goodness. [Alexander Tarlinder on...
Read MoreComputer science and programming interviews
Recently my friend Janie has done a series of blog posts on her disagreement with using computer science questions as a major part of the hiring process. I can agree with her, to a point. If you’re hiring for someone to do...
Read MoreOracle, index-organized tables, and overflow tablespaces
SQL Error: ORA-25191: cannot reference overflow table of an index-organized table
A refresher: a SQL database is relational, and rows are stored unsorted; Oracle calls standard tables heap-organized tables. For a given SQL query, unless an ORDER BY clause is used, results can be returned in any order. Oracle also has IOTs, which are tables that are instead stored in a B*Tree index structure. This structure stores all columns of the table, sorted by primary key; because this is both the table and the index, accessing rows is much faster and less storage space is needed than for a heap-organized table with a separate index.
Read More
Recent Comments