Database Recovery

Locking in SQL Server

In this article we look at how locking happens in Ms SQL server and learn about their types Whether you know or not, the credit for handling a number of transactions in SQL Server goes to its Locking strategy. There are in fact, different types of locks for different types of query plans. This is not all; a user can make the server create more locks like the shared, holdlocks and noholdlocks for specific queries. Locking in SQL server can be done both at a larger level and at a smaller...

Read more »

Why is a database solution way better for storing records than a spreadsheet like Ms Excel

In this article we will explore the rationale behind using a database solution like SQL over a spreadsheet like Ms Excel in context of small and medium sized firms. Small Businesses are often at a loss while deciding to choose between a spreadsheet and a database solution while looking to execute routine tasks. Although, both have special features, yet it becomes difficult sometimes figuring out which one to use for what. Spreadsheets like MS Excel, a program which is a part of Microsoft...

Read more »

Why do small businesses need a database management system and how does SQL Server stack up as a viable option

In this article we look at the fundamental question of Small Businesses asking themselves the relevance of a Database system in their organization. We would also look at the possibility SQL Server playing the role of an entry level RDBMS solution for small firms. Businesses no matter big or small are now excelling way better than they used to with the help of database management systems. DBMS or the Database Management Systems have eliminated the use of multiple data files or spreadsheets...

Read more »