Author archives: Joshua "jag" Ginsberg, Principal Technology Architect

5 Tips for Filing Good Software Bug Reports

By Joshua "jag" Ginsberg, Principal Technology Architect on Jul. 14, 2015 View Comments

We all use software and systems we didn't create, and we all find ourselves in the position of having to report software bugs and seek support. Surprisingly, support staff and software engineers are human beings, too, and human beings have moods and feelings just like everybody else. They probably spend a good portion of their work day dealing with such things, and they can easily have any number of negative reactions: frustration, impatience, or condescension.

This is rude, clearly, but we still need their help to get back to what we were doing. Filing good bug reports and doing your part as a good user can help ensure that you get the most helpful response. Here's how.

Read More

3 Things You Should Know About SQL Indexes

By Joshua "jag" Ginsberg, Principal Technology Architect on Jan. 20, 2015 View Comments

Indexes in SQL database can be your best friend or your worst enemy. Set them up correctly, and your data will be queryable with maximum efficiency; set them poorly, and both queries and writes will be increasingly slow and deadlock prone.

Here are three things you should know about how to design SQL indexes:

1. Queries use one index per joined table.

When your SQL engine is planning the execution of a query, it can only lean on one index per joined table per query. You may have several indexes on a given table, but in any given query, the SQL engine will only use one of those indexes.

Read More

'Heartbleed' Bug Exposes Millions of Sites to Security Risks

By Joshua "jag" Ginsberg, Principal Technology Architect on Apr. 23, 2014 View Comments

'Heartbleed' Bug Exposes Millions of Sites to Security Risks

Security researchers from Codenomicon and Google unveiled on Monday the existence of a bug in certain versions of OpenSSL, the library that encrypts and secures web transactions as well as many other network services.

Bugs are discovered in software all the time, but this one has generated far more attention and panic. Why? Some estimate OpenSSL secures almost 2/3 of the entire web. Furthermore, this bug allows exactly what a security library is meant not to do: allow attackers to get decrypted versions of encrypted traffic. This bug is really bad. As the bug is in the "heartbeat" feature of TLS and it bleeds secure information to attackers, the security community has dubbed this bug HeartBleed.

Read More

Easy Application Metrics with Statsd for Mobile Strategy

By Joshua "jag" Ginsberg, Principal Technology Architect on Feb. 21, 2014 View Comments

In this digital economy, it's not enough to simply deliver a custom web and mobile strategy that meets a client's functional specifications. For our clients focused on incorporating DevOps into their ecosystem and culture, our deliverables need to support their goals of maximizing mean time between failures (MTBF) and minimizing mean time to resolution (MTTR).

Less unplanned work responding to outages and regressions means more time developing features and building products, perfect for Agile development methodologies. If you're going to support fixing breakages faster and even preventatively, you need to be able to see how your applications, services, and systems are performing. For that, we recommend statsd.

Read More