July 28, 2022

SQL Server Database to SQL Server Migration on Azure

SQL Server,

Methods for primary migration Even though there are different methods you can try migrating SQL Server Database to SQL Server Migration on Azure, we recommend migrating the database files to the Azure VM using a compressed backup file for best data transfer. During migration you could face some downtime so in order to reduce the…

Read more
July 7, 2020

SQL Server error 906 Troubleshooting

Database,mssql,MySQL,SQL Server,

You would have come across SQL Server error 906, when your SQL Server fails to locate any element into the SQL tables for a specific database you would probably have received the below error message: “Could not locate row in sysobjects for system catalog ‘%.*ls’ in database ‘%.*ls’. This system catalog should exist in all…

Read more
June 29, 2020

Solved: SQL Server Error 823

Server,SQL Server,

You would have faced error 823 and might have stuck from performing any Input/Output operation in your database. As you could see this error is of two types—Operating system error and Output/Input Logical Check Failed. When you get error 823 there could be data loss, inconsistencies in the file system or the database file could…

Read more
March 30, 2017

High Memory Usage in SQL – How to avoid it?

SQL Server,

When your system is short of memory, MySQL will be killed by the system itself since it can use a lot of memory. This also causes MySQL servers to face high server load. Usually when MySQL is killed, we get the message “mysqld invoked oom-killer”. In such cases it is always advisable to restart the…

Read more
March 8, 2013

SQL Server Always On Availability Group

SQL Server,

Overview: SQL server always on Availability group is a new feature developed in SQL server 2012 on the basis of SQL mirroring and Windows server failover clustering. So the environment must achieve the same requirement of the windows server failover clustering and SQL Installation. For configuration of a fail over cluster, Environment should be configured…

Read more