Useful tips for everyday
Is EC2 free tier free forever? Always Free: These free tier offers do not automatically expire at the end of your 12 month AWS Free…
How do I share data between Docker container and host? Using volume mounting Step 1: Create a volume. Start by creating a volume using this…
How do I forward logs to syslog? Forwarding Syslog Messages Log on to the Linux device (whose messages you want to forward to the server)…
How do you call SQL in PowerShell? Script run from PowerShell ISE: $SQLServer = “TestServerOne” $db3 = “TestDB3” $selectdata = “SELECT Id, IdData FROM invokeTable”…
What is a mutating table? A mutating table is a table that is currently being modified by an UPDATE, DELETE, or INSERT statement, or it…
How do I change the location of a MySQL database? Look for the entry for datadir , and change the path (which should be /var/lib/mysql…
What is the difference between PL SQL and PostgreSQL? PL/pgSQL is similar to PL/SQL in many aspects. It is a block-structured, imperative language, and all…
How Big Should partitions be Linux? The rule of thumb is that you choose between 1.5 to 2 times the amount of RAM as the…
Can I update primary key? You can modify a primary key in SQL Server by using SQL Server Management Studio or Transact-SQL. You can modify…
What is included in MySQL consultative support? Consultative Support1 is a proactive approach that is designed to help you avoid critical outages. MySQL Support Engineers…