Database Recovery

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 »

Setting up the Hardware for SQL Server Implementation – Invest in Memory

In this article we look at SQL Server implementation in mid to large sized firms and look at the key requirement for substantial memory to improve the performance of the database server. Opting for a database solution in a mid to large sized firm is a complex process. It is even more difficult if you are updating from a legacy database system or upgrading from an open source solution to SQL Server. There are several factors to keep in mind, starting from licensing costs to the kind of...

Read more »