Saturday, September 28, 2019

instalar XMR Rig Raspbian

instalar XMR Rig Raspbian 10 Buster

sudo apt-get install git build-essential cmake libuv1-dev libssl-dev libhwloc-dev
sudo apt-get install gcc-5 g++-5
sudo update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-5 60 --slave /usr/bin/g++ g++ /usr/bin/g++-5
sudo update-alternatives --set gcc "/usr/bin/gcc-5"

git clone https://github.com/xmrig/xmrig.git
cd xmrig && mkdir build && cd build
cmake ..
make
#Crear Archivo Json de configuracion
sudo nano config.json
#despues pegar este codigo
{
    "algo": "cryptonight",  // cryptonight (default) or cryptonight-lite
    "av": 0,                // algorithm variation, 0 auto select
    "background": true,    // true to run the miner in the background
    "colors": true,         // false to disable colored output
    "cpu-affinity": null,   // set process affinity to CPU core(s), mask "0x3" for cores 0 and 1
    "cpu-priority": null,   // set process priority (0 idle, 2 normal to 5 highest)
    "donate-level": 1,      // donate level, mininum 1%
    "log-file": null,       // log all output to a file, example: "c:/some/path/xmrig.log"
    "max-cpu-usage": 100,    // maximum CPU usage for automatic mode, usually limiting factor is CPU cache not this option.
    "print-time": 20,       // print hashrate report every N seconds
    "retries": 5,           // number of times to retry before switch to backup server
    "retry-pause": 5,       // time to pause between retries
    "safe": false,          // true to safe adjust threads and av settings for current CPU
    "threads": 3,        // number of miner threads
    "pools": [
        {
            "url": "stratum+tcp://xmr.pool.minergate.com:45700",// "url": "",   // URL of mining server
            "user": "TuCuenta",// username for mining server
            "pass": "TuPasswd",// password for mining server
            "keepalive": true,// send keepalived for prevent timeout (need pool support)
            "nicehash": false // enable nicehash/xmrig-proxy support
        }
    ],
    "api": {
        "port": 0,                             // port for the miner API https://github.com/xmrig/xmrig/wiki/API
        "access-token": null,                  // access token for API
        "worker-id": null                      // custom worker-id for API
    }
}
#agregar al inicio la ejecucion del programa sudo nano /etc/rc.local # y aca pegar el codigo /home/pi/xmrig/build/./xmrig -t 3

Friday, September 6, 2019

reducir el tamaño del log.

ALTER DATABASE TUBBDD
SET RECOVERY SIMPLE;
GO

DBCC SHRINKFILE(TUBBDD_Log, 1);
GO

ALTER DATABASE TUBBDD
SET RECOVERY FULL;
GO

Monday, September 2, 2019

Desbloquear una cuenta
use master
go

ALTER LOGIN $LaCuentaADesbloquear$ with password=N'TuClave_Segura.2019' unlock
go

Monday, August 19, 2019




Con este comando pude tomar control desde una ruta Raiz, asi te vuelves owner.
takeown /f "Your Folder" /r /d y

con este eliminar
rmdir /q /s dir


Para subir archivos a la nube y olvidarte de la intermitencia
ROBOCOPY ORIGEN DESTINO /E > d:\log.txt

conectar una unidad de red por consola
net use X: "https://intranet.Server.com/sites/Zona/Documentos compartidos" MiPassWord /USER:MiDominio\MiUsuario

Enviar Correo via Linux
echo "Inicio de proceso de Respaldo" | mailx -s 'proceso de Respaldo' tuGmail@gmail.com

asignar un dia como nombre para una variable
#!/bin/bash
#DATE=$(date +%Y-%m-%d-%H%M%S)
DAY=$(date +%A)
#BACKUP_DIR="/carpetadestino /backup"
#SOURCE="$HOME/carpetaorigen"
#tar -cvzpf $BACKUP_DIR/backup-$DATE.tar.gz $SOURCE

conexion via consola para ejecutar script
sqlcmd -S  Servidor -U %user% -P passwd -i /media/Script.txt


