There are different methods to run queries against an SQL Server from a Linux machine. The one I am using is mssql-cli (https://github.com/dbcli/mssql-cli)
As you can check in the related github website, it has the following features:
- Syntax highlighting
- Query history
- Configuration file support
- Multi-line queries
The -Q parameter
It has been packetized for a lot of distributions … Read more
A short but useful post:
Suppose you need to import hundreds of members to a distribution group.
The list is in a CSV file:
To bulk import all the users, a simple command like this is enough:… Read more
Im using my Microserver Gen8 a lot and, sometimes the poor performance of the CPU is noted (when showing galleries with many images for example). So I decided to replace it by another better one.
CPU model to choose
I chose the cpu model based on this resource
Those are compatible CPU with different performances prices and all of them … Read more
In this post, I show how I update my Microserver Gen8 iLO4 version. One of the ways to do it is via command line but i decided to use the web interface (the most common way).
At the time of writing this, the version i had was iLO 2.50 (Sep 23 2016) and the new version is … Read more
5th post of the Home Server series in which I explain how I built my own server.
In previous posts I have shown how to install an SSD disk to your HP microserver Gen8 server. Even if you do not have this hardware, in this post I will show step by step how to install the VMWare ESXi 6.5
… Read more
Third post of the Home Server series in which I explain how I built my own server.
Visit the first post for details about the objectives of the project.
Maybe you have decided to have your own server and already you are owner of any model as HP Microserver Gen8. Surely there are many more to be done, but these… Read more
F5 BIGIP is a very powerful and versatile product that can be used for several purposed. I started using it as a load balancer. Then I used it to replace the previous SSL VPN portal (and it works perfectly).
Some time ago I decided to start using it as reverse proxy (it was time for my old Microsoft TMG to … Read more
This time a simple as well as important post. Have you tried to run a scheduled task every minute?
When editing the trigger of a task schedule, there is a section in which the “Repeat task every” parameter can be set, and you have probably noticed that by default only the values “5 minutes, 10 minutes, 15 minutes, 30 … Read more
In a previous post I showed how to upgrade your laptop HDD (Hard Disk Drive) to an SSD (Solid State Drive) to boost up performance. In this post, instead of removing the HDD, it will placed in the DVD bay to be used as a second storage.
Given that the use of ODD (Optical Disk Drive) to read or write … Read more
This post explains how to generate self signed certificates with SAN – Subject Alternative Names using openssl. It is a common but not very funny task, only a minute is needed when using this method.
The example below generates a certificate with two SubAltNames: mydomain.com and www.mydomain.com
Create openssl configuration file
Create configuration file for openssh (In a Linux … Read more