Adding data file to Mirroring database What is Mirroring? Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as…
Read MoreAll Redo log group Members are in active state, ORA-20 max number of processes exceeded, Database went hung state After restart A) All Redo log group Members all are in…
Read MoreInplace Upgradation Introduction: Upgradation involves overwriting existing SQL Server instance and upgrading from…
Read MoreDescription: We can alter the database roles of primary and standby according to planned maintenance. During a switchover, the original primary database converts to a standby role, and the original…
Read MoreStep 1: List the disks using the below command. #oracleasm listdisks Step 2: Create the oracleasm disk using the below command. #oracleasm createdisk ARCH03 /dev/mapper/DISK014_ARCH_4T1 Step 3: Scan the disks…
Read MoreSQL Server issue and solution Error: Log Shipping issues in SQL Server. Out of Sync is the Common issue in Log shipping. It can be raised when Transaction Log Backups…
Read MorePlease find the following High level steps to convert the primary to standby using switch over method .With this method the failover and switchover happens without much downtime . It…
Read More1. Overview This document talks about how to generate OTP & Integration of SMS. 2. Technologies and Tools Used The following technologies has been used to Integrating SMS & generating SMS. Ø MS SQL Server Ø DotNet & Angular 3. Use Case Assume that there is a requirement to generate OTP & Send SMS to Respective Person. 4. Architecture Following steps explains in detail, Step 1: It validates and generate OTP , It allows to generate New OTP Maximum 3 times and resend OTP Maximum 5 Times. It is not allowed Maximum of OTP. This Query for generating OTP. SELECT CAST(1000000-CEILING(RAND()*899003)+DATEPART(MS, GETDATE()) AS INT) Step 2: Generating OTP and insert OTP into table. BEGIN SET NOCOUNT ON; DECLARE @EmployeeReferralID int; DECLARE @OTP varchar(6); DECLARE @CurrentDatetimeIST datetime=(SELECT (GETDATE() as TIME ZONE ‘Eastern Standard Time’) AT TIME ZONE ‘India Standard Time’); SELECT @OTP= CAST(1000000-CEILING(RAND()*899003)+DATEPART(MS, GETDATE()) AS INT) END Step 3: Verify OTP for respective Mobile Number. BEGIN DECLARE @OTPInput varchar(6); DECLARE @OTP varchar(6); SELECT @OTP=top 1 otp from tblemployeeOTP where mobileno=@mobileno order by desc; if(@OTPInput=@OTP)…
Read More1. Overview This document talks about how to send report with excel file automatically to Finance Team every month of 21st. This report for employee referred the candidate who will complete the 90 days and above for the current month of 21st. 2. Technologies and Tools Used The following technologies has been used to automatically send report to Finance Team. Ø MS SQL Server Ø DotNet & Angular 3. Use Case Assume that there is a requirement to automatically send report to Finance Team. 4. Architecture Following steps explains in detail, Step 1: First we have to check whether joined candidates reach 90 days for current month of 21st. To select Current Year, Month , Date and calculate candidate cross 90 days. DATEDIFF(DAY, DateofJoin, GETDATE())>=90 AND DATEDIFF (DAY, DateofJoin, GETDATE())<=Datedifference BEGIN DECLARE @DateDifference int=0; DECLARE @LastMonth int=0; DECLARE @CurrentYear int=0; DECLARE @CurrentMonth int=0; DECLARE @PreviousYear int=0; SELECT @CurrentMonth =DATEPART(mm,DATEADD(mm,0,GETDATE()); SELECT @LastMonth =DATEPART(mm,DATEADD(mm,-1,GETDATE()); SELECT @CurrentYear =DATEPART(mm,DATEADD(yyyy,0,GETDATE()); set @PreviousYear=@CurrentYear; if(@LastMonth=12) BEGIN SELECT @CurrentYear =DATEPART(mm,DATEADD(yyyy,-1,GETDATE()); END DECLARE @FromDate varchar(10), @ToDate varchar(10); set @FromDate=convert(varchar,@LastMonth) +’/’+’21’+’/’+convert(varchar,@PreviousYear);…
Read MoreDescription : Oratop is an interface that takes data from top and oracle databases on a host. The utility combines the data to OS data and session data. It allows…
Read More