Database Recovery

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 »

Using SQL Server Express Edition as a production server – completely feasible and ideal for small to many mid sized firms

In this article we explore the possibility of using SQL Server Express edition as a true production server and contemplate its limitations The SQL Server database has different editions designed for different needs. Of these the Express edition is specifically tailored for smaller workloads. The fact that it is completely free makes it immensely useful for many small to midsized firms. While there is a reasonable limit on database size, the application can be safely used for commercial...

Read more »