Database Recovery

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 »

Dealing with a Login failed for user Error 18456 while working on SQL Server

SQL Server Database Recovery, SQL Server Solutions August 18, 2016

In this article we attempt to diagnose SQL Server Error 18456 and look at its possible causes The Ms SQL Server application finds a place across an array of organizations in the world today ranging from small businesses to huge corporations. While the software is robust, it is hardly free from errors or knick knacks. It is not uncommon to come across errors messages while working on SQL Server. Amongst those that are more frequently seen is error ID 18456 which often occurs when the user...

Read more »