TSQL: Passing objects to stored procedures via XML

Introduction This is a subject I have heard about repeatedly, but I never bothered looking into it until recently. I was told that writing hard coded insert and update statements is bad practice. To w...

SSRS Logical Flaws of IIF

Déjà Vu It isn’t very often when I have to build reports for SSRS, it usually happens in bursts. I will write like 2-5 reports (sometimes more) and you always tend to find a bunch of shitty pr...