Saturday, July 14, 2018

TP-Link MR3420 and Vodafone Modem K5160

TP-Link MR3420 v2 refused to work with my new K5160.

The firmware from TP-Link didn't help so I give a try on "Of Modems and Men" firmware [ROOter].
It's quite simple to install the firmware (but be aware that rollback is not so simple).

ROOter firmware identified the modem correctly but still no connection to the internet. It seems that the hostless modem is still working as MBIM.

The trick is to ssh to the modem, rename /sbin/umbim to something else and reboot the router. 

Thursday, May 10, 2018

Get size of each table on MS SQL Server database

Simple query to get the size of each table on Microsoft SQL Server database.