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 […]
Category: Developer
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 […]
SQL Screw-ups: Stored Procedure Misuse
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. Imagine you’re starting a brand new project. You can make design decisions to mitigate all the issues you encountered in the legacy app you’ve been […]
SQL Screw-ups: Scalar-Valued Functions
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. Imagine you need to calculate the extended price for records in the Sales.SalesOrderDetail table. A simple way to get the extended price for […]