ISOLATION LEVEL IN SQL Server

ISOLATION LEVELS PROBLEM SOLUTION SYNTAX LOST UPDATE SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED DIRTY READ READ COMMITTED READ SET TRANSACTION ISOLATION LEVEL READ COMMITTED NON-REPEATABLE READS REPEATABLE READ SET TRANSACTION ISOLATION LEVEL REPEATABLE READ PHANTOM READ SERIALIZABLE SET TRANSACTION ISOLATION LEVEL SERIALIZABLE LOST UPDATE A lost Update happens when one transaction updates a record and …

ISOLATION LEVEL IN SQL Server Read More »

TRIGGERS in SQL SERVER

A trigger is a Stored procedure that gets Activated on special events. There are two kinds of triggers (DDL) Data Definition Language triggers and (DML) Data Manipulation Language triggers. Unlike Stored Procedures you cannot explicitly invoke the code of a trigger, triggers are activated automatically on special events like INSERT, UPDATE, or DELETE. You cannot …

TRIGGERS in SQL SERVER Read More »

How to install SSL Certificate on Website without C-panel on UBUNTU Server Using Command line.

You have your website installed on Ubuntu server and your website is Hosted on Cloud Platforms like  “Google cloud” or “Oracle Cloud.”  and you don’t have a cPanel installed on your system and You want to install SSL certificate on your website and you are seeing “Not Secure” Exclamation while browsing your website , This …

How to install SSL Certificate on Website without C-panel on UBUNTU Server Using Command line. Read More »