Drop a not null constraint with #SQL

By | February 15, 2018

Sometimes very annoying things can be removed with a simple SQL commands which nobody remembers because is used so rarely. For example when we have to update a database schema and remove a not null constraint on a column. There is a short one liner for it: ALTER TABLE my_table ALTER COLUMN name DROP not… Read More »

#RaspberryPi cluster with #ModMyPi case

By | February 16, 2018

The world smallest cluster has a new sleek case from ModMyPi the ModMyPi Cluster HAT Case The cluster is made of a Cluster HAT that creates the smallest cluster: 1 Raspberry Pi and 4 Raspberry Pi Zero for a total of 8 cores and 3GB of RAM. The case comes in a plain box: All… Read More »

#Microsoft SQL Server: Database #Replication (Mirroring) deprecated and replaced by #SQL Availability Groups

By | February 5, 2018

It looks like the Microsoft SQL Database Mirroring a feature I used a lot and for which posted a step by step tutorial that proved to be very popular was deprecated by Microsoft. In a news article on Microsoft site the alternative is presented “Basic Availability Groups (Always On Availability Groups)”. I will summarize in… Read More »

#RaspberryPI as portable #NetFlix media player

By | February 5, 2020

Running NetFlix on a Raspberry Pi is a fantastic way to carry your Netflix account with you in a light mode way without relying on a laptop or entering your credentials on unknown insecure terminals. You need: – a Raspberry PI – preferably with head radiators or better already equipped with a with a fan.… Read More »

Monitoring @ubnt based home network with @UNMS and @UnifiController with @Docker

By | February 2, 2018

I upgraded my personal network with another Ubiquiti device, this time a “UniFi AP-AC-Pro”. The sad part is that to get all the features, like extra control and statistics you need to install a Unifi Controller Software. I hate the idea of network software running on a Windows desktop so I tried to find a… Read More »

Bad #mobile data #infrastructure generates Frankenstein solutions

By | January 31, 2018

This product Zifilink is so weird that I am doing free advertisement for it. This is what happens when there are lots of mobile providers in a market and all have shitty mobile data signal. I present you the “make your own mobile gigabit” with a dongle Frankenstein tree 🙂 Come on ! look at… Read More »

#ubnt made my Holiday better.

By | January 31, 2018

I hate when you go on Holiday outside EU and your internet sucks and data roaming charges would cover Mars roaming. Lucky for me this is what I noticed in my nice Mauritius Holiday, they discovered Ubiquity devices 🙂 I think I counted like 20 UBNT Wi-Fi repeaters throughout the resort, in the palm trees.… Read More »

IT Traveller: #Failed airport #technology (Istambul)

By | January 11, 2018

I travel quite often across the world for job related purposes. Being an IT guy that does servers installations, develops and deploys enterprise software across the world I am always noticing everything that is IT related. It is always fun to see failed tech in airports I transit or in hotels where I stay. This… Read More »

#WordPress weather map plugin attack detected in #wordfence live traffic

By | January 10, 2018

Going through my Wordfence live traffic view is a nice way to see the daily fad of Chinese script kiddies. WordPress is one of the main targets of people trying to access your data. Obviously if you have a blog you must be sure you run an A+ certified security setup. See my other posts… Read More »