Category: SQL

It wasn’t until recently that I discovered a feature that I’ve missed since SQL Server 2012.  One of my recent projects involved converting a lot of old Visual FoxPro code.  That’s not quite as much fun as it sounds, as it turns out. …

SQL Server IIF: Syntactic Sugar that Doesn’t Rot Your Brain Read more »

There hasn’t been a great deal of routine from year to year throughout my career.  Microsoft has moved from VB6 to progressively more advanced incarnations of the .NET framework and versions of SQL Server have added Intellisense and more features than I …

CROSS APPLY Keeps Me Sane Read more »