Database Solutions

8 Essential Steps to Fix an Error in a Production SQL Server Database

In this article, we look at resolving an error that you may experience on a Production SQL Server database Facing an error in the Production server while using SQL Server is a great obstruction. You cannot continue working till you do not do away with the error. So here are a few things you should do every time you come across error in the production server. Find out the scope of corruption: The most important thing to do is to find out what is the scale of corruption. If it is large...

Read more »

How to Set up an Always On Availability Group in SQL Server 2016

In this article, we look at the process setting up an Always On Availability Group in SQL Server Standard Edition in a stepwise manner. With the coming of AlwaysOn Availability Groups in the Standard Edition of SQL Server 2016, the deprecated feature of Database Mirroring will be replaced. The Standard Edition of 2016 supports Basic Availability Groups, which is another name for the AlwaysOn Availability groups in the Enterprise edition. Although setting up Basic Availability Groups is very...

Read more »

How Frequently You Should Run DBCC CHECKDB in SQL Server

In this article, we look at factors which a DBA considers before deciding the required frequency of running DBCC CHECKDB. While running SQL Server, corruption of database is the biggest fear of the DBA. And if that corruption is transported to the backups, it becomes even more problematic. To avoid corruption of databases from expanding, and becoming a part of your backups, it is important to regularly apply security checks to your databases. DBCC CHECKDB is one of the most preferred...

Read more »