SQL: generate a report with dynamic columns by month

SQL: generate a report with dynamic columns by month

Hi all! This time I’ll try to dig a little bit into the fabulous realm of SQL and see how we can generate a nice report with dynamic columns. The need: I had to generate a report showing some counts divided by month, basically the columns represent the months and the user...

2 minute read
MVC: reading LinkedIn user profile data

MVC: reading LinkedIn user profile data

Suppose you have to login your users using an external provider. Maybe LinkedIn. Suppose you have to read the user profile data and do some stuff. Maybe you have to register the guy on your website. Maybe you know a bit of OAuth and you want to give it a...

6 minute read
AngularJS: unnecessary routing and the hash sign

AngularJS: unnecessary routing and the hash sign

If you are using AngularJS for something different from a Single Page Application, probably you are not using the built-in routing functionality. In this case, don’t add the ngRoute dependency to your app , or it will always try to handle your #hashes (and most probably your web app won’t work)....

1 minute read
SQLCE: How to execute complex scripts

SQLCE: How to execute complex scripts

For one of the side-projects I am working on, I needed a way to execute long SQL scripts to create some reports. I started the project using SQLCE because I didn’t wanted to bother with a full installation of a SQL server (even the Express one), so I wrote all...

1 minute read