databases

The procedure to change the request ID for ServiceDeskPlus MSP product (v10.5 and later) is outlined below. Navigate to the location of ServiceDeskPlus MSP installation and change into the pgsql\bin directory in a command prompt. C:\ManageEngine\ServiceDeskPlus-MSP\pgsql\bin> psql -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1 Enter the password sdp@123 Queries for the respective modules: REQUEST…

Read More ManageEngine ServiceDeskPlus MSP: Change Starting Request ID (Postgres)

The latest release of ManageEngine ServiceDesk Plus MSP changes the default user and password of the Postgres SQL database. Previously, the command to connect to the database was: psql -U postgres -p 65432 -d servicedesk -h 127.0.0.1 The new change shows that there is a change in username and password as follows: psql -U sdpadmin…

Read More ServiceDesk Plus MSP 10.5 Postgre SQL password

Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information:  https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for Memory-Optimized Tables Key Points The limits for In-Memory OLTP data is per database. The limits for Columnstore segment cache is per SQL Server instance across all the…

Read More SQL Server 2016 SP1 Edition Limit Changes

If the Forgot password option doesn’t work for you (which it really should), then you can change the password of your self-hosted WordPress login. Check the contents of wp-config.php for the database login. Use that login information for MySQL login. define(‘DB_NAME’, ‘wpdatabase’); define(‘DB_USER’, ‘wpdbuser’); define(‘DB_PASSWORD’, ‘wpdbpassword’); Replacing DB_USER and DB_NAME from that command with the…

Read More Change WordPress Password using MySQL