SQL DBA: Backups
Description: Copy of the database that is used to recover the data after the system failure. Backups are used as safeguards for databases because data may be lost due to…
Read MoreAdding data file to Mirroring database
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
All 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
Inplace Upgradation Introduction: Upgradation involves overwriting existing SQL Server instance and upgrading from…
Read MoreStep-by-step procedure for performing a switchover between a primary database and a standby database
Description: 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 MoreSteps to create ACFS file system
Step 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 MoreLog Shipping issues in SQL Server. Out of Sync is the Common issue in Log Shipping. It can be raised when Transaction Log Backups are not applied to the Secondary Server.
SQL 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 MoreHigh Level Steps for Datagaurd SwithOver
Please 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 MoreGenerate OTP and Integrate SMS API
1. 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 MoreAutomate send report to Finance Team
1. 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 More