SSIS Conditional Expressions (Lightbulb:On)

I’ve often been confused and frustrated by conditionals ( … ? … : … ) in SSIS expressions. The concept is straightforward enough, but the syntax made it really hard for me to keep track in nontrivial cases. Then yesterday I had an epiphany: it’s much easier to keep them straight if you write themContinue reading “SSIS Conditional Expressions (Lightbulb:On)”

How to Override IE’s Compatibility View Behavior On Intranet Sites

To force IE to edge mode (even on intranet sites, where IE would otherwise use compatibility mode), the server needs to send X-UA-Compatible as an HTTP header. Using a meta element in the document head doesn’t work reliably. I found the answer buried in this Stack Overflow thread. In my case, I was working onContinue reading “How to Override IE’s Compatibility View Behavior On Intranet Sites”

Generating a Range of Dates in MySQL

Working on a report from a MySQL database, I needed a table of all dates for the next year. With SQL Server (2005 and later) there’s a CTE/recursive method to do this pretty elegantly, but I couldn’t find anything similar for MySQL. All the solutions I found involved temporary tables, loops, and/or stored procedures–none ofContinue reading “Generating a Range of Dates in MySQL”