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 »How To Authorize non-admin Logins To Read DMWs and DMFs
Some logins may want to see queries that requested from the database. They can see these queries from SQL Server DMWs(Dynamic Management View) and …
Read More »Tips when using ‘replace into’ and ‘insert … on duplicate key update…’ in MySQL
Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …
Read More »UPGRADE POSTGRESQL 10 To 11
We will upgrade POSTGRESQL 10 To 11 on CENTOS in this article. Before I start the upgrade process, I want to make the following critical …
Read More »