Author: James

Can’t copy/paste new line in SQL Server Management Studio

It’s common that add new line in the SQL output while you are working with SQL Server Management Studio, However, sometime you might find that you can’t copy/paste new line from the result grid. This is because you need to enable it in the settings as following: Right click on the Query Editor and select

How to install and configure Samba on FreeBSD

1. Search for the available version of samba #: pkg search samba 2. Install samba #: pkg install samba48 3. Add Kernel options #: nano /etc/sysctl.conf kern.maxfiles=25600 kern.maxfilesperproc=16384 net.inet.tcp.sendspace=65536 net.inet.tcp.recvspace=65536   4. Edit samba config file #: nano /usr/local/etc/smb4.conf [global] workgroup = MYGROUP realm = mygroup.local netbios name = NAS [your share name] path = /home/username public

Allow SSH with root user in FreeBSD

After install FreeBSD in Hyper-V, I found out that I can’t using SSH with root user: It will keep asking for Password even you have input the correct one. After some searching, I realize that to enable or disable root login, you need to set this in /etc/ssh/sshd_config file. # cd /etc/ssh # vi sshd_config

How to fix unmet dependencies error when installing SQL Server 2017 on Ubuntu 18.04

Updated 31/05/2018: This is just a workaround, looking forward to microsoft/Ubuntu’s official support. When you try to install SQL Server 2017 on Ubuntu 18.04, you might get below error messages: After searching for a while in Google, I found the below answers: https://askubuntu.com/questions/930712/installation-problems-with-ms-sql-server-for-linux To Wrap it up: apt-get install -y libjemalloc1 libsss-nss-idmap0 libc++1 gawk curl