SQL Server Database Recovery

Key Advantages of AlwaysOn Availability groups from the perspective of business continuity

With business becoming increasingly competitive, even the shortest of the downtimes can prove risky for the reputation of an organization. Hence from a perspective of business continuity and data recovery, SQL Server administrators have for years relied on disk mirroring to keep things going in case of a fault. However mirroring has several limitations and this had lead Microsoft to roll out AlwaysOn availability groups from its 2012 SQL Server iteration which offers a whole deal of reliability...

Read more »

Understand the reasons behind permission denied errors occurring while accessing stored procedures in MS SQL Server

Stored procedures in MS SQL Server offer us a great deal of flexibility by which users can avoid writing queries every time for performing tasks that are typically repeated. For the uninitiated, stored procedures are nothing but queries that you can save for future use by you and others to whom you have authorized access to. Incidentally SQL Server ships with several prebuilt procedures for the perusal of its users. Now there may be incidents where an user in your organization can complain that...

Read more »

Negotiating Out of Space Errors that Creep up in MS SQL Server

Encountering error messages while working with the MS SQL Server application is a par for the course for most database professionals. However receiving an out of space error message may be a rare occurrence and it can leave you bewildered if you thought you had enough physical space on the system. In this article we would look at the causes behind such an error being returned and look at rectifying the situation.   Possible Causes behind an Out of Space error message If you have...

Read more »