Sql Server 2016: Change SQL Server Collation after installation

I have just finished an installation process of SQL Server 2016, and in post-check I’ve verified that I’ve installed the instance with a wrong collation setting.

In this tip I will explain step by step how to change the server level collation setting for an existing SQL Server instance. Continue reading

Posted in Windows | Tagged | Leave a comment

How to install Ms Sql Server vNext on Debian 8 Jessie

better_linux_boxMicrosoft surprised the IT world with the announcement about the new MS SQL Server that is able to run on Linux. In this post I’ll show hot to install Sql Server on Debian 8 Jessie.

apt-get update
apt-get upgrade
apt-get install curl apt-transport-https sudo 

Add to /etc/apt/sources.list this backports

deb http://ftp.debian.org/debian jessie-backports main

After that you’ll be able to install jessie-backports openssl

apt-get install -t jessie-backports openssl

Continue reading

Posted in Linux, Windows | Tagged , , , | Leave a comment

Fax & Voip – Part 3/3 – Baud Rate & Fax Relay

oldfaxmachineDecrease Baud Rate and turning off ECM
Packet loss, jitter, and latency all add up to corrupt a fax transmission in VoIP env
and unfortunately also in Asterisk PBX.

When a fax machine determines that some data is lost, it will shut down the entire fax transmission, even though you would still have a workable document.

By slowing down the transmission speed up to 9600 bps, you’ll increase the probability that all the faxes will be transmitted or received correctly.

To slowing down the BAUD rate to 9600 bps you need to check the parameteres of the fax device. Continue reading

Posted in Asterisk | Tagged , , | Leave a comment

How to compact VirtualBox’s VDI file size

bimboingabbiaIf in creating process of Virtual Box VM you have selected the option Dynamically Expanding Storage, you will find that the file size expands whenever you install new applications in the VM or add new files.
However, when you uninstall or delete applications, the file size of the VM does not shrink: if you are constantly installing and uninstalling applications in your VM, the VDI file could be taking up more space than it is actually using.
In this post I?ll show the steps to shrink your Virtualbox VM. Continue reading

Posted in Other | Tagged , | Leave a comment