Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »How To Find and Kill Long Running Queries In PostgreSQL
You can use the following queries to monitor the performance of the database or to find and kill queries that cause lock. The following …
Read More »How To Give Restrict Access To dmw and dmf To Logins Without Giving View_Server_State Permission
In the article “How To Authorize non-admin Logins To Read DMWs and DMFs“, I explained how to give dmw and dmf read privileges to …
Read More »