MapReduce in 10 Minutes

I am honored to present at the PyOhio conference this year! Get details at pyohio.com/2020 (register free here). In this talk, I tell you everything I know about MapReduce in just 10 minutes!

I do not go into how to use any specific implementation of the MapReduce pattern (cough, Hadoop, cough). I do, however, explain how the MapReduce pattern works so you will be familiar with it for your next big project.

Read more for resources from this talk.

Continue reading “MapReduce in 10 Minutes”

Getting Started with Python

I’m honored to be presenting at PyTennessee this Saturday! I’ve thoughtfully crafted an hour-long workshop to help folks get into programming with Python.

The phrase get into programming with Python is intentionally ambiguous. My workshop is for people who want to get into programming and we’ll be doing so with Python. My workshop is also for people who are already into programming but want to do so with Python.

March 7, 2020 will be my first Python talk. Out of necessity, it will also largely be a live coding demo – also a first for me. So, let’s see what we’ll need to do before you walk into the session.

Continue reading “Getting Started with Python”

SQL Screw-ups: Cursors and While Loops

This is a continuation of the SQL Screw-ups series that stemmed from my Nashville .NET User Group talk on 03/14/2019. Slides and setup details are on the first post in the series.

The rule of thumb around cursors and while loops in SQL is simply don’t do it unless you must. Let’s look at a scenario in which you should not use a loop, and then we’ll look at a problem that is easily solved by a loop.

Continue reading “SQL Screw-ups: Cursors and While Loops”

SQL Screw-ups: Type Mismatches

This is a continuation of the SQL Screw-ups series that stemmed from my Nashville .NET User Group talk on 03/14/2019. Slides and setup details are on the first post in the series.

SQL Server helps us out by performing implicit type conversions when it can, but how helpful is this actually? What you don’t know can hurt you when it comes to type conversion . Let’s discuss the type conversions that you may not know are happening and some tips for avoiding them.

Continue reading “SQL Screw-ups: Type Mismatches”

SQL Screw-ups: Outer Join Filters

This is a continuation of the SQL Screw-ups series that stemmed from my Nashville .NET User Group talk on 03/14/2019. Slides and setup details are on the first post in the series.

Think about the last time you needed apply additional filtering to a query based on information from some other table. You probably JOINed the additional table or added an EXISTS predicate in the WHERE clause. Let’s discuss ways you might’ve screwed it up. Continue reading “SQL Screw-ups: Outer Join Filters”