April 28, 2025
Exploring Database Servers: Real-Life Use Cases, Roles, and Core Benefits
Database Servers / DBMS,Disaster Recovery,Microsoft SQL Server/Oracle Database,mssql,MySQL,MySQL/PostgreSQL,NoSQL Database/MongoDB,Database Servers Demystified: What They Are and Why They Matter In the modern digital world, data is the core element that drives all applications. From e-commerce platforms and banking systems to healthcare portals and social media apps, every click, transaction, or search relies on data being processed and delivered in real time. At 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
May 28, 2011
Mssql management studio issues – DB in general
mssql,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
mssql,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
mssql,Scenario 1: SQL is not connecting via Management studio locally after a fresh Installation: 1. After a fresh Installation of SQL and opening the port in the Firewall you may not be able to connect via SQL management studio. Note: Installing SQL and opening the port in Firewall will not listen to the service/port. Its…
Read more
May 7, 2011
Steps to install SQL server 2008 with screenshot
mssql,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 http://www.microsoft.com/sql/2008/prodinfo/download.mspx. This article describes the steps…
Read more
