Archivo del Autor: carlosap

How To Install MongoDB 4.4 on RHEL 8 | CentOS 8

In this guide, we will cover the steps to install MongoDB 4.4 on RHEL 8 / CentOS 8. MongoDB is an open source NoSQL database system written in C++ designed to ensure scalability, high performance, and availability. MongoDB common use case is storage and management of Big Data-sized collections of literal documents like text documents, email messages,… Leer más »

iptables OCI ubuntu 22.04 oracle cloud

source: https://docs.oracle.com/en-us/iaas/developer-tutorials/tutorials/apache-on-ubuntu/01oci-ubuntu-apache-summary.htm The Ubuntu firewall is disabled by default. However, you still need to update your iptables configuration to allow HTTP/HTTPS traffic. Update iptables with the following commands.Copy

How to assign permissions by schema in SQL Server

To assign permissions to a schema in SQL Server, you must first create a security role and assign permissions to the role. Then, assign the role to the desired user or group of users. Here is an example of code to assign SELECT permissions to a «test_schema» schema: sqlCopy code– Create a security role CREATE… Leer más »

SQL Duplicates Count Query for two or more columns

This query uses a commonly used query (CTE) to group the results and count duplicates in the zip_to_fips table. The first part of the query, the CTE, selects the columns «fips», «cnty_name» and adds an additional column «DuplicateCount» that uses the ROW_NUMBER() function to assign a unique number to each row that has equal values… Leer más »