Tag: Humor

  • This Made Me Laugh: SQL v NoSQL

    It’s a humorous history lesson on SQL (and product promotion), but it opens like this:

    battle

    SQL awakens to fight the dark forces of NoSQL

    From there it looks at the beginnings of SQL and the growth of NoSQL, going through a few sections, like

    newhope

    Part 1: A New Hope

    and

    strike

    Part 2: NoSQL Strikes Back

    before moving to

    return

    Part 3: Return of the SQL

    They finish with the idea that SQL is the most important, and common, tool for data analysis. In this era of Python and R, many may disagree, but I think they’re overall right.

    Perhaps this last part proves that?

    yoda

    Master Data Scientist Yoda

    It’s an interesting read, and I may have to watch some Star Wars this weekend.

  • The Code Coverage Report

    I had someone that told me recently that they needed to find a way to get code coverage in T-SQL. Not for them, not to improve quality, but because their manager wanted a report.

    OK, here it is.

    First, build a nice SSRS report that displays your company logo, a header, the current date, and a pie chart. Yes, I know pie charts are bad, but they’re good for managers that want something like code coverage.

    Now, for the data source of the report, here’s your query:

    SELECT 90 + ((RAND() * 8)-2)

    Now, you won’t always get over 90%, which is what some people want, but you’ll get over 90 eventually.

  • Quitting VIM

    I saw this post from Joel Spolsky lately, noting that Stack Overflow has been helping 1 million developers exit VIM. It’s a funny post, but one that has some truth in it. I’ve gotten into VIM, almost always from git, but sometimes in Linux, and I often Google the exit.

    Fortunately I’ve learned a few things and  usually remember :wq.

    Other do too, since I actually didn’t need to Google that during a presentation where I committed without the –m, and got into VIM. I actually remembered :wq, posted just “:wq” on Twitter, and a few people laughed, since it’s maybe the one VIM command quite a few people need to remember.

    Hopefully just typing this post will tatoo that sequence into my head so I never end up reading the command list on Stack Overflow again.

    If you want to learn more about VIM, here’s a cheat sheet.

  • The History of the World, I Guess

    The lighter side. From my kids, and since there’s some science and it reminded me of the Big Bang Theory.

    Have fun.