Databases

remove script - Remove shell script after usage

Remove shell script after usage

Here is a small script that does two things: Determinate script’s locationDelete the file #!/usr/bin/env bash // determinate where the script is SCRIPT_DIR=$( cd -- "$( dirname -- "${BASH_SOURCE[0]}" )" &> /dev/null && pwd ) //...

chrome v4Ol1D719y - How to add uuid-ossp extension to PostgreSQL

How to add uuid-ossp extension to PostgreSQL

PostgreSQL UUID (Universal Unique Identifier) is specified by RFC 4122 and has a 128-bit length.  Here We will cover two methods for enabling uuid-ossp extension to PostgreSQL: via CMD and PostgreSQL pgAdmin 4 GUI. Option 1. Enable uuid-ossp...

notepad 23Z4fPgsFR - Different Ways to Check MySQL version in cPanel or Linux

Different Ways to Check MySQL version in cPanel or Linux

By far MySQL is the most popular Relational database management system and knowing which MySQL version you are running can be important in some situations. Here are different ways to check the version of the MySQL server installed on your WHM/...

compass - How to enable remote access to MongoDB 🍃 in cPanel

How to enable remote access to MongoDB 🍃 in cPanel

Here is how to enable remote access to MongoDB in cPanel: Open port on the firewallEnable remote access in mongodb.confCreate a new admin user for mongodb Open default MongoDB port 27017 on firewall Default port for mongodb is 27017 so we need to...

SQL Server 2016 release What new does it have to offer Analytics ... - SQL String Concatenation

SQL String Concatenation

Have you ever wanted to retrieve a list of values from a table, storing the results in a string? Here is simple yet effective method without having to rely on cursors, while loops, or other complex structures. declare @string varchar(8000) select...

SQL Server 2016 release What new does it have to offer Analytics ... - Scheduled restart 🔄 of SQL server

Scheduled restart 🔄 of SQL server

As you may notice, Microsoft SQL Server will gradually consume more and more memory after it starts…Most people (myself included) will wonder if this means that there are memory leaks or unclosed connections.  While you should make sure...

Cover Image by MilesAndryPrower on DeviantArt

MySQL Database Vulnerability Scanning

Here is how to check MySQL databases for malware: Open up PHPMyAdminLook for anything ‘weird’ It’s that simple. What’s ‘weird’ you ask? Well, anything that’s ‘not supposed to be in the database’...

sql injection - How to find and stop SQL injection 💉 attacks

How to find and stop SQL injection 💉 attacks

There’s a lot of stuff out there about SQL injection attacks but there’s not much that will help you figure out how to stop these attacks from occurring. First, let’s talk about what a SQL Injection Attack really is. Some people...