University, College and School It Projects, Phagwara

We provide computer/IT projects for University, Colleges and Schools in diverse categories of training, summer term, term papers or capstone, Ph-9501233660

13/02/2023

02/02/2023

Password Hashing in .Net 7

How to hash password in .NET 7 Today I would like to show you guys how I'm hashing the password, storing it into the database and then verifying the hashes once the user is calling the log...

02/02/2023

EXPORTING BREAKPOINTS from Visual Studio can be very helpful when you need help from a someone to recreate a bug and/or fix an issue which you’ve already started debugging and you don’t want for them to start their investigation from the beginning.

01/02/2023

𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐫𝐞𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧

“Database replication can be used in many database management systems, usually with a master/slave relationship between the original (master) and the copies(slaves)”.

A master database generally only supports write operations. A slave database gets copies of the data from the master database and only supports read operations. All the data-modifying commands like insert, delete, or update must be sent to the master database.
Most applications require a much higher ratio of reads to writes; thus, the number of slave databases in a system is usually larger than the number of master databases.

𝐀𝐝𝐯𝐚𝐧𝐭𝐚𝐠𝐞𝐬 𝐨𝐟 𝐝𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐫𝐞𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧:

𝐁𝐞𝐭𝐭𝐞𝐫 𝐩𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞: In the master-slave model, all writes and updates happen in master nodes; whereas, read operations are distributed across slave nodes. This model improves performance because it allows more queries to be processed in parallel.

𝐑𝐞𝐥𝐢𝐚𝐛𝐢𝐥𝐢𝐭𝐲: If one of your database servers is destroyed data is still preserved. You do not need to worry about data loss because data is replicated across multiple locations.

𝐇𝐢𝐠𝐡 𝐚𝐯𝐚𝐢𝐥𝐚𝐛𝐢𝐥𝐢𝐭𝐲: By replicating data across different locations, your website remains in operation even if a database is offline as you can access data stored in another database server.

31/01/2023

Inner Join in SQL -

Inner joins combine records from two tables whenever there are matching values in a field common to both tables.

We can use INNER JOIN with the Departments and Employees tables to select all the employees in each department.

To know more, DM me