Blogs

Managing Azure VM-level Backup

Managing Azure VM-level Backup.jpg

Backups are very crucial in any IT related operations. They are your fallback mechanism, just in case things go southwards. In this blog, we will discuss about configuring Azure VM-level backup.

Topics: Microsoft Azure Azure

Tech stories making the rounds - Week 49, 2017

tech digest  week 49.jpg

Topics: Digital Transfrmation bigdata Enterprise Mobility Enterprise Collaboration Cloud Artifical Intelligence

Azure Site Recovery (in Preview for Azure to Azure)

Azure Site Recovery  (in Preview for Azure to Azure).jpg

Azure Site Recovery provides Business Continuity solution by helping us to replicate Azure on-premises workload to Azure. It replicates workload to secondary location either Azure or on-premises. So Azure Site Recovery helps to deploy simple BC DR Solution and options to store data on on-premises or on Azure. It has various feature like encryption while replication data, app consistent replication and very less RPO and RTO to meet your requirements. You can test failover by the feature provided by ASR for DR drill too.

Topics: Microsoft Azure Azure Business Continuity Disaster Recovery BCDR

Using Protractor for AngularJS Automation Testing

Using protractor for angularjs automation testing.jpg

In our application, which is built using AngularJS, we required to write an automated script that is supposed to run on headless browser (without invoking browser).
However, Selenium locators were not able to find the elements in headless browser mode. Protractor comes to our rescue which supports locating extra HTML attributes such as ng-repeater, ng-controller, ng-model using headless browser- PhantomJS.

Protractor is an open source functional automation framework designed specifically for AngularJS web applications. This tool is a combination of technologies such as Jasmine, Selenium Webdriver, and Node.js etc. It’s a wrapper built on top of Selenium Webdriver and thus provides all the capabilities of Selenium along with many useful additions.

Protractor.png

Topics: selenium Automation testing AngularJS Protractor

Backup and restore database using SQL stored procedure

backup-and-restore-database-using-sql-stored-procedure.jpg

Many times we need to backup and restore our databases on daily basis. We do this all process manually which increases our repetitive work. For the same, here we have SQL stored procedures to make it automated and easy which is helpful for doing database backup and restore. We can also make SQL job to run it automatically. Here is a sample code:

  • To Backup databases

USE [master]
GO
/****** Object: StoredProcedure [dbo].[DBbackup] Script Date: 11/03/2017 7:35:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Pranita Pendharkar>
-- Create date: <11-03-2017>
-- Description: <To create database backups >
-- =============================================
/*
EXEC [DBbackup] 'DBbackup'
*/
Alter PROCEDURE DBbackup

@name VARCHAR(MAX) = '' -- DB NAME TO CREATE BACKUP
AS
BEGIN

DECLARE @path VARCHAR(256) -- path of backup files
DECLARE @fileName VARCHAR(256) -- filename for backup
DECLARE @fileDate VARCHAR(20) -- used for file name

SET @path = 'E:\Data\FTP\Backup\'

-- specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)

BEGIN
SET @fileName = @path + @name + '_' + @fileDate + '.BAK'
BACKUP DATABASE @name TO DISK = @fileName
END
END
GO

Likewise just pass names of db’s to stored procedure to create backup.
EXEC [DBbackup] 'Database1'
EXEC [DBbackup] 'Database2'

Also there are different database backup types

Topics: SQL SQL Server database

e-Zest Solutions is digital experience engineering company with facilities in the United States (Detroit & San Jose), Germany (Hannover), United Kingdom (London UK) and India (Pune) with global clientele. Our services include custom software development, offshore software development, UX consulting, BigData, Managed cloud Services (Azure & AWS), SharePoint consulting/Migration, Enterprise Java application development, Automated software testing services.