Enabling dynamic and static compression in IIS7 is easy, well-documented, and beneficial for performance in almost every scenario.

However, compression of JSON data is not enabled by default.

Here's how to enable it:


We recently tried using SQL Server Query Notification (aka SQL Cache Dependency) for something much more involved than the usual “lookup table” (using it to send relevant data updates from a large OLTP system into a secondary aggregating system).

It’s been a whirlwind of “I’m impressed” moments (with a share of little snags too).

Here’s what we were impressed by:

SQL Server

My associate Bill King pointed me to the fact that HTML5 is in many ways "already here".

In my browsing, some industry person stated that it won’t be an official spec until 2022...
...but important elements of it are already implemented in several browsers. 

Here’s an eye-opening article: