Use [by default] TLS 1.2 on PowerShell

As simple as this:

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

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. 

Get size of each table on MS SQL Server database

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

SELECT TOP 1000 t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB, SUM(a.used_pages) * 8 AS UsedSpaceKB, CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB, (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB, CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE t.NAME NOT LIKE 'dt%' AND t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, s.Name, p.Rows ORDER BY t.Name

IE11 on Windows Server 2008

Some notes:

- Download from MS is the same as windows 7;
- This can safe you same time: ie11 install error

Please notice when you cut & paste " from a website to the command line prompt sometimes it does not work. Just clear the quotes and add them again.

Reseting a SMC 8612T Tiger switch

What if you lost the password of an old SMC 8612T Tiger ?

The manual says that you should connect via console and use Ctrl U when it starts but this procedure will lead you to a password prompt. The password that you don't know.

Instead, use Ctrl F. As simple as that. SMC, please fix your manuals.

Windows KMS Server - Licenses

Diagnosing KMS is quite simple. Microsoft has a nice technet how-to here.

It shows this interesting command: SLMGR.vbs /dlv

It's also nice to know the registry settings on the client.

Error installing Java on Windows 8

If you get into this error while installing Java on Window 8:

java.lang.NullPointerException at com.sun.deploy.config.JREInfo.validateHomeJRE_int(Unknown Source) at com.sun.deploy.config.JREInfo.initialize(Unknown Source) at com.sun.deploy.config.ClientConfig.refreshProperties(Unknown Source) at com.sun.deploy.config.ClientConfig.init(Unknown Source) at com.sun.deploy.config.WebStartConfig.init(Unknown Source) at com.sun.deploy.config.ClientConfig.<init>(Unknown Source) at com.sun.deploy.config.WebStartConfig.<init>(Unknown Source) at com.sun.javaws.Main.main(Unknown Source)</pre>

Just delete this file:

<User Application Data Folder>\LocalLow\Sun\Java\Deployment\deployment.properties