Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The Oracle Database produces reports that are called AWR at specific periods and that share the general status of the database. You can use the …
Read More »Peer to Peer Transactional Replication On SQL Server
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“. …
Read More »Does it take a long time to delete the database 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 …
Read More »How to Fix “Cannot open backup device” Error?
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 …
Read More »How To Insert Random Data In PostgreSQL
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 …
Read More »Policy-Based Management(Check The Trustworthy Option Of Databases-Database Facet)
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 …
Read More »Instant File Initialization(Restore or Allocate Disk Space Faster)
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 …
Read More »What you should know before changing MySQL max_connections variable
Have you tried connecting to your MySQL server only to get the annoying error, “too many connections” ? This means that the number of …
Read More »Transactional Replication On 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 …
Read More »How to Change User Name in PostgreSQL
You have created a user in Postgresql, but software developer ask for change the user name or you have to change it for different …
Read More »