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...

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...

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...

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...

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...

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...

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:...

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...

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...

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,...

Read more