Database Recovery

Technical Aspects where the SQL Server Scores over My SQL in a .Net environment

Open source enthusiasts and countless database professionals today use the My SQL database successfully in running websites and applications. Not only is the database available for free, it does pack in quite a punch for most typical applications to run without a hassle. However the MS SQL Server has several key advantages over this cult open source database, especially if you are planning to run an application on a .Net environment.   Key Technical Aspects where MS SQL Server edges past...

Read more »

Should a Small Business Using Ms Access give a thought to MS SQL Server

When it comes to database solutions typically used in small businesses and even in mid tier firms, the Ms Access application seems to have a predominant presence. The overall ease of use that Access ingrains in itself along with its quick wizard features to create queries and forms, makes it a delight to use. In offices where technical hands are difficult to come by, Access serves a host of needs with minimum effort in learning its functioning Also the fact that it ships with the Ms Office...

Read more »

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 »