Database Solutions

SQL Server Backup Options: A Quick Roundup

In this article, we take a quick look at the several options available in MS SQL Server The SQL Server database is today counted as one of the best applications in its class. One of the key reasons behind its popularity is its robustness and backup features which enable business continuity.  Data backups are necessary to protect loss of data from many hazards like hardware malfunction, natural calamities or flaws related to media. Prominent backup options available in SQL Server Full...

Read more »

Microsoft SQL Server Compact – A Primer

In this article we look at often overlooked Microsoft SQL Server Compact Edition and understand its relevance. In a hyper-connected information driven world, databases play a critical role in storing and managing data effectively. Over time several types of databases have evolved which are tailored to specific needs. If we take the case of SQL Server, there are editions which are aimed at large companies (Enterprise Edition) to ones that are targeted towards small businesses (Express...

Read more »

Key Storage Considerations to Keep in Mind during a SQL Server Setup

In this article we look at certain storage considerations (disk drives) that one needs to keep in mind while implement a SQL Server instance It is difficult to reach to a decision when it comes to how many disk drives are to be purchased for installing a new SQL Server instance. The need is often dictated by business requirements along with the need for redundancy and business continuity.  This is also an issue of storage space and capacity. One would also have to keep in mind the...

Read more »