Clota Blog

Category: SQL Server

  • Step by Step Configure Windows failover cluster on windows 2019

     Step by Step Configure Windows failover cluster on windows 2019- Step 1- First you need to login at the server and go to manage->add roles and features-> add failover clustering and install the features on the server and restart the server. Fig.1 Fig.2 Fig.3 Step-2 Go to failover cluster manager-> create cluster->enter server name -> run…

  • Point-in-time recovery in SQL Server

     Hey guys, In this blog we will discussed about point-in-time recovery in SQL Server and how to perform it and also we discussed on full, differential and transaction log backup. 1.       Full backup – A Full backup is a complete backup of a database. The full backup contains all the  data in a database and…

  • View in SQL Server

    Hello guys, In this blog, I am going to explain you about a view and how to create a view inside the database. View– A VIEW in SQL Server is like a virtual table that contains data from one or multiple tables. It does not hold any data and does not exist physically in the…

  • Trigger Vs Stored Procedure in SQL Server

    Hey guys, in this blog we will learn about the differences between Triggers and Stored Procedures. Both perform a specified task but the major difference comes in the execution part. Triggers are called automatically while the stored procedures are invoked explicitly by the user. 1. Execution: We can execute a Stored Procedure whenever we want with…

  • Cursor In SQL Server

    Hello guys, In this blog, I am going to explain you about the Cursor and how to perform a cursor inside the database. Cursor- Cursor is a Temporary Memory or Temporary Work Station. It is Allocated by Database Server at the Time of Performing DML (Data Manipulation Language) operations on Table by User. Cursors are used…

  • Pages and Extent in SQL Server

     Hey guys, In this blog I am going to explain you about Pages and Extent in SQL Server and also different types of pages in SQL Server Pages – A page is a unit of data storage in SQL. The size of a page is 8Kb. The data rows are put on the page serially after…

  • ACID Properties of RDBMS

     Hii guys, I hope you are doing great, Today here I am going to explain you about the ACID properties of RDBMS and its types. Transaction- Any operation that reads from or writes to a database is referred to as a transaction in relational databases. A transaction is a logical unit of work that can…

  • SQL Server Network Configuration

    Hey guys, hope you are doing great. In this blog I am going to explain you about SQL Server Network Configuration and enabling/disabling different protocols. SQL Server Network Configuration – SQL Server Network Configuration involves enabling the protocols that manage the connection to the SQL Server and configuring the available options for these network protocols. It…

  • Database Maintenance Plan

    Hii guys, I hope you are doing great, today here I am going to explain you about the Database Maintenance Plan.  Database Maintenance Plan- A database maintenance plan is a set of specific, proactive tasks that need to be performed regularly on databases to ensure their adequate performance and availability. Uses of Maintenance plan– The…