/Technology

Category : Technology

6 02, 2017

Backup & Replication: Why do you need both?

By | February 6th, 2017|0 Comments

Most of the business organization’s dilemma on Backup and Replication is to choose what's right for their business to protect their critical data from getting lost. Backup and Replication is necessary for avoiding downtime of your business in order to make sure that there is [...]

19 01, 2017

What Do I Need ? A Backup ?? No, A Replica ?? Indeed , All I Need Is Zero Downtime !!

By | January 19th, 2017|0 Comments

For any business, backup and replication are two essential attributes which are analogous in most aspects except for 2 technical parameters that defines them. To be precise, both backup and replication aim at providing Disaster Recovery. RPO and RTO are the two parameters that differentiates [...]

13 06, 2016

HTTP and HTTPS: What do they do & How are they different?

By | June 13th, 2016|0 Comments

Hypertext Transfer Protocol (HTTP) is a protocol used in networking. When you type any web address in your web browser, your browser acts as a client and the computer having the requested information acts as a server. When client requests for any information from the [...]

24 05, 2016

Stored Procedure Recompilation in MS SQL Server

By | May 24th, 2016|0 Comments

In a Relational database management system (RDBMS), a stored procedure is a set of Structured Query Language (SQL) statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs. Stored Procedure is [...]

18 05, 2016

What is a Web Server

By | May 18th, 2016|0 Comments

A Web server can be either a computer program or a computer running a program that is responsible for accepting HTTP requests from clients, serving back HTTP responses along with data contents, which usually are web pages such as HTML documents and linked objects on [...]

17 05, 2016

Table Scan – A Brief Overview

By | May 17th, 2016|0 Comments

In RDBMS table scan event occurs while querying data from table of a database . When SQL Server need to process more data or entire data in the table to get the result set of given queries criteria  that is called TABLE SCAN.  Table scan [...]

17 05, 2016

Server Side SQL Script and Client Side SQL Script

By | May 17th, 2016|0 Comments

Server Side Scripts and Client Side Scripts are different things but both Scripts are constructed using the same T-SQL queries. These both scripts are constructed  using Data Definition Language (DDL)  , Transaction Control (TCL) , Data Manipulation Language (DML)  ,Data Control Language (DCL) ,If else [...]

11 05, 2016

Retention Policies – A Vembu’s Approach

By | May 11th, 2016|0 Comments

Retention In general, retention denotes retaining something or continue to possess something in order to use later. From the backup software perspective, retention refers to retaining the backup data in the backup storage that complies with some policies which is to avoid data redundancy in [...]