Database Recovery

9 Practical Applications of SQL Server Transact SQL (T-SQL)

In this article we look at Transact SQL and look at its 9 practical applications SQL basically stands for Structured Query Language meaning SQL server makes use of a structured language for taking in queries and sending relevant information. All RDBMS make use of a standard query language for processing data, but not all of them necessarily use the same language. Many software have taken from SQL, and modified it a bit, turning it into another language for their software. T-SQL has been...

Read more »

How to Sharpen your Disaster Recovery Plan by Setting KPIs

In this article we understand why it is important to set KPIs for any disaster recovery plan that you create for your SQL Server implementation. There is a lot that goes into creating an efficient disaster recovery plan that is suitable for not only fighting all kinds of disasters, but is also able to recover multiple data forms. Although any organization would aim to create a plan suitable for all situations, the plan might not end up being as good as the organization would want it to be....

Read more »

How to Plan for Both Sporadic and Chronic Incidents in a SQL Server Disaster Recovery Plan

In this article we consider contingencies to deal with both chronic and sporadic incidents and formulate a comprehensive SQL Server disaster recovery plan. While creating a disaster recovery plan for SQL Server data, your plan should not just be aimed at protecting the assets, but also focus on what kind of assets is it meant for. A lot of thought and planning goes into creating a disaster recovery plan, and you should always create a plan depending on what kind of data do you count as...

Read more »