MSSQL

  Merge Replication is a technology developed for applications that want to update on the same table through multiple servers. In other words, Publisher and …

You may get an error as follows when you want to change and save a column type or size in a table in the database. …

It uses the technology of Transactional Replication. As a difference, every subscriber is also publisher. You can read my article “Transactional Replication On SQL Server“. …

When you delete the database, remove the tick on “Delete backup and restore history information for databases” and check “Close existing connections”. Thus, the database …

When you want to back up your database, you may see “Cannot open backup device” error as you see in the picture below. To resolve …

In some cases, we may want to increase the size of the database by inserting random data into the database. In the script below, we …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  Instant File Initialization is a feature that introduced with SQL Server 2005 and Windows Server 2003-Windows XP. To enable this feature, the SQL Server …

  In order to understand this article more clearly, I suggest you read the article “SQL Server Replication Types“. First, the snaphot of the table …

  You have created a user in Postgresql, but software developer ask for change the user name or you have to change it for different …