Archivo del Autor: carlosap
SQL Query for Counting Records per Day
This SQL query will add up the record count per day based on a column called “Timestamp.” Transact SQL SELECT DATEPART(YEAR, Timestamp) AS ‘Year’, DATEPART(MONTH, Timestamp) AS ‘Month’, DATEPART(DAY, Timestamp) AS ‘Day’, COUNT(*) AS ‘Visits’FROM tblVisitsGROUP BY DATEPART(DAY, Timestamp), DATEPART(MONTH, Timestamp), DATEPART(YEAR, Timestamp)ORDER BY ‘Year’, ‘Month’, ‘Day’ Results The results of this query will appear… Leer más »
Pandas Flask
mkdir pandas cd pandas python3 -m venv vpandas Activate the environment Before you work on your project, activate the corresponding environment: . vpandas/bin/activate pip3 install Flask python3 -m flask run –host=0.0.0.0
Check If A Linux System Is Physical Or Virtual Machine
Method 1 – Using Dmidecode utility The easiest way to find if we are working on a virtual or physical machine is using dmidecode utility. Dmidecode, DMI table decoder, is used find your system’s hardware components, as well as other useful information such as serial numbers and BIOS revision. Dmidecode comes pre-installed with most Linux distributions. Just in… Leer más »
How to avoid writing the owner (pub) of the table (schema) before referencing the table name in the SQL commands
Option #1Use the following statement in the same SQL session prior to running any SQL statements: set schema ‘pub’ Where ‘owner’ is the owner name, e.g. ‘PUB’. It will be valid until the end of the session or until it is changed. Option #2If using an ODBC DSN, set the default schema to the owner in the… Leer más »
VERACRYPT EN UBUNTU Y TU RASPBERRY POR TERMINAL
Compatiblidad truecrypt veracrypt archivo path -tc -m=nokernelcrypto Instalación en Ubuntu En Ubuntu lo instalaríamos mediante PPA: Fuente Instalación en Raspberry Instalamos las siguientes dependencias: Instalamos la última versión de Veracrypt que podemos encontrar en este enlace: Extraemos el archivo descargados: Instalamos ejecutando el script: Ahora seguiremos los pasos que nos pedirá el programa: 1 (instalar) Enter (aceptar la… Leer más »
How to compile Truecrypt 7.1a on Raspberry Pi
In case you want to use the Truecrypt 7.1a version on your Pi, follow these steps: Original post: https://lava-block.com/how-to-compile-truecrypt-7-1a-on-raspberry-pi/
Oracle VM manager: tabla OVM_STATISTIC y su crecimiento descontrolado ovm
En instalaciones de Oracle VM, la tabla que almacena las estadísticas de Oracle OVM Manager suele crecer de forma descontrolada. Si no se toma ninguna acción al respecto, termina con toda probabilidad (si no está bien monitorizado) provocando el llenado del filesystem /u01. [root@ovm-manager ovs]# ls -ltrh | grep -i stat -rw-rw—-. 1 oracle dba 13K Jul… Leer más »
UAV Mapping: Best practices for flight and data collection
https://blog.airworks.io/uav-mapping-best-practices-for-flight-and-data-collection
Predictive Monitoring of COVID-19 SUTD Data-Driven Innovation Lab
https://ddi.sutd.edu.sg México: https://ddi.sutd.edu.sg/portfolio/items/448588