Updated on: 14 Nov 2023

How to Restore Database In SQL Server Restoring a SQL Database Backup can be an important part of ensuring the security and integrity of your data. Using SQL Server Management Studio, it is possible to restore backups created with either full or differential backups. In this guide, we will discuss how to restore the database […]

Updated on: 12 Oct 2023

Backing up your SQL Database is a critical part of any data management strategy. Regular backups ensure that, in the event of a problem, you can restore your database quickly and easily. As a system administrator, it is your responsibility to take regular backups of your organisation’s databases. However, taking a DB backup operation in […]

Updated on: 16 Oct 2023

SQL Server 2019 installation – Express Edition on Windows Server 2016 What is SQL Server 2019 Express and how does it compare with SQL Server 2019? Before we begin the SQL Server 2019 installation process let us review the difference between SQL Server Express and its other commercial editions. Microsoft SQL Server Express is a […]

Updated on: 10 Aug 2023

Expressmaint utility is a very handy tool to backup and do different maintenance activities for SQL server 2005/2008 databases. You can perform various kind of administrative jobs in your SQL server database without having a in depth knowledge of SQL server maintenance facilities available with it. The jobs that can be done using this small […]

Updated on: 20 Oct 2023

If you do not have Administrator privilege on the MS SQL Database server (common for shared hosting environments), you may often face a problem with shrinking the database or the transaction log, specially if the disk space is limited for you. You can easily shrink your database and log files using the simple scripts given […]

Updated on: 14 Aug 2023

There is often a need for a hot backup of a live SQL server database as a standby. To accomplish this a stored procedure can be created in the master database and called periodically using SQL server Jobs with proper arguments. The script provided below is for MSSQL server 2005 database but the same can […]

Updated on: 20 Oct 2023

Here are a couple of tweaks which can improve your mysql server performance significantly. We implemented this on our hosted servers and the php/mysql queries for dynamic DB driven applications  improved by over 50%. The following are the relevant commands which can be inserted in the mysql conf file, which is normally located at /etc/my.cnf. […]

Updated on: 13 Nov 2023

There is an issue with Crystal reports support with Plesk installation . We have found that in spite of  installing the crystal report runtime redistributable package the report won’t show in the web page on any hosted domain in Plesk, but if you run the report under a virtual directory under the default website the […]