what is psudocolumn, Rowdepandancy and Norowdepandency in oracle A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you…
Read MoreDescription: 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 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 More