Uggg, SQL Server 2012 Bummer

I’ve been having a great time in the Wayland Barn doing data migration work with MS SQL Server 2012.  The gigantic legacy database I’m moving to is super speedy on my SSD so everything is good.

Until I find out that that legacy database has triggers and stored procedures written with a deprecated JOIN syntax.  They are using *= in a zillion places to perform OUTER JOINS.  and the rain starts pouring in Wayland. Truth is, that syntax has been out of style for a decade.  But Microsoft was still supporting it until just this newest release.  Check out this very good summary of the situation.