Monthly Archives: May 2012

Always restore with NORECOVERY

Posted on May 24, 2012 by way0utwest

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option. It’s trivial to switch the database online. Not trivial to recover from an accidental restore with RECOVERY (the default) ‘nuff said.

Posted in Blog | Tagged , , , | 5 Comments

Lifehacking – Not such a good idea?

Posted on May 23, 2012 by way0utwest

I read the confessions of a recovering Lifehacker and thought it was an interesting read. It seems that the author has started to realize that while you can make some differences in the small stuff in your life, it’s just … Continue reading →

Posted in Blog | Tagged , | Comments Off on Lifehacking – Not such a good idea?

Use Tools

Posted on May 23, 2012 by way0utwest

As someone that works with Information Technology, I usually work on applications designed to make work easier. For example, we have accounting systems that ease the handling of debits and credits, they detect mistakes in data entry, and in general … Continue reading →

Posted in Editorial | Tagged | Comments Off on Use Tools

The Tally Table and Expanding Rows

Posted on May 22, 2012 by way0utwest

Suppose you had some data like this: Class           Limit ————— ———– Calculus        5 History         4 Physics         2 But what you really want is this: Class           Student ————— ———– Calculus        Calculus        Calculus        Calculus        Calculus        History         History         History         History         Physics         Physics         Where … Continue reading →

Posted in Blog | Tagged , | Comments Off on The Tally Table and Expanding Rows