SQL Server Database Recovery

Using Solid State Drives to Improve the performance of SQL Server

In a competitive world where time is a critical constraint, businesses are always in the lookout for technological innovations that can give them an added advantage over their peers. Now if your SQL Server driven application is able to process data requests at a higher speed and become less prone to crashes then it can surely give a flip to your business applications. By using solid state drives(SSDs) instead of traditional mechanical hard drives, you can eliminate IO issues with ease and...

Read more »

Quick tips to optimize your corporate applications for SQL Server

In the software arena, the way applications are designed is often linked to the end objective. However in case of many corporate application including legacy ones, old applications end up getting recreated for new system and databases without considering their salient points. Today a large number of companies run applications that use the SQL Server backend and some of them were not designed while keeping the best performance aspects in mind. So an increase in the number of transactions...

Read more »

Quick Capacity Planning tips before a SQL Server Implementation

As the need to process more and more data becomes a matter of necessity for small and medium firms, a large many of them are looking at using SQL Server as their data repository. With large enterprises, the availability of trained manpower makes the installation of SQL server a hassle free process. However the reverse is true for small companies where the generic IT guy is called out to run the server implementation. In many such companies capacity planning is typically avoided and it can lead...

Read more »