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 →
Microsoft 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 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 →
Using Freetds we can connect php code in Linux to Microsoft Sql Server.
We start from a fresh installation of Ubuntu 11.04.
# apt-get install dpkg-dev
# apt-get install apache2
# apt-get install php5
# /etc/init.d/apache2 restart
To check that php5 works fine
# php -v
PHP 5.3.5-1ubuntu7.10 with Suhosin-Patch (cli) (built: Jun 19 2012 00:54:05)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
Now if all works fine you can continue. Click here to continue reading Php code in Linux to Ms Sql Server using Freetds