SQL Server Solutions

5 SQL Server Worst Practices You Must Avoid at All Costs

In this article, we have addressed some of the most common mistakes and worst practices users should avoid at any cost. Worst practices or common errors can vary from business to team; or team to business. Just like finding a solution for any problem, the first step here also is for the user to recognize the problem. Once the user is acquainted with the problems, or errors he is more likely to avoid them in the future. Here is a list of some of the worst practices that you can go through...

Read more »

10 Key Questions You Should Ask before Formulating a Disaster Recovery Plan for SQL Server

Know the key questions you need to ask while you are working on a Disaster recovery plan. Although it is a given that all organizations making use of SQL Server should also be making use of a disaster recovery plan, there are certain situations that end up putting you in a situation where your disaster recovery plan does not end up being as good as it was expected. What will be your way out in this kind of a situation? What will you do if there is a disaster and you are unable to perform...

Read more »

5 Salient Aspects to Keep in Mind while Defining Retention Period for Database Backups

In this article, we have addressed some basic aspects which the user should keep in mind while setting retention periods for their Database backups. Creating and maintaining backups of databases is one of the foremost priorities of any organization. Backups are important for multiple reasons, which include data security, legal requirements, recovery reasons, basic data accessibility etc. So, it is critical to have a proper plan to create database backup plans and database recovery plans....

Read more »