SQL Server Concurrency & Transaction Management

SQL Server Concurrency & Transaction Management  is a process which allows multiple users to access data and perform multiple operations maintaining data integrity and smooth execution all at the same time. Microsoft SQL Server manages concurrency control by using locks to help protect data. The locks control how multiple users can access and change shared data … Continue reading SQL Server Concurrency & Transaction Management

Features Of Database Management System?

We have all heard so much about Database management systems that sometimes we confuse the two things. One is RDBMS which is  Dr. Codd's data model which has 12 rules & the other is the software which is used to manage the RDBMS. Since , we humans love acronyms & like to shorten down everything … Continue reading Features Of Database Management System?