Kenyus kenyus

kenyus / Generate CSR

Last active January 30, 2017 04:24

	1. Generating CSR: https://support.comodo.com/index.php?/Knowledgebase/Article/View/628/19/csr-generation-microsoft-iis-7x
	2. Completing CSR: https://ssl.comodo.com/support/certificate-installation-microsoft-iis-7x---8x.php
	3. Exporting Certificate: https://www.digicert.com/ssl-support/pfx-import-export-iis-8.htm
	3.1 Select Export on IIS: https://technet.microsoft.com/en-us/library/cc731386%28v=ws.10%29.aspx?f=255&MSPPError=-2147217396

kenyus / GitCommand.cmd

Last active November 17, 2016 22:46

GitHub Commands

	Setting the upstream for a fork

	Fetch from upstream: git fetch upstream

	If upstream is not set check the folowing.

	Checking remote: git remote -v

	Setup upstream: git remote add upstream https://github.com/fullcalendar/fullcalendar.git

kenyus / Recursive Insert.sql

Created October 17, 2016 00:47

Script to inset recursively without cursor in MSSQL

+INSERT INTO [dbo].[tblOperationItem] ([Order], [ItemType], [Group], [OperationId], [ItemId])
+SELECT TOP (12) [Order] = ROW_NUMBER() OVER (ORDER BY [object_id]), 0, 1, @@IDENTITY, i.ItemId
+FROM sys.all_objects, [dbo].[tblItem] i
+WHERE i.[ItemCode] = '825'
+ORDER BY [Order];

kenyus / gist:35a7e47d9224c1acbfcc

Created November 20, 2015 00:01

Windows & Network priority

	To force Windows to use a specific network connection, assign a metric value to each one, giving the lowest value to the desired connection:

	Open the Network Connections folder (Start > Run > ncpa.cpl)
	Right click the desired connection.
	Click Properties > Internet Protocol Version 4.
	Click Properties > Advanced.
	Un-check "Automatic metric".
	Enter a number between 1 and 9999 for the "Interface metric"."
	Manually set LAN to a larger integer than the wireless
	Ex: LAN [interface Metric: 3 ], wireless [interface Metric: 2 ]

kenyus / advancedsettings.xml

Last active September 19, 2015 10:01 — forked from SimpleHomelab/advancedsettings.xml

AdvacedSettings.xml for Kodi with MySQL and other tweaks.

	<!-- General Settings -->
	<advancedsettings>
	<loglevel hide="true">-1</loglevel> <!-- Comment: Disables logging -->
	<playcountminimumpercent>95</playcountminimumpercent>
	<skiploopfilter>0</skiploopfilter> <!-- Comment: For RPi or similar use 16 or higher (low CPU usage) -->
	<nodvdrom>true</nodvdrom>

	<!-- MySQL Library -->
	<videodatabase>
	<type>mysql</type>