SQL Server Reporting Services (SSRS) The SQL Server Reporting Services (SSRS) is a framework of reporting mechanisms such as the Report Builder, Report Designer, Report Manager and Report Server that work together through a Web interface to enable the development of concise interactive reporting solutions in print or Web format. Report Builder and Report Designer…
Category: IT Tips
Hassle-free Email Migration & Conversion
This useful program solves a problem most of us have often wrestled with: If you’re moving to a new e-mail client, how can you get all your old e-mails into your new software? It solves the problem neatly by taking you through a few simple steps. It will convert your old mail to your new…
How to import large data bases to phpMyAdmin
You cannot import mysql database of file size more than 50 MB from your site’s PHPmyAdmin. Even though its compressed with gzip or zip, your_database.sql.gz shouldn’t exceed that maximum file size limit. So how to import larger mysql database? The workaround is importing it with Bigdump script. You can download the script from here. Watch…
How to install MySQLi extension via cPanel / WHM
In order to enable to MySQLi extension in your WHM, please follow these steps: Log into the WHM with your root credentials. Go to the “Easy Apache (Apache Update)” menu, located in the “Software” section or use the search box to find it. On the Easy Apache page, make sure your Previously Saved (Default) configuration…
Ubuntu Basics – How to Set A Static IP
This tutorial explains how to set a static IP on an Ubuntu system from the command line. Step 1: sudo nano /etc/network/interfaces Step 2: If DHCP has configured, you will see auto lo eth0 iface lo inet loopback iface eth0 inet dynamic Step 3: Change dynamic value to static and keep adding Values shown in…
What is RTO, RPO, WRT, MTD ?
When it comes to Disaster Recovery & High Availability Techniques, these Acronyms are a must. So will discuss a bit in further. 1. Business as usual At this stage all systems are running production and working correctly. 2. Disaster occurs On a given point in time, disaster occurs and systems needs to be recovered. At…
How to Enable JAVA application High Availability
HA-JDBC is a JDBC proxy that enables a Java application to transparently access a cluster of identical databases through the JDBC API. HA-JDBC has the following advantages over normal JDBC: High-Availability The database cluster is available to service requests so long as at least one database node is active. Fault Tolerance Because HA-JDBC operates via…
Free Web Load Balance Solution
When multiple web servers are present in a server group, the HTTP traffic needs to be evenly distributed among the servers. In the process, these servers must appear as one web server to the web client, for example an internet browser. The load balancing mechanism used for spreading HTTP requests is known as IP Spraying….