kzelda

Fix windows boot (tested with windows 10)

bootrec /FixMbr
bootrec /FixBoot
bootrec /ScanOs
bootrec /RebuildBcd

Fix the MBR – Guide for Windows XP, Vista, 7, 8, 8.1, 10

// default exports
export default 42;
export default {};
export default [];
export default (1 + 2);
export default foo;
export default function () {}
export default class {}
export default function foo () {}

Introduction

An introduction to curl using GitHub's API

The Basics

Makes a basic GET request to the specifed URI

curl https://api.github.com/users/caspyin

How to change your commit messages in Git?

At some point you’ll find yourself in a situation where you need edit a commit message. That commit might already be pushed or not, be the most recent or burried below 10 other commits, but fear not, git has your back 🙂.

Not pushed + most recent commit:

git commit --amend

This will open your $EDITOR and let you change the message. Continue with your usual git push origin master.

Git Cheat Sheet

Commands

Getting Started

git init

or

Git

Global Settings

Related Setup: https://gist.github.com/hofmannsven/6814278
Related Pro Tips: https://ochronus.com/git-tips-from-the-trenches/
Interactive Beginners Tutorial: http://try.github.io/
Git Cheatsheet by GitHub: https://services.github.com/on-demand/downloads/github-git-cheat-sheet/

Reminder

Press minus + shift + s and return to chop/fold long lines!

	using DocumentFormat.OpenXml.Packaging;
	using DocumentFormat.OpenXml.Spreadsheet;
	using System;
	using System.Collections.Generic;
	using System.Data;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;

	namespace ReadWriteExcelUsingOpenXml.Shared

	USE master
	GO

	/*

	EXEC PS_SHRINK_ALL_USER_DATABASES

	*/

	IF EXISTS(SELECT TOP 1 1 FROM sys.procedures WHERE name = 'PS_SHRINK_ALL_USER_DATABASES')

	private DataTable ReadExcelSheet(string fname, bool firstRowIsHeader)
	{
	List<string> Headers = new List<string>();
	DataTable dt = new DataTable();
	using (SpreadsheetDocument doc = SpreadsheetDocument.Open(fname, false))
	{
	//Read the first Sheets
	Sheet sheet = doc.WorkbookPart.Workbook.Sheets.GetFirstChild<Sheet>();
	Worksheet worksheet = (doc.WorkbookPart.GetPartById(sheet.Id.Value) as WorksheetPart).Worksheet;
	IEnumerable<Row> rows = worksheet.GetFirstChild<SheetData>().Descendants<Row>();

	ALTER TABLE myTable
	add createdAt datetime
	CONSTRAINT DF_myTable_createdat DEFAULT GETDATE()

	ALTER TABLE myTable
	add updatedAt datetime
	CONSTRAINT DF_myTable_updatedAt DEFAULT GETDATE()

	go