Category: General

Time For A Reset

Sometimes you just need a break … a reset, if you will. I took the month of May for myself and for my family. I would list all the things that normally happen in my house and which ones ceased as of May 1, but you don’t *really* care. Just think about all the hectic […]

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 […]

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 […]

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 […]

SQL Screw-ups: The Wonders of NULL

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 definition of null is unknown according to Microsoft documentation. That is, null represents an unknown value. It took an embarrassingly long time […]