Оптимизайка

select Users.name, (Professions.profession = 'coder') as is_coder
from Users
left join Professions on (Users.profession_id = Professions.id)

If there are no duplicates in Professions table and IDs are stable, just:

select Users.name, (Users.profession_id = 1) as is_coder
from Users

Alexa was dropped 5000 -> 40000, I'm disappointed.

move to US :)

http://www.imagemagick.org/Usage/resize/

/etc/ssh/sshd_config:

PermitRootLogin no

Let's look on oil price as at 1 december :D

crypto-currency mining, neural networking, cuda/opencl calculations:

http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using_cluster_computing.html#gpu-instance-families

https://azure.microsoft.com/ru-ru/blog/azure-n-series-preview-availability/

https://cloud.google.com/gpu/

Telegram Bot, Slack?

Amazon EC2 changes the IP after stop-start cycle. It's annoying us but will good for you :D

server {

listen 80 default_server;
listen [::]:80 default_server ipv6only=on;
server_name _;

location / {
rewrite ^ https://site.ru$request_uri permanent;
}
}