November 17, 2020
Now run MySQL instance in one machine itself!
Database,The most common dilemma we face today in production is with servers runningolder versions of Mysql and if we need to upgrade to a relatively latest version what will happen to clients who use the older version of Mysql and their applications. Will they stop working? Do they need to upgrade their applications related to…
Read more
August 6, 2020
Rebuild corrupter & missing *.db Zone files
Database,The Zone files contain namespace details. By default, they are stored in the named working directory located in /var / named/, and each zone file is named in the zone statement according to the file option. Usually in a manner that relates to the domain in question and identifies the file as containing zone data…
Read more
July 7, 2020
SQL Server error 906 Troubleshooting
Database,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
Database,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?
Database,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
Database,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
May 28, 2011
Mssql management studio issues – DB in general
Database,Error while opening Mssql 2005 management studio MMC could not create the snap-in.MMC could not create the snap-in. The snap-in might not have been installed correctly.Name: Microsoft SQL Enterprise ManagerCLSID: {00100100-1816-11D0-8EF5-00AA0062C58F} Fix Run the following command as shown to fix this. Make sure you have installed the Msql in the path as shown or change…
Read more
May 28, 2011
Shrink 2008 MSSQL database
Database,Shrinking SQL 2008 database is nowhere related to SQL 2000/2005 Method. Because SQL Server 2008 no longer allows you to truncate the transaction log using the no_log syntax But here is the special code to shrink the database: USE MASTER GO ALTER DATABASE database_name SET RECOVERY SIMPLE GO USE database_name GO DBCC SHRINKFILE (database_name_log, 1)…
Read more
May 28, 2011
SQL Server Port
Database,Scenario 1: SQL Is Not Connecting via Management Studio Locally After a Fresh Installation Step 1: Verify SQL Installation and Firewall Configuration After completing a fresh SQL installation and opening the required port in the firewall, you might still be unable to connect through SQL Management Studio.However, it’s important to note that installing SQL Server…
Read more
May 7, 2011
Steps to install SQL server 2008 with screenshot
Database,Windows General,Microsoft SQL Server 2008 Release to Manufacturing (RTM) was released in the August 2008. There are different versions of SQL Server 2008 available such as Enterprise, Standard, Workgroup, Web, Express, Compact and Developer editions. The trial version of Microsoft SQL Server 2008 can be downloaded from the following link
Read more