compresion rapida via 7z con dia para tener 1 semana de respaldo.
7z a /media/Respaldo-$DAY.bak.7z /media/Respaldo/ -mx=1 -mmt=off

Sunday, July 7, 2019

Buscar la palabra casa dentro del directorio actual y sus subdirectorios.

FINDSTR /s /i "casa"  *.* > salida.txt

Sunday, June 9, 2019

Quitar aplicaciones de samsung via ADB Shell

se debe abrir adb y colocar los siguiente:
 adb shell
 pm uninstall -k --user 0 com.microsoft.skydrive
 pm uninstall -k --user 0 flipboard.boxer.app
 pm uninstall -k --user 0 com.sec.android.app.samsungapps
 pm uninstall -k --user 0 com.microsoft.office.powerpoint
 pm uninstall -k --user 0 com.microsoft.office.excel
 pm uninstall -k --user 0 com.microsoft.office.word
 pm uninstall -k --user 0 com.samsung.android.bixby.wakeup
 pm uninstall -k --user 0 com.samsung.android.bixby.es.globalaction
 pm uninstall -k --user 0 com.samsung.android.app.spage
 pm uninstall -k --user 0 com.samsung.android.bixby.plmsync
 pm uninstall -k --user 0 com.samsung.android.visionintelligence
 pm uninstall -k --user 0 com.samsung.android.bixby.agent
 pm uninstall -k --user 0 com.diotek.sec.lookup.dictionary
 pm uninstall -k --user 0 com.samsung.android.bixby.voiceinput
 pm uninstall -k --user 0 com.samsung.android.game.gamehome
 pm uninstall -k --user 0 com.samsung.android.widgetapp.yahooedge.sport
 pm uninstall -k --user 0 com.samsung.android.widgetapp.yahooedge.finance
 pm uninstall -k --user 0 com.gameloft.android.LATAM.GloftPDMF
 pm uninstall -k --user 0 com.google.android.music
 pm uninstall -k --user 0 com.google.android.videos
 pm uninstall -k --user 0 com.sec.android.service.health 
 pm uninstall -k --user 0 cl.movistar.android
 pm uninstall -k --user 0 com.smartboxtv.copamovistarchile
 pm uninstall -k --user 0 cl.movistarplay
 pm uninstall -k --user 0 com.amazon.mShop.android.shopping
 pm uninstall -k --user 0 com.gameloft.android.GloftSCRT
 pm uninstall -k --user 0 com.gameloft.android.GloftDMKF
 pm uninstall -k --user 0 com.samsung.android.samsungpass
 pm uninstall -k --user 0 com.samsung.android.email.provider
 pm uninstall -k --user 0 com.samsung.android.da.daagent
 pm uninstall -k --user 0 com.facebook.katana
 pm uninstall -k --user 0 com.google.android.gm
 pm uninstall -k --user 0 com.google.android.talk
 pm uninstall -k --user 0 com.sec.android.app.sbrowser
 pm uninstall -k --user 0 com.samsung.android.calendar
 pm uninstall -k --user 0 com.microsoft.office.onenote
 pm uninstall -k --user 0 com.sec.android.app.shealth
 pm uninstall -k --user 0 com.opera.max.oem
 pm uninstall -k --user 0 com.samsung.android.app.notes
 pm uninstall -k --user 0 com.osp.app.signin
 pm uninstall -k --user 0 com.skype.raider
 pm uninstall -k --user 0 com.samsung.android.easysetup
 pm uninstall -k --user 0 com.samsung.android.beaconmanager
 pm uninstall -k --user 0 com.sec.android.widgetapp.samsungapps

Tuesday, July 5, 2016

buscar ultimas modificaciones en la base de datos

SELECT tab.name AS Tablename,user_seeks, user_scans, user_lookups, user_updates,last_user_seek, last_user_scan, last_user_lookup, last_user_update FROM sys.dm_db_index_usage_stats ius INNER JOIN sys.tables tab ON (tab.object_id = ius.object_id) WHERE database_id = DB_ID(N'Nombre_BaseDeDatos') order by last_user_update desc