PRINCE2 project management with OpenProject

https://www.openproject.org/prince2-with-openproject/ When managing complex projects, it is beneficial to use a project management methodology for guidance. PRINCE2 is one of the most popular and widely used methodologies available. What is PRINCE2? PRINCE2 (or Projects in Controlled Environments) offers a structured process for projects & provides recommendations for each project phase. It is one of the leading project management methodologies […]

Quickstart: Install SQL Server and create a database on Ubuntu

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017 Install SQL Server To configure SQL Server on Ubuntu, run the following commands in a terminal to install the mssql-server package. Important If you have previously installed a CTP or RC release of SQL Server 2017, you must first remove the old repository before registering one of the GA repositories. For more information, see Change repositories from […]

MSQL backup on linux

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q “BACKUP DATABASE [MYDATABASE_DEV] TO DISK = N’/var/opt/mssql/data/MYDATABASE-20180615.bak’ WITH NOFORMAT, NOINIT, NAME = ‘MYDATABASE_STD50_DEV’, SKIP, NOREWIND, NOUNLOAD, STATS = 10”

MSQL on linux : Fix locale::facet::_S_create_c_locale name not valid

https://github.com/Microsoft/mssql-docker/issues/163 https://github.com/Creepsky/creepMiner/issues/122 First, this report is not just about issue with mssql-docker but I suspect it is related to about mssql-tools for Linux in general, more specifically the sqlcmd. (Not sure where would be better and more accessible by others place to report it.) I run docker container based on ubuntu:latest image and I install the mssql-tools in order to be able […]

MSQL Pssdiag/Sqldiag Manager

https://blogs.msdn.microsoft.com/sqlcat/2017/08/11/collecting-performance-data-with-pssdiag-for-sql-server-on-linux/ https://github.com/Microsoft/DiagManager https://github.com/Microsoft/DiagManager/tree/master/LinuxPSSDiag What is Pssdiag/Sqldiag Manager? Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems. This is the same tool Microsoft SQL Server support engineers use to […]

Contact/Organization not showing to Non-Admin User

https://discussions.vtiger.com/discussion/184731/lead-is-not-showing-to-non-admin-user ************** CREATE TABLE IF NOT EXISTS `vtiger_cv2group` ( `cvid` int(25) NOT NULL, `groupid` int(25) NOT NULL, KEY `vtiger_cv2group_ibfk_1` (`cvid`), KEY `vtiger_groups_ibfk_1` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ************** CREATE TABLE IF NOT EXISTS `vtiger_cv2role` ( `cvid` int(25) NOT NULL, `roleid` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ************** CREATE TABLE IF NOT EXISTS `vtiger_cv2rs` ( […]

How to upgrade Vtiger 6.5 to 7.1 – Tutorial

https://www.vgsglobal.com/blog/upgrade-vtiger-6-to-7/ Two ways to upgrade Vtiger 6.5 to 7.1 There are two ways of updating vtiger to a new version. Option #1 – Upgrading Vtiger Using Patch The first way is to use the patch provided by Vtiger. This method is very similar to earlier versions. You will need to backup your files and database, download the patch, […]