Jairo Fernández jairoFernandez

🙃

creating....

jairoFernandez / reconfigure cmdshell

Created January 26, 2018 21:29

reconfigure cmdshell

	USE master;
	GO
	EXEC sp_configure 'show advanced option'

	USE master;
	GO
	EXEC sp_configure 'show advanced option', '1';
	RECONFIGURE WITH OVERRIDE;

jairoFernandez / Ubuntu-fix connection terminals

Created February 16, 2018 17:51

Server does not support diffie-hellman-group1-sha1 for keyexchange

	sudo nano /etc/ssh/sshd_config

	KexAlgorithms diffie-hellman-group1-sha1,[email protected],ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1
	Ciphers 3des-cbc,blowfish-cbc,aes128-cbc,aes128-ctr,aes256-ctr

	ssh-keygen -A

	sudo service ssh restart

jairoFernandez / MontarCarpetasUbuntu.sh

Created February 21, 2018 20:54

Script para compartir carpetas


	```sh
	sudo apt-get install cifs-utils smbclient

	sudo mount.cifs //IP/Cursos /home/punto_montaje/DIRECTORIO -o user=pepito dom=DOMINIO pass=PASSWORD
	sudo umount /home/punto_montaje/DIRECTORIO

	#https://www.upv.es/contenidos/INFOACCESO/infoweb/infoacceso/dat/724147normalc.html
	```

jairoFernandez / version.sql

Created April 5, 2018 20:55

See a version of sql

	SELECT
	CASE
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '9%' THEN 'SQL2005'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.0%' THEN 'SQL2008'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.5%' THEN 'SQL2008 R2'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '11%' THEN 'SQL2012'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '12%' THEN 'SQL2014'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '13%' THEN 'SQL2016'
	WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '14%' THEN 'SQL2017'

jairoFernandez / obtain-ssh-win.sh

Last active May 31, 2018 15:52

Obtener la llave ssh en windows!!!

	ssh-keygen -C "[email protected]"
	type %userprofile%\.ssh\id_rsa.pub # En cmd.exe

jairoFernandez / RestaurarDBSqlServer.sql

Created April 20, 2018 22:55

Restaura y crea un backup de una base de datos

	Backup Database ADMINFACELE TO DISK='C:\PRUEBAS\test.bak'

	RESTORE DATABASE TDR
	FROM DISK='C:\PRUEBAS\test.bak'
	GO

jairoFernandez / timer.js

Created June 2, 2018 21:46

Timer console

	console.time('someFunction');

	someFunction(); // run whatever needs to be timed in between the statements

	console.timeEnd('someFunction');

jairoFernandez / console.js

Created June 4, 2018 01:30

Imprimir consola

	(function () {
	if (!console) {
	console = {};
	}
	var old = console.log;
	var logger = document.getElementById('log');
	console.log = function (message) {
	if (typeof message == 'object') {
	logger.innerHTML += (JSON && JSON.stringify ? JSON.stringify(message) : String(message)) + '<br />';
	} else {

jairoFernandez / Reactjs-getstarted.html

Last active August 4, 2018 17:06

Get started with reactjs without node

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>Document</title>
	<script crossorigin src="https://unpkg.com/react@16/umd/react.development.js"></script>
	<script crossorigin src="https://unpkg.com/react-dom@16/umd/react-dom.development.js"></script>

jairoFernandez / Redux-fundamentals.html

Created August 4, 2018 18:21

Implementación básica de redux, sin react

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>Document</title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.0/redux.min.js"></script>
	</head>
	<body>