February 24, 2012
by Matt
8 Comments
Storage is always challenging. In our environment, our main application creates a new database for each batch of processing it does. Needless to say, storage becomes extra tricky when a dozen new databases appear in a single day! A part … Continue reading
January 23, 2012 by Matt | 1 Comment
I saw this commercial a while ago, but found a copy of it on YouTube only recently. (Thankfully Congress dropped SOPA/PIPA, so I feel safe sharing it…) Anyway, this is a bit how it’s like when writing a query with SELECT *. We don’t have the convenience of a plastic bag to save the unused data from an errant query, so show responsibility and add the columns you really need.
January 17, 2012
by Matt
3 Comments
Recently I was asked about how I might show relationships between different entities within the same table. That one object might be the parent of another, and the child might have children or grandchildren of its own. To date, the … Continue reading
November 29, 2011
by Matt
2 Comments
Way back at the beginning of November, Jen McCown put out a call for contributors to a new project she termed SQL Tribal Knowledge. The premise was simple. You can submit an abstract for this book if you: Are currently … Continue reading
July 5, 2011
by Matt
0 comments
The year is already half over! How can I have sucked this much already? After some talk and much thought, I’ve come to the realization that many of my goals were set simply because they were advice. Granted, good advice, … Continue reading