Skip to content

Instantly share code, notes, and snippets.

View csharpforevermore's full-sized avatar
🏠
Working from home

Randle csharpforevermore

🏠
Working from home
10 followers · 7 following
View GitHub Profile
@csharpforevermore
csharpforevermore / ClearEventViewerLogs.ps1
Created March 22, 2017 17:36
Clear Windows Event Viewer logs - all of them, rather than having to clear each manually. Original courtesy of Joe Waldin's blog at http://jpwaldin.com/blog/?p=166
wevtutil el | Foreach-Object {wevtutil cl "$_"}
@csharpforevermore
csharpforevermore / Program.cs
Created March 20, 2017 14:08
Console application. Uses EPPlus and Microsoft.Office.Interop.Excel packages through NuGet. Reads values from an Excel file (i.e. C:\Book1.xlsm) and outputs the values.
using System;
using System.Collections.Generic;
using System.IO;
using OfficeOpenXml;
namespace ReadExcelDocConsoleApplication
{
public class Program
{
static void Main(string[] args)
@csharpforevermore
csharpforevermore / GetVersionOfDatabase.sql
Created March 1, 2017 10:55
Returns the version of the current SQL database
select @@servername, @@version, serverproperty('edition')
@csharpforevermore
csharpforevermore / ChocoSetup.bat
Last active October 14, 2022 14:09
Chocolatey setup script for required development environment (see https://chocolatey.org/ for more information)
ECHO OFF
REM Install Chocolatey
@powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"
REM install password manager
cinst -y dashlane
REM Install browsers
cinst -y googlechrome
cinst -y firefox
@csharpforevermore
csharpforevermore / umbraco 7 db cleanup.sql
Last active December 15, 2021 14:02 — forked from dampee/umbraco db cleanup.sql
Umbraco Database cleanup. After pulling in an umbraco database from production, you don't need all history or log.
-- Umbraco Clear Old Document Versions To Decrease Database Size And Improve Performance
-- http://borism.net/2008/12/16/fixing-a-large-cmspropertydata-table-in-umbraco/
DECLARE @createdDate Datetime = DATEADD(m, -1, getdate())
-- dump logs
-- TRUNCATE TABLE umbracolog -- faster if log table is very big and you don't need anything
DELETE FROM umbracolog WHERE Datestamp < @createdDate
-- clean up old versions
DELETE FROM cmsPropertyData WHERE
@csharpforevermore
csharpforevermore / Counter.js
Created February 13, 2017 16:05
Counts 1 to 100 in JS
[][(![]+[])[+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(![]+[])[!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]][([][(![]+[])[+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(![]+[])[!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[][(![]+[])[+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(![]+[])[!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]])[+!+[]+[+[]]]+([][[]]+[])[+!+[]]+(![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[+!+[]]+([][[]]+[])[+[]]+([][(![]+[])[+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(![]+[])[!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[][(![]+[])[+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(![]+[])[!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]])[+!+[]+[+[]]]+(!![]+[])[+!+[]]]((+![]+[][([][(![]+[])[+[]]+([![]]+[][[]])[+!+[]+[+[]]]+(![]+[])[!+[]+!+[]]+(!![]+[])[+[]]+(!![]+[])[!+[]+!+[]+!+[]]+(!![]+[])[+!+[]]]+[])[!+[]+!+[]+!+[]]+(!![]+[][(![]+[])[+[]]+([![]]+[][[]])[+!+[
@csharpforevermore
csharpforevermore / cleanupUmb471.sql
Created January 25, 2017 10:19
Umbraco 4.7.1 clean-up DB
TRUNCATE TABLE umbracoLog
TRUNCATE TABLE umbracoUserLogins
-- Delete all related nodes and table contents
DELETE FROM cmsPreviewXml WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
DELETE FROM cmsContentVersion WHERE contentId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
DELETE FROM cmsDocument WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
DELETE FROM cmsContentXML WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
DELETE FROM cmsContent WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
DELETE FROM cmsPropertyData WHERE contentNodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
@csharpforevermore
csharpforevermore / FormsValidationExample.cs
Last active November 26, 2015 22:13 — forked from TimGeyssens/Umbraco Forms validation example
Umbraco Forms validation example
public class FormsValidation : ApplicationEventHandler
{
protected override void ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext)
{
Umbraco.Forms.Web.Controllers.UmbracoFormsController.FormValidate += UmbracoFormsController_FormValidate;
}
void UmbracoFormsController_FormValidate(object sender, Umbraco.Forms.Mvc.FormValidationEventArgs e)
{
@csharpforevermore
csharpforevermore / containsElements.js
Created November 9, 2015 13:50
Check if JavaScript array contains an element
function contains(a, obj) {
for (var i = 0; i < a.length; i++) {
if (a[i] === obj) {
return true;
}
}
return false;
}
@csharpforevermore
csharpforevermore / copySelectedText.js
Last active November 9, 2015 12:48
Copy selected text. The copied text is output in the HTML form textarea.
function copyit(theField) {
var selectedText = document.selection;
if (selectedText.type == 'Text') {
var newRange = selectedText.createRange();
theField.focus();
theField.value = newRange.text;
} else {
alert('select a text in the page and then press this button');
}
}