Category: DBMS Concepts
-
Methods to change windows authentication to mixed mode (windows and SQL server authentication)
Hey guys, In this blog I am going to explain you about different methods to Enable Mixed Mode authentication Ø Enable Mixed mode authentication using Management studio Ø Enable Mixed mode authentication using Registry editor 1. Enable Mixed mode Authentication using MANAGEMENT STUDIO- STEP-1: Open a server in Management studio. Go to server -> right click -> instance ->properties…
-
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…
-
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…
-
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…
-
Enabled DAC to connect remotely
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you how to use the DAC and how to enable it for remote connections. DAC- The dedicated admin connection (DAC) can assist you in getting out of a bind. This was created to assist you in connecting to SQL Server and…
-
Deterministic and Nondeterministic Functions
Deterministic functions: Deterministic functions always result in the same output every time they are called with a fixed set of input values and given the same condition of the database. For example, AVG() function always results the same result given the qualifications stated above. Nondeterministic functions: Nondeterministic functions result in different output each time they…
-
Page Life Expectancy (PLE) in SQL Server
Hey guys, In this blog I am going to explain you about Page Life Expectancy and How to monitor it. Page Life Expectancy (PLE)- Page Life Expectancy (PLE) is an age of a data page in seconds in the buffer cache or buffer memory after querying the tables with the loading data page into the buffer memory.…