SQL Server High Availability and Disaster Recovery – An Overview

This post outlines a summary of the meaning and need of High Availability and Disaster Recovery in SQL Servers. The post further explains various High Availability solutions. What are High Availability and Disaster Recovery? High availability refers to the process of measuring how a system remains accessible in case a system component fails. Conventionally, to implement it, multiple levels of load balancing and/or fault tolerance capabilities are built.  Disaster recovery, on the other hand...

Read more »

3 Provisions to Ensure Your SQL Server Database is Disaster Ready

The aim of this post is give users some insight on how to check whether an SQL backup and restore strategy is functional. The post also explains how administrators can check whether or not the system is disaster ready. 1.Managing Backup Media There are certain provisions that every backup plan designed to recover SQL Server database must have. The provisions are aimed at managing backup media which are described below: A plan for overwriting backup media. Management and tracking...

Read more »

3 Useful Tips on Creating and Managing Calculated Fields in Excel Pivot Table

Pivot table can sum up the values of columns when it is created. And to calculate the values of rows, you can use the calculated fields manually. The image below shows the sales volume of two products. To make things easier, we have created a pivot table in a new worksheet. You can see that the total sales volume of the months will be automatically calculated. But the total sales volumes of two products of each month don’t appear in this table. Hence, you can add the calculated...

Read more »