Database Recovery

Top 5 Backup Practises to Follow While using Ms SQL Server

In this article we explore five distinct best practices for backing up data from an Ms SQL Server application. Regular backups of your SQL Server database are extremely essential for assuring the security of data. It is recommended that before compiling small databases one must assure that they are supported by large back up files. This prevents loss of data. It also makes recovery of data possible, in case of any technical failure or hardware malfunction. Many Business firms create Back...

Read more »

Real world tips to help you improve the performance of Ms SQL Server

In this article we explore few handy tips designed for DBAs which can help them better improve the performance of their SQL Server implementation. Microsoft SQL server is one of the best database management system software in vogue today; both in terms of features and performance. However there are instances when we need to boost its performance. You can always have a hardware that is advanced enough to enhance the performance of your software, but enhancing the hardware is not always...

Read more »

Going for a Paid Edition of SQL Server is the Right Way for most Mid to Large Sized Firms

In this article we explore why investing in a Paid version of SQL Server like the Standard edition makes more sense for mid to large sized firms In an increasingly cost conscious world, the availability of free software is seen as a boon by many companies. With the SQL Server Express edition being available for free production use, subject to certain limitations, a number of companies are experimenting with it to save cost. While the Express edition may make great sense for small firms; for...

Read more »