Wrestling with the Royal Rumble (haw haw!)

I am doing my best to grapple with (sorry) the results of the Royal Rumble. How in the space of a single match, it went from one of the best Rumbles to one of the worst. The triple threat was so brilliant, symbolic of everything the WWE does right -- the Rumble itself was booked…

Josh Gordon is not a criminal mastermind

Per ESPN, Gordon got caught, again. This time, it's booze. Part of me wonders if he was so dumb he actually drank the alcohol during the test and offered some to the tester. At the very least, this probably spells the end of his Cleveland career. I'm sure Oakland will take him.

Modularize(?)

Let's hit the final topic of my Working Effectively with Legacy SQL series.  Today, we discuss the topic of modularization.  In object-oriented programming, modularization is a great idea.  One of the "clean code" tenets is Don't Repeat Yourself:  if you have two pieces of code doing the same work, try to unify that code, isolating that particular…

Improve Code Durability And Visibility

We're almost at the end of my Working Effectively with Legacy SQL series.  My penultimate topic will be all about durability and visibility of your code.  Looking at web and application development, we see certain patterns about logging and error handling which make sense in the T-SQL world, and I will cover those.  I also…

Browns find OC with awesome nickname

Remember when I ranked a list of OC candidates a few days ago? I woke up this morning to see that #6 on my list was gone. Chan Gailey (who didn't make the final list) was hired by the Jets, because the best way to make a horrible offense better is to implement a scheme for which…

Modernize Your Code

We've covered working with legacy SQL in some depth thus far.  Today's topic is a reminder that you should modernize your code.  There are some things which we needed to do when working with SQL Server 2000 that no longer make sense when working with SQL Server 2014.  For example, learn how to use window…

Finding And Removing Obsolete SQL

We're getting close to the home stretch in my Working Effectively with Legacy SQL series.  Today's post is all about obsolete SQL.  Nothing kills a project more than oodles of unused code filling up the code base.  When I started working with my current team, I was put in charge of approximately 800 stored procedures.  Within…

The economy — stupid or not?

Fivethirtyeight has an excellent breakdown of the State of the Union address and what it actually means. tl;dr -- the economy is better off than mainstream Republicans claim but not as good as the Democrats claim. We're just about to pre-recession levels in a lot of areas. The flip side of the coin is "How…

It can ALWAYS get worse

The Browns are interviewing Mike Martz to be the new OC. Part of me has to ask if the Browns are just trolling Manziel at this point. They have to be, right? No sane person with a young QB would ever entrust him to Martz.