Database Recovery

Negotiating delay in Query times and Improving Performance

The MS SQL Server is often used to run complex applications that are used simultaneously by different users. At times you may experience a scenario where a query run on the database simply takes a way long amount of time to execute. If many large queries get in the queue, you have a situation where the application may seem unresponsive. Let’s look at the reason behind queries getting delayed and resolving the possible issues.   A Large Query get assigned to numerous cores When you...

Read more »

Choose SQL Server over the Ms Access Database if your Business is spreading across different locations

Any company that witnesses growth needs to align its IT resources to meet the new business requirements. Now if your company has started to grow and is spreading across different locations, sticking on to the Ms Access database is not a wise choice. Let’s explore this with an example. An independent store was running its line of business application on an Access database with relative ease. Now when it starts operations across multiple cities, it needs the application to store data on the...

Read more »

Understanding the Concept of High Availability and How it is achieved in SQL Server

In a hyper connected world, the idea of long server or application downtimes does go well with businesses. Hence there is an increasing emphasis on making application available around the clock without fail. Now the concept of high availability is intrinsically linked to the expectation of the user base of an application. This is typically measured against the actual time a service or application was up against the expected uptime and result multiplied by hundred to get the percentage. A lot of...

Read more »